关于flash recover区-CSDN博客

flash recover区默认会备份控制文件和spfile的自动备份文件,和数据文件的副本,但我们一般控制文件和spfile文件的autoback都备份到每个数据库都可以访问的地方.

SQL> l
1* select name,value from v$parameter where upper(value) like '%D:\ORACLE\PRODUCT\10.2.0\ORADATA\
SQL> /

NAME
------------------------------
VALUE
----------------------------------------------------------------------------------------------------
control_files
+DISK_GROUP1/devdb/logfile/control01.ctl, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\CONTROL02.CTL, D:\O
\ORADATA\DEVDB\CONTROL03.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\CONTROL04.CTL

查看目前控制文件的位置

RMAN> backup as copy datafile 8;

启动 backup 于 24-1月 -08
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: sid=124 devtype=DISK
分配的通道: ORA_DISK_2
通道 ORA_DISK_2: sid=129 devtype=DISK
分配的通道: ORA_DISK_3
通道 ORA_DISK_3: sid=126 devtype=DISK
通道 ORA_DISK_1: 启动数据文件副本
输入数据文件 fno=00008 name=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\HR_DATA.DBF
输出文件名 = +DISK_GROUP1/devdb/datafile/hr_data.273.644862895 标记 = TAG2008012
4T163454 recid = 37 时间戳 = 644862897
通道 ORA_DISK_1: 数据文件复制完毕, 经过时间: 00:00:07
完成 backup 于 24-1月 -08

启动 Control File and SPFILE Autobackup 于 24-1月 -08
段 handle=D:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\C-537083282-20080124-00 comment
=NONE
完成 Control File and SPFILE Autobackup 于 24-1月 -08

RMAN> show all;

RMAN 配置参数为:
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 'd:\oracle\produ
ct\10.2.0\oradata\devdb\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFDEVDB.ORA'; # default