备份

备份:

rman:

rman>backup database;

rman>backup as copydatabase;

rman>backup as compressed backupset database;

backup as copy db_file_name_convert=('+data/aa','/backup/test') database

1>备份视图:

v$rman_configration

v$rman_output

v$rman_status

v$block_change_tracking alter database enable block change tracking using '/u02/ab/bct.dbf';

2>flash recovery area:

   db_recovery_file_dest, db_recovery_file_dest_size

alter system set db_recovery_file_dest = +asm2 scope=both sid='*'

rac要保证每个节点相同.ASM存储不能定义具体的目录.

3>rman备份方法:

   交互式备份. list backup,exit

   批处理备份  ran target / cmdfile=back.ram log=bb.log

   stored script备份.

           create script full_backup {backup database plus archivelog

                                                delete obsolete}

rman>run{run execute script full_backup;}

4>察看现有备份:

show all

5>配置备份:

1>  配置控制文件自动备份.

rman>configure controlfile autobackup on;

rman>configure controlfile autobackup format for device type to 'autobackup_control_F%'

  配置控制文件快照备份位置

2>配置备份文件格式 :(BACKUP SET ,IMAGE COPY)

RMAN>CONFIRURE  DEVICE TYPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET

rman>configure device type disk backup type to copy

3>配置和改变备份保留策略(基于窗口和冗余)

rman>configure retention policy to recovery window of 7 days:

rman>configure retention policy to redundancy 2;

rman>configure retention policy to none;

rman>show retention policy;

rman>report obsolete;

rman>report obsolete window of 7 days;

rman>configure controlfile autobackup format for device type disk clear;

增量备份,累计增量备份:

backup incremental level 1 database

backup incremental level 1 cumulative database;

backup database

backup archivelog all

backup duration 2:00 database;

对备份进行检查:

crosscheck copy.

list copy

delete obsolete copy

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8568259/viewspace-2120269/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8568259/viewspace-2120269/