RMAN+多路复用方式实现数据安全的策略

 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'