Control file backup and recovery (RMAN tool)

This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost;

This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost;

This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost;

I have written an article about manual "backup and recovery of Control Files". refer:

Database Version

SQL> select * from v $ version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production

C: \ Documents ents and Settings \ Administrator> rman target/catalog rm_user/rm_user

Recovery MANAGER: Release 11.2.0.1.0-Production on Sunday August 11 16:00:49 2013
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connect to the target database: ORCL (DBID = 1318810635)
Connect to recover directory database

View rman Configuration

RMAN> show all;
The RMAN Configuration Parameter of the database where db_unique_name is ORCL is:
Configure retention policy to redundancy 1; # default
Configure backup optimization off; # default
Configure default device type to disk; # default
Configure controlfile autobackup on;
Configure controlfile autobackup format for device type disk to 'f: \ rmanbackup \ controlfile \ % F ';
Configure device type disk parallelism 1 backup type to backupset; # default
Configure datafile backup copies for device type disk to 1; # default
Configure archivelog backup copies for device type disk to 1; # default
Configure channel device type disk format 'd: \ backup \ % d _ % s. bak ';
Configure maxsetsize to unlimited; # default
Configure encryption for database off; # default
Configure encryption algorithm 'aes128 '; # default
Configure compression algorithm 'basic 'as of release 'default' optimize for load true; # DEFAULT
Configure archivelog deletion policy to none; # default
Configure snapshot controlfile name to 'e: \ APP \ ADMINISTRATOR \ PRODUCT \ 11.2.0 \ DBHOME_1 \ DATABASE \ SNCFORCL. ORA '; # default

This indicates that the backup policy of the control file is automatic backup. A data file is backed up at will (the control file automatically backed up when the data file is backed up this time)

RMAN> backup datafile 7;


Start backup from September 11 to September 13.
Use channel ORA_DISK_1
Channel ORA_DISK_1: starting all data file backup Sets
Channel ORA_DISK_1: Specifies the data file in the backup set.
Input data file: File No. = 00007 name = E: \ RMAN. DBF
Channel ORA_DISK_1: Starting segment 1 from September 13 to September 13
Channel ORA_DISK_1: Completed segment 1 from September 11 to September 13
Segment handle = D: \ BACKUP \ ORCL_167.BAK flag = TAG20130811T152451 annotation = NONE
Channel ORA_DISK_1: Backup set completed. elapsed time: 00: 00: 03
The backup task is completed from September 11 to September 13.


Start Control File and SPFILE Autobackup from September 11 to September 13.
Segment handle = F: \ RMANBACKUP \ CONTROLFILE \ C-1318810635-20130811-00 comment = NONE
Complete Control File and SPFILE Autobackup from to 13


RMAN> shutdown immediate;
Database closed
Database uninstalled
Oracle instance disabled

Manually delete all control files;

The recovery steps are as follows;

RMAN> startup nomount;
The database has been started.


RMAN> restore controlfile from autobackup;


Start restore from 11 to 8 months to 13 months
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: restore command (on 15:28:47) failed
RMAN-06004: Restoring Catalog Database ORACLE error: ORA-03114: not connected to ORACLE


The connection to the database has been disconnected after the database is closed;

RMAN> exit

The recovery manager is complete.

Next, let's take a look at the highlights of page 2nd:

Recommended reading:

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption