RMAN+多路复用方式实现数据安全的策略
添加控制文件:
alter system set control_files='+WDFDATA/wdfwms/controlfile/current.260.942065661','/home/wdforadata/controlfile/control.ctl' scope=spfile;
shutdown immediate;
su - grid
asmcmd
cd .............
cp current.260.942065661 /home/wdforadata/controlfile/control.ctl
chmod 777 /home/wdforadata/controlfile/control.ctl
su - oracle
sqlplus / as sysdba
startup;
添加日志复用组:
alter database add logfile member '/home/wdforadata/logfile/redo01b.log'to group 1;
alter database add logfile member '/home/wdforadata/logfile/redo02b.log'to group 2;
alter database add logfile member '/home/wdforadata/logfile/redo03b.log'to group 3;
alter database add logfile member '/home/wdforadata/logfile/redo04b.log'to group 4;
alter database add logfile member '/home/wdforadata/logfile/redo05b.log'to group 5;
归档日志配置:
alter system set db_recovery_file_dest='/home/wdforadata/archivelog' scope=spfile;
alter system set db_recovery_file_dest_size=800G scope=spfile;
shutdown immediate;
startup mount;
alter database archivelog;
备注:‘archivelog’为 归档模式;‘noarchivelog’为非归档模式。
archive log list
configure retention policy to recovery window of 1 days;
configure controlfile autobackup on;
alter system set control_file_record_keep_time=20;
configure retention policy to recovery window of 0 days;
configure device type disk parallelism 8;
0级备份:
rman target / log=/home/wdforadata/rman.log
crosscheck archivelog all;
crosscheck backupset;
delete obsolete;
y
backup incremental level 0 cumulative database;
exit
exit
mail -s "wdfwms_backup" xiazc@wdfcsls.com < /home/wdforadata/rman.log
1级备份:
rman target / log=/home/wdforadata/rman.log
crosscheck archivelog all;
crosscheck backupset;
delete obsolete;
y
backup incremental level 1 cumulative database;
exit
exit
mail -s "wdfwms_backup" xiazc@wdfcsls.com < /home/wdforadata/rman.log
归档日志处理办法:
区别已经很明显:
list archivelog until time 'sysdate-1'; 此时是按照归档日志开始时间即fisrt_time作为截止时间
list archivelog all completed before 'sysdate-1' 是按照归档日志完成时间即completion_time作为截止时间
试想如果删除归档日志,还是采用delete archivelog all completed before 'sysdate-N'
RMAN+多路复用方式实现数据安全的策略
添加控制文件:
alter system set control_files='+WDFDATA/wdfwms/controlfile/current.260.942065661','/home/wdforadata/controlfile/control.ctl' scope=spfile;
shutdown immediate;
su - grid
asmcmd
cd .............
cp current.260.942065661 /home/wdforadata/controlfile/control.ctl
chmod 777 /home/wdforadata/controlfile/control.ctl
su - oracle
sqlplus / as sysdba
startup;
添加日志复用组:
alter database add logfile member '/home/wdforadata/logfile/redo01b.log'to group 1;
alter database add logfile member '/home/wdforadata/logfile/redo02b.log'to group 2;
alter database add logfile member '/home/wdforadata/logfile/redo03b.log'to group 3;
alter database add logfile member '/home/wdforadata/logfile/redo04b.log'to group 4;
alter database add logfile member '/home/wdforadata/logfile/redo05b.log'to group 5;
归档日志配置:
alter system set db_recovery_file_dest='/home/wdforadata/archivelog' scope=spfile;
alter system set db_recovery_file_dest_size=800G scope=spfile;
shutdown immediate;
startup mount;
alter database archivelog;
备注:‘archivelog’为 归档模式;‘noarchivelog’为非归档模式。
archive log list
configure retention policy to recovery window of 1 days;
configure controlfile autobackup on;
alter system set control_file_record_keep_time=20;
configure retention policy to recovery window of 0 days;
configure device type disk parallelism 8;
0级备份:
rman target / log=/home/wdforadata/rman.log
crosscheck archivelog all;
crosscheck backupset;
delete obsolete;
y
backup incremental level 0 cumulative database;
exit
exit
mail -s "wdfwms_backup" xiazc@wdfcsls.com < /home/wdforadata/rman.log
1级备份:
rman target / log=/home/wdforadata/rman.log
crosscheck archivelog all;
crosscheck backupset;
delete obsolete;
y
backup incremental level 1 cumulative database;
exit
exit
mail -s "wdfwms_backup" xiazc@wdfcsls.com < /home/wdforadata/rman.log
归档日志处理办法:
区别已经很明显:
list archivelog until time 'sysdate-1'; 此时是按照归档日志开始时间即fisrt_time作为截止时间
list archivelog all completed before 'sysdate-1' 是按照归档日志完成时间即completion_time作为截止时间
试想如果删除归档日志,还是采用delete archivelog all completed before 'sysdate-N'