备份集迁移到其他目录后加入到catalog的过程
来源:互联网 发布:alias软件 编辑:程序博客网 时间:2024/05/21 14:00
http://blog.chinaunix.net/uid-77311-id-3035955.html
下面演示将备份集mv到其他目录后加入catalog的过程.
下面演示将备份集mv到其他目录后加入catalog的过程.
1.列出当前的备份集信息(当前的备份集位于目录/u01/rman_backup/2011/201111/)
- RMAN> list backup;
- using target database control file instead of recovery catalog
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 4 Full 351.26M DISK 00:00:51 30-NOV-11
- BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/df_768589674_5_1.bak
- List of Datafiles in backup set 4
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/system01.dbf
- 4 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/users01.dbf
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 5 Full 173.91M DISK 00:00:55 30-NOV-11
- BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/df_768589674_6_1.bak
- List of Datafiles in backup set 5
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/undotbs01.dbf
- 3 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/sysaux01.dbf
- 5 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/hxl01.dbf
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 6 Full 6.77M DISK 00:00:03 30-NOV-11
- BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/df_768589733_7_1.bak
- Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 7 Full 80.00K DISK 00:00:02 30-NOV-11
- BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/df_768589735_8_1.bak
- SPFILE Included: Modification time: 30-NOV-11
2.将备份集mv到目录/u01/rman_backup/2011/201111/mybak
- [oracle@hxl 201111]$ ls-1
- 20111130
- df_768589674_5_1.bak
- df_768589674_6_1.bak
- df_768589733_7_1.bak
- df_768589735_8_1.bak
- mybak
- [oracle@hxl 201111]$mv*.bak ./mybak
3.校验当前的备份集,因为备份集迁移到了其他目录,所以crosscheck后标记为EXPIRED.
- RMAN> crosscheck backup;
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: sid=147 devtype=DISK
- crosschecked backup piece: foundto be 'EXPIRED'
- backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
- crosschecked backup piece: foundto be 'EXPIRED'
- backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
- crosschecked backup piece: foundto be 'EXPIRED'
- backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
- crosschecked backup piece: foundto be 'EXPIRED'
- backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
- Crosschecked 4 objects
4.删除过期的备份集
- RMAN> delete expired backup;
- using channel ORA_DISK_1
- List of Backup Pieces
- BP Key BS Key Pc# Cp# Status Device Type Piece Name
- ------- ------- --- --- ----------- ----------- ----------
- 4 4 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_5_1.bak
- 5 5 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589674_6_1.bak
- 6 6 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589733_7_1.bak
- 7 7 1 1 EXPIRED DISK /u01/rman_backup/2011/201111/df_768589735_8_1.bak
- Do you really want todelete the above objects (enter YES or NO)? YES
- deleted backup piece
- backup piece handle=/u01/rman_backup/2011/201111/df_768589674_5_1.bak recid=4 stamp=768589674
- deleted backup piece
- backup piece handle=/u01/rman_backup/2011/201111/df_768589674_6_1.bak recid=5 stamp=768589674
- deleted backup piece
- backup piece handle=/u01/rman_backup/2011/201111/df_768589733_7_1.bak recid=6 stamp=768589735
- deleted backup piece
- backup piece handle=/u01/rman_backup/2011/201111/df_768589735_8_1.bak recid=7 stamp=768589737
- Deleted 4 EXPIRED objects
5.查看当前的备份集,因为标记为过期的备份集已经删除,所以当前catalog里没有备份集的记录.
- RMAN> list backup;
6.逐个将备份集加入到catalog里
- RMAN> catalog backuppiece'/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak';
- cataloged backuppiece
- backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=12 stamp=769250367
- RMAN> catalog backuppiece'/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak';
- cataloged backuppiece
- backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak recid=13 stamp=769250424
- RMAN> catalog backuppiece'/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';
- cataloged backuppiece
- backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak recid=14 stamp=769250451
- RMAN> catalog backuppiece'/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak';
- cataloged backuppiece
- backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak recid=15 stamp=769250478
7.列出迁移到mybak目录后的备份集
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 4 Full 351.26M DISK 00:00:51 30-NOV-11
- BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
- List of Datafiles in backup set 4
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/system01.dbf
- 4 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/users01.dbf
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 5 Full 173.91M DISK 00:00:55 30-NOV-11
- BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
- List of Datafiles in backup set 5
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/undotbs01.dbf
- 3 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/sysaux01.dbf
- 5 Full 530571 30-NOV-11/u01/app/oracle/oradata/oracl/hxl01.dbf
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 6 Full 6.77M DISK 00:00:03 30-NOV-11
- BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
- Control File Included: Ckp SCN: 530571 Ckp time: 30-NOV-11
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 7 Full 80.00K DISK 00:00:02 30-NOV-11
- BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20111130T170752
- Piece Name:/u01/rman_backup/2011/201111/mybak/df_768589735_8_1.bak
- SPFILE Included: Modification time: 30-NOV-11
CATALOG常用方法:
1.扫描备份片
CATALOG BACKUPPIECE '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak';
2.扫描归档日志
CATALOG ARCHIVELOG '/u01/rman_backup/archive_bak/archlog_78922.bak';
3.扫描数据文件拷贝,并且将其做为增量备份的level 0
CATALOG DATAFILECOPY '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak' LEVEL 0;
4.扫描控制文件拷贝
CATALOG CONTROLFILECOPY '/u01/app/oracle/oradata/oracl/control01.ctl'
5.扫描整个目录
CATALOG START WITH '/u01/rman_backup/2011/201111/mybak';
6.扫描闪回恢复区
CATALOG RECOVERY AREA NOPROMPT;
- 备份集迁移到其他目录后加入到catalog的过程
- 将ORACLE数据库数据文件迁移到其他目录
- 将JTable加入到JScrollPane后,无法向JScrollPane中添加其他的组件的解决方案
- qt工程release迁移到其他电脑后图片无法显示的问题
- .NET 关于区别TimeOut后迁移到TimeOut画面与直接通过URL迁移到其他画面(没通过login画面)的解决方案
- SVN迁移到Git的过程
- 将表迁移到其他的表空间
- AWR元数据的迁移或导入到其他数据库
- Linux下的SVN如何迁移到其他机器
- 【Oracle】迁移表到其他的表空间
- 10g 特性: catalog start with 将RMAN备份集恢复到另一台机器
- 其他数据库平台迁移到mysql思路
- 迁移AWR快照到其他库
- mysql 数据库迁移到其他数据库
- pg_dump 迁移表到其他模式
- 关于sql备份到其他服务器的问题
- 关于sql备份到其他服务器的问题
- Ubuntu 16.04 /home 目录迁移到独立分区的方法
- 这个交易基金优于共同基金有几个原因
- Magento后台操作视频学习
- Java获取当前时间
- Android 开发环境配置
- PCI-E×16、PCI-E×4
- 备份集迁移到其他目录后加入到catalog的过程
- SA,SD和SE的差别
- Linux awk
- UITabbarController使用汇总
- 让google map 动起来
- CDocument
- Shell学习总结
- 第13周实验--任务2--设计一个抽象类
- What’s In The Index? What’s Changed?