1Z0-032-16: Rman maintenance
已有备份保持时间,OS备份通过RMAN进行管理。验证备份有效性。
crosscheck:
验证backup or copy的有效性,及备份的存在。如果找不到则在catalog中标识为expired.
crosscheck backup of [tablespace users]; 可以出现备份是否过期或可利用。
crosscheck copy of [datafile ...]; 验证copy是否成功。
delete backup:
已经无效或过了时的备份 或copy;
动作: 删除物理备份; 更新catalog DB; resetlogs
语法:delete backup of tablespace users noprompt;
delete noprompt expired tablespace of users;
delete obsolete;
对备份进行再备份,并删除再备份过的备份集,datafile,controlfile;
backup archivelog all delete input;//这个操作有点危险,最好不要用,因它删除了所有的备份集。
backup archivelog delete input; //这个只删除指定备份集。
使备份有效或无效:
change copy of datafile 'd:/.../user01.dbf' unavailable|available;//可能不可以。
change datafilecopy 'd:/.../user01.dbf' unavailable|available;
change backup of ...... unavailable|available;
change backupset 3 unavailable;
change copy of archivelog sequence between 230 and 240 unavailable;
主要是在用rman进行修复时,决定其是否可用。如果unavailable则在restore和recover时将不会用这个备份。
使某些备份不受限制:
change backupset 123 keep forever nologs;
change datafile copy 'd:/.../user01.dbf' keep until time 'sysdate+60';
catalog使用户OS copy、controlfile、archivelog 记录到rman中,
catalog datafilecopy 'd:/.../users02.dbf';
catalog controlfilecopy 'd/.../control1.bak'; list copy of controlfile;
change archivelog ... uncatalog;
crosscheck:
验证backup or copy的有效性,及备份的存在。如果找不到则在catalog中标识为expired.
crosscheck backup of [tablespace users]; 可以出现备份是否过期或可利用。
crosscheck copy of [datafile ...]; 验证copy是否成功。
delete backup:
已经无效或过了时的备份 或copy;
动作: 删除物理备份; 更新catalog DB; resetlogs
语法:delete backup of tablespace users noprompt;
delete noprompt expired tablespace of users;
delete obsolete;
对备份进行再备份,并删除再备份过的备份集,datafile,controlfile;
backup archivelog all delete input;//这个操作有点危险,最好不要用,因它删除了所有的备份集。
backup archivelog delete input; //这个只删除指定备份集。
使备份有效或无效:
change copy of datafile 'd:/.../user01.dbf' unavailable|available;//可能不可以。
change datafilecopy 'd:/.../user01.dbf' unavailable|available;
change backup of ...... unavailable|available;
change backupset 3 unavailable;
change copy of archivelog sequence between 230 and 240 unavailable;
主要是在用rman进行修复时,决定其是否可用。如果unavailable则在restore和recover时将不会用这个备份。
使某些备份不受限制:
change backupset 123 keep forever nologs;
change datafile copy 'd:/.../user01.dbf' keep until time 'sysdate+60';
catalog使用户OS copy、controlfile、archivelog 记录到rman中,
catalog datafilecopy 'd:/.../users02.dbf';
catalog controlfilecopy 'd/.../control1.bak'; list copy of controlfile;
change archivelog ... uncatalog;