【RMAN】使用恢復目錄catalog備份目標資料庫的演示
1.連線到目標資料庫
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:16:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
2.連線到恢復目錄
RMAN> connect catalog rman_catalog/hsw@secooler
connected to recovery catalog database
3.以備份控制檔案演示一下備份的過程
RMAN> backup current controlfile;
Starting backup at 2009-07-28 16:17:46
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-07-28 16:17:47
channel ORA_DISK_1: finished piece 1 at 2009-07-28 16:17:48
piece handle=/oracle/app/oracle/flash_recovery_area/ORA10G/backupset/2009_07_28/o1_mf_ncnnf_TAG20090728T161747_56xf1cz4_.bkp tag=TAG20090728T161747 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009-07-28 16:17:48
RMAN>
4.發現了吧，沒有出現“using target database control file instead of recovery catalog”的提示資訊，因為我們使用的是恢復目錄進行備份的嘛。
--------------------------------------------------------------------------
5.最後演示一下取消註冊到恢復目錄的效果
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:23:28 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
RMAN> connect catalog rman_catalog/hsw@secooler
connected to recovery catalog database
RMAN> unregister database;
database name is "ORA10G" and DBID is 4010369505
Do you really want to unregister the database (enter YES or NO)? y
database unregistered from the recovery catalog
RMAN> exit
Recovery Manager complete.
ora10g@testdb /home/oracle$
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:24:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
RMAN> backup current controlfile;
Starting backup at 2009-07-28 16:24:15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-07-28 16:24:17
channel ORA_DISK_1: finished piece 1 at 2009-07-28 16:24:18
piece handle=/oracle/app/oracle/flash_recovery_area/ORA10G/backupset/2009_07_28/o1_mf_ncnnf_TAG20090728T162416_56xffk2q_.bkp tag=TAG20090728T162416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 2009-07-28 16:24:18
RMAN>
-- The End --
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:16:29 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
2.連線到恢復目錄
RMAN> connect catalog rman_catalog/hsw@secooler
connected to recovery catalog database
3.以備份控制檔案演示一下備份的過程
RMAN> backup current controlfile;
Starting backup at 2009-07-28 16:17:46
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=134 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-07-28 16:17:47
channel ORA_DISK_1: finished piece 1 at 2009-07-28 16:17:48
piece handle=/oracle/app/oracle/flash_recovery_area/ORA10G/backupset/2009_07_28/o1_mf_ncnnf_TAG20090728T161747_56xf1cz4_.bkp tag=TAG20090728T161747 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009-07-28 16:17:48
RMAN>
4.發現了吧，沒有出現“using target database control file instead of recovery catalog”的提示資訊，因為我們使用的是恢復目錄進行備份的嘛。
--------------------------------------------------------------------------
5.最後演示一下取消註冊到恢復目錄的效果
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:23:28 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
RMAN> connect catalog rman_catalog/hsw@secooler
connected to recovery catalog database
RMAN> unregister database;
database name is "ORA10G" and DBID is 4010369505
Do you really want to unregister the database (enter YES or NO)? y
database unregistered from the recovery catalog
RMAN> exit
Recovery Manager complete.
ora10g@testdb /home/oracle$
ora10g@testdb /home/oracle$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 28 16:24:06 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORA10G (DBID=4010369505)
RMAN> backup current controlfile;
Starting backup at 2009-07-28 16:24:15
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=137 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-07-28 16:24:17
channel ORA_DISK_1: finished piece 1 at 2009-07-28 16:24:18
piece handle=/oracle/app/oracle/flash_recovery_area/ORA10G/backupset/2009_07_28/o1_mf_ncnnf_TAG20090728T162416_56xffk2q_.bkp tag=TAG20090728T162416 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 2009-07-28 16:24:18
RMAN>
-- The End --
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/519536/viewspace-610650/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle 備份恢復篇之RMAN catalogOracle
- 透過搭建恢復目錄實現RMAN異地備份和恢復
- 備份恢復Lesson 04.Using the RMAN Recovery Catalog
- RMAN備份恢復典型案例——資料庫卡頓資料庫
- 使用RMAN備份資料庫資料庫
- ORACLE DG從庫 Rman備份恢復Oracle
- rman 增量備份恢復
- RMAN備份恢復技巧
- 備份與恢復：polardb資料庫備份與恢復資料庫
- 資料庫備份恢復資料庫
- RMAN備份異機恢復
- 12 使用RMAN備份和恢復檔案
- 使用Mysqldump備份和恢復MySQL資料庫MySql資料庫
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- PostgreSql資料庫的備份和恢復SQL資料庫
- SqlServer資料庫恢復備份資料的方法SQLServer資料庫
- RMAN備份恢復效能優化優化
- RMAN備份與恢復測試
- Mysql資料庫備份及恢復MySql資料庫
- 達夢資料庫備份恢復資料庫
- postgresql備份與恢復資料庫SQL資料庫
- oracle資料庫使用rman備份指令碼Oracle資料庫指令碼
- RMAN備份恢復典型案例——資料檔案存在壞快
- mysqldump使用方法(MySQL資料庫的備份與恢復)MySql資料庫
- RMAN備份恢復典型案例——快速檢查資料庫一致性資料庫
- 揭秘ORACLE備份之----RMAN之五（CATALOG）Oracle
- dg丟失歸檔，使用rman增量備份恢復
- rman備份異機恢復（原創）
- 資料庫備份與恢復技術資料庫
- Mongo 資料庫備份和恢復命令Go資料庫
- pg_dump 備份，恢復資料庫資料庫
- RMAN備份恢復典型案例——異機恢復未知DBID
- 利用RMAN備份重建資料庫資料庫
- 在DG備庫備份資料庫並恢復到一個主機上，報錯RMAN-06820資料庫
- 資料庫資料恢復—無備份，binlog未開啟的Mysql資料庫資料恢復案例資料庫資料恢復MySql
- 帝國CMS備份資料壓縮存放目錄
- Oracle Rman Catalog的建立方法和備份原理Oracle
- Linux下MySQL資料庫的備份與恢復LinuxMySql資料庫
- mongodb資料庫備份與恢復（資料庫資料遷移）MongoDB資料庫