欢迎进入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]