这个部分描述了如何使用BACKUP BACKUPSET命令从磁盘到磁带拷贝备份集。
这里假设你已经配置了SBT设备做为你的默认设备。
练习:从磁盘到磁带备份备份集
|
-- 1. 如果备份可用的备份集的子集,先以概览的形式显示备份集 RMAN> LIST BACKUPSET SUMMARY;
List of Backups =============== Key TY LV S Device Type Completion Time #Pieces #Copies Comp Tag --- -- -- - ----------- --------------- ------- ------- ---- --- 1 B F A DISK 28-MAY-07 1 1 NO TAG20070528T132432 2 B F A DISK 29-MAY-07 1 1 NO TAG20070529T132433 3 B F A DISK 30-MAY-07 1 1 NO TAG20070530T132434
--1.1 显示备份集3的细节 RMAN> LIST BACKUPSET 3;
List of Backup Sets ===================
BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 3 Full 8.33M DISK 00:00:01 30-MAY-07 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20070530T132434 Piece Name: /disk1/oracle/dbs/c-35764265-20070530-02 Control File Included: Ckp SCN: 397221 Ckp time: 30-MAY-07 SPFILE Included: Modification time: 30-MAY-07 SPFILE db_unique_name: PROD
-- 2. 执行BACKUP BACKUPSET命令 -- 2.1 备份所有的磁盘备份集到磁带,然后删除输入的磁盘备份 BACKUP BACKUPSET ALL DELETE INPUT;
-- 2.2 只备份主键为1和2的备份集到磁带,然后删除输入的磁盘备份 BACKUP BACKUPSET 1,2 DELETE INPUT;
-- 3. (可选),执行LIST命令查看备份集和备份片的列表,显示所有的拷贝,包括使用BACKUP BACKUPSET命令创建的备份片的拷贝 |
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1087834/ ,如需转载,请注明出处,否则将追究法律责任。