Oracle Database物理文件之控制文件

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 -- 连接到目标数据库 RMAN connect target /; connected to target database: ORCL （DBID=1364371964） -- 备份控制文件 RMAN backup current controlfile; Starting backup at 23-FEB-14 using ta

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

 

　　-- 连接到目标数据库

　　RMAN> connect target /;

　　connected to target database: ORCL （DBID=1364371964）

　　-- 备份控制文件

　　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/o1_mf_ncnnf_TAG20140223T094340_9jlnlfnn_.bkp tag=TAG20140223T094340 comment=NONE

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

　　Finished backup at 23-FEB-14

　　-- 备份数据库及控制文件，数据库需要处于archivelog模式下

　　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/o1_mf_nnndf_TAG20140223T095613_9jlo9y7y_.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/o1_mf_ncsnf_TAG20140223T095613_9jlof8l7_.bkp tag=TAG20140223T095613 comment=NONE

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

　　Finished backup at 23-FEB-14

　　-- 查看当前的RMAN 参数设定

　　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;  -- 默认自动备份控制文件为关闭状态

　　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';

　　-- 设置开启RMAN自动备份控制文件

　　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

　　五 控制文件的缺失恢复

　　1.丢失多个控制文件中的一个或多个

　　缺失多个控制文件中的一个或多个，数据库启动时会报ORA-00205错误，导致数据库无法启动，如下：

　　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

　　-- 查看警告日志的位置，一般在数据库参数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/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

　　-- 查看警告日志中的错误信息，找不到控制文件

　　[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]