Control File for physical files of OracleDatabase

Welcome to the Oracle community forum and interact with 2 million technical staff-connect to the target database RMANconnecttarget; connectedtotargetdatabase: ORCL (DBID1364371964)-backup control file RMANbackupcurrentcontrolfile; Startingbackupat23-FEB-14usingta

Welcome to the Oracle community forum and interact with 2 million technical staff> go to -- connect to the target database RMAN connect target/; connected to target database: ORCL (DBID = 1364371964) -- backup control file RMAN backup current controlfile; Starting backup at 23-FEB-14 using ta

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

-- Connect to the target database

RMAN> connect target /;

Connected to target database: ORCL (DBID = 1364371964)

-- Backup control file

RMAN> backup current controlfile;

Starting backup at 23-FEB-14

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID = 21 device type = DISK

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Including current control file in backup set

Channel ORA_DISK_1: starting piece 1 at 23-FEB-14

Channel ORA_DISK_1: finished piece 1 at 23-FEB-14

Piece handle =/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_02_23/empty _. bkp tag = TAG20140223T094340 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 23-FEB-14

-- Backup the database and control file. The database must be in archivelog mode.

RMAN> backup database include current controlfile;

Starting backup at 23-FEB-14

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID = 142 device type = DISK

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Input datafile file number = 00001 name =/u01/app/oracle/oradata/orcl/system01.dbf

Input datafile file number = 00002 name =/u01/app/oracle/oradata/orcl/sysaux01.dbf

Input datafile file number = 00003 name =/u01/app/oracle/oradata/orcl/undotbs01.dbf

Input datafile file number = 00005 name =/u01/app/oracle/oradata/orcl/example01.dbf

Input datafile file number = 00004 name =/u01/app/oracle/oradata/orcl/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 23-FEB-14

Channel ORA_DISK_1: finished piece 1 at 23-FEB-14

Piece handle =/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_02_23/empty _. bkp tag = TAG20140223T095613 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Including current control file in backup set

Including current SPFILE in backup set

Channel ORA_DISK_1: starting piece 1 at 23-FEB-14

Channel ORA_DISK_1: finished piece 1 at 23-FEB-14

Piece handle =/u01/app/oracle/flash_recovery_area/ORCL/backupset/2014_02_23/empty _. bkp tag = TAG20140223T095613 comment = NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 23-FEB-14

-- View the current RMAN parameter settings

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORCL are:

Configure retention policy to redundancy 1;

Configure backup optimization off;

Configure default device type to disk;

Configure controlfile autobackup off; -- the automatic backup control file is disabled by default.

Configure controlfile autobackup format for device type disk to '% F ';

Configure device type disk parallelism 1 backup type to backupset;

Configure datafile backup copies for device type disk to 1;

Configure archivelog backup copies for device type disk to 1;

Configure maxsetsize to unlimited;

Configure encryption for database off;

Configure encryption algorithm 'aes128 ';

Configure compression algorithm 'basic 'as of release 'default' optimize for load true;

Configure archivelog deletion policy to none;

Configure snapshot controlfile name to '/u01/app/oracle/product/11.20.1/db_1/dbs/snapcf_orcl.f ';

-- Set to enable RMAN automatic backup control file

RMAN> configure controlfile autobackup on;

Old RMAN configuration parameters:

Configure controlfile autobackup off;

New RMAN configuration parameters:

Configure controlfile autobackup on;

New RMAN configuration parameters are successfully stored

5. Restore missing control files

1. loss of one or more control files

If one or more of the multiple control files are missing, a ORA-00205 error is reported when the database is started, causing the database to fail to start, as shown below:

Idle> startup

ORACLE instance started.

Total System Global Area 1050411008 bytes

Fixed Size 1341168 bytes

Variable Size 641730832 bytes

Database Buffers 402653184 bytes

Redo Buffers 4685824 bytes

ORA-00205: error in identifying control file, check alert log for more info

-- View the location of the warning log, usually in the directory specified by the database parameter background_dump_dest

Idle> show parameter dump

NAME TYPE VALUE

-----------------------------------------------------------------------------

Background_core_dump string partial

Background_dump_dest string/u01/app/oracle/diag/rdbms/orcl/trace

Core_dump_dest string/u01/app/oracle/diag/rdbms/orc l/orcl/cdump

Max_dump_file_size string unlimited

Shadow_core_dump string partial

User_dump_dest string/u01/app/oracle/diag/rdbms/orc l/orcl/trace

-- View the error information in the warning log. The control file cannot be found.

[Oracle @ db trace] $ tail-f alert_orcl.log

Sun Feb 23 10:08:13 2014

ALTER DATABASE MOUNT

ORA-00210: cannot open the specified control file

ORA-00202: control file: '/u01/app/oracle/flash_recovery_area/orcl/control02.ctl'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-205 signalled during: alter database mount...

Sun Feb 23 10:08:14 2014

Checker run found 1 new persistent data failures

[1] [2] [3] [4]