数据备份当然是为数据恢复准备,新环境的oracle一直在进行备份,但都没有测试验证备份的有效性,所以本次测试的重要性不言而喻了!以下为WIN平台下RMAN异机恢复实例。
源库 |
目标库 |
|
操作系统 |
WIN SVR 2008 R2 |
WIN SVR 2008 R2 |
主机名 |
Ora |
ORATEST |
IP |
192.168.18.20 |
192.168.18.25 |
数据库版本 |
11.2.0.1.0 |
11.2.0.1.0 |
存储方式 |
单实例 |
单实例 |
ORACLE_HOME |
D:\app\Administrator\product\11.2.0\dbhome_1 |
D:\app\Administrator\product\11.2.0\dbhome_1 |
ORACLE_SID |
HWPROD |
HWPROD |
源库备份操作:
相关备份配置及脚本如下:
RMAN> show all;
db_unique_name 为 HWPROD 的数据库的 RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO RECOVERYWINDOW OF 3 DAYS; #保留备份为3天
CONFIGURE BACKUP OPTIMIZATION OFF; #default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default
CONFIGURE CONTROLFILE AUTOBACKUP ON; #需要打开自动备份
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO 'e:\data_backup\
ctl_%F.bak'; #指定备份控制文件及参数文件备份路径格式
CONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; #default
CONFIGURE ENCRYPTION FOR DATABASE OFF; #default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOA
D TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TONONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHO
ME_1\DATABASE\SNCFHWPROD.ORA'; # default
full_backup.sql
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
backup as compressed backupset fulldatabase format 'e:\data_backup\full_%d_%s_%p_%u_%t.bak';
sql 'alter system archive logcurrent';
backup archivelog all format'e:\data_backup\log_%d_%s_%p_%u_%t.bak' delete all inp