揭秘ORACLE備份之----RMAN之五(CATALOG)
[root@rhel5 ~]# su - oracle
[oracle@rhel5 ~]$ rman catalog
Recovery Manager: Release 10.2.0.5.0 - Production on Thu Sep 5 04:20:38 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to recovery catalog database
RMAN> create catalog;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user SCOTT
RMAN> -- catalog管理使用者必須要有RECOVERY_CATALOG_OWNER角色
RMAN> exit
Recovery Manager complete.
[oracle@rhel5 ~]$ sqlplus / as sysdba
SQL> grant recovery_catalog_owner to scott;
Grant succeeded.
-- 授權後再次建立CATALOG
[oracle@rhel5 ~]$ rman catalog
RMAN> create catalog;
recovery catalog created
-- 建立CATALOG管理使用者
[oracle@rhel5 ~]$ sqlplus / as sysdba
SQL> create user rman identified by rman;
User created.
SQL> grant recovery_catalog_owner to rman;
Grant succeeded.
SQL> alter user rman quota 100m on user01;
User altered.
SQL> grant connect,resource to rman;
Grant succeeded.
[oracle@rhel5 ~]$ rman catalog
RMAN> --刪除catalog
RMAN> drop catalog;
recovery catalog owner is SCOTT
enter DROP CATALOG command again to confirm catalog removal
RMAN> drop catalog;
recovery catalog dropped
-- 建立RMAN使用者管理的CATALOG
[oracle@rhel5 ~]$ rman catalog
RMAN> create catalog;
recovery catalog created
-- RMAN使用者生成了CATALOG管理的相關物件
[oracle@rhel5 ~]$ sqlplus rman/rman
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Sep 5 04:26:46 2013
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_BACKUP_SET_SUMMARY VIEW
RC_BACKUP_DATAFILE_SUMMARY VIEW
RC_BACKUP_CONTROLFILE_SUMMARY VIEW
RC_BACKUP_ARCHIVELOG_SUMMARY VIEW
RC_BACKUP_SPFILE_SUMMARY VIEW
RC_BACKUP_COPY_SUMMARY VIEW
RC_PROXY_COPY_SUMMARY VIEW
RC_PROXY_ARCHIVELOG_SUMMARY VIEW
RC_UNUSABLE_BACKUPFILE_DETAILS VIEW
RC_RMAN_BACKUP_TYPE VIEW
XAL TABLE
RSR TABLE
FB TABLE
GRSP TABLE
RC_DATABASE VIEW
RC_DATABASE_INCARNATION VIEW
RC_RESYNC VIEW
RC_CHECKPOINT VIEW
RC_TABLESPACE VIEW
RC_DATAFILE VIEW
RC_TEMPFILE VIEW
RC_REDO_THREAD VIEW
RC_REDO_LOG VIEW
RC_LOG_HISTORY VIEW
RC_ARCHIVED_LOG VIEW
RC_BACKUP_SET VIEW
RC_BACKUP_PIECE VIEW
RC_BACKUP_DATAFILE VIEW
RC_BACKUP_CONTROLFILE VIEW
RC_BACKUP_SPFILE VIEW
RC_DATAFILE_COPY VIEW
RC_CONTROLFILE_COPY VIEW
RC_BACKUP_REDOLOG VIEW
RC_BACKUP_CORRUPTION VIEW
RC_COPY_CORRUPTION VIEW
RC_OFFLINE_RANGE VIEW
RC_STORED_SCRIPT VIEW
RC_STORED_SCRIPT_LINE VIEW
RC_PROXY_DATAFILE VIEW
RC_PROXY_CONTROLFILE VIEW
RC_RMAN_CONFIGURATION VIEW
RC_DATABASE_BLOCK_CORRUPTION VIEW
RC_PROXY_ARCHIVEDLOG VIEW
RC_RMAN_STATUS VIEW
ROUT TABLE
RC_RMAN_OUTPUT VIEW
RCVER TABLE
RC_BACKUP_FILES VIEW
RC_RMAN_BACKUP_SUBJOB_DETAILS VIEW
RC_RMAN_BACKUP_JOB_DETAILS VIEW
RC_BACKUP_SET_DETAILS VIEW
RC_BACKUP_PIECE_DETAILS VIEW
RC_BACKUP_COPY_DETAILS VIEW
RC_PROXY_COPY_DETAILS VIEW
RC_PROXY_ARCHIVELOG_DETAILS VIEW
RC_BACKUP_DATAFILE_DETAILS VIEW
RC_BACKUP_CONTROLFILE_DETAILS VIEW
RC_BACKUP_ARCHIVELOG_DETAILS VIEW
RC_BACKUP_SPFILE_DETAILS VIEW
DB TABLE
NODE TABLE
CONF TABLE
DBINC TABLE
CKP TABLE
TS TABLE
TSATT TABLE
DF TABLE
DFATT TABLE
TF TABLE
TFATT TABLE
OFFR TABLE
RR TABLE
RT TABLE
ORL TABLE
RLH TABLE
AL TABLE
BS TABLE
BP TABLE
BCF TABLE
CCF TABLE
XCF TABLE
BSF TABLE
BDF TABLE
CDF TABLE
XDF TABLE
BRL TABLE
BCB TABLE
CCB TABLE
SCR TABLE
SCRL TABLE
CONFIG TABLE
91 rows selected.
-- 將目標庫註冊為CATALOG管理
[oracle@rhel5 ~]$ rman target / catalog
Recovery Manager: Release 10.2.0.5.0 - Production on Thu Sep 5 04:27:09 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: WAILON (DBID=2747751647)
connected to recovery catalog database
RMAN> --註冊catalog
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
-- 使用CATALOG管理後可以建立RMAN管理的備份指令碼
RMAN> create script full_backup
2> {
3> backup database;
4> delete obsolete;
5> }
-- 執行備份指令碼
RMAN> run {execute script full_backup;}
executing script: full_backup
Starting backup at 05-SEP-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=21 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/wailon/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/wailon/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oradata/wailon/untotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/wailon/user01.dbf
channel ORA_DISK_1: starting piece 1 at 05-SEP-13
channel ORA_DISK_1: finished piece 1 at 05-SEP-13
piece handle=/u01/app/flash_recovery_area/0coj2dmt_1_1.bkp tag=TAG20130905T042812 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 05-SEP-13
channel ORA_DISK_1: finished piece 1 at 05-SEP-13
piece handle=/u01/app/flash_recovery_area/0doj2dnc_1_1.bkp tag=TAG20130905T042812 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-SEP-13
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03015: error occurred in stored script full_backup
RMAN-03002: failure of delete command at 09/05/2013 04:28:31
RMAN-06525: RMAN retention policy is set to none
-- 檢視備份指令碼
RMAN> print script full_backup;
printing stored script: full_backup
{backup database;
delete obsolete;
}
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31536640/viewspace-2155675/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 揭祕ORACLE備份之----RMAN之五(CATALOG)Oracle
- Oracle 備份恢復篇之RMAN catalogOracle
- oracle之rman備份Oracle
- Oracle備份之RMAN工具(四)Oracle
- Oracle備份之RMAN工具(三)Oracle
- Oracle備份之RMAN工具(二)Oracle
- Oracle備份之RMAN工具(一)Oracle
- 揭祕ORACLE備份之----RMAN之二(備份方式)Oracle
- 探索ORACLE之RMAN_05備份策略Oracle
- 揭祕ORACLE備份之----RMAN之四(塊跟蹤)Oracle
- Oracle Rman Catalog的建立方法和備份原理Oracle
- Oracle RMAN備份中catalog和nocatalog區別Oracle
- RMAN說,我能備份(18)--RMAN中的加密備份和CATALOG加密
- RMAN備份與恢復之加密備份加密
- RMAN備份 建立catalog資料庫資料庫
- 建立RMAN catalog實現物理備份
- ORACLE rman備份之ORA-00230Oracle
- Oracle資料庫備份與恢復之RMANOracle資料庫
- Oracle資料庫RMAN小結之備份部分Oracle資料庫
- RMAN加密備份之口令加密加密
- RMAN筆記之備份集和備份片筆記
- 使用Catalog命令註冊RMAN備份集
- 揭祕ORACLE備份之----RMAN之一(引數配置)Oracle
- RMAN備份之備份多個備份集到帶庫(三)
- RMAN備份之備份多個備份集到帶庫(二)
- RMAN備份之備份多個備份集到帶庫(一)
- rman備份恢復命令之switch
- Oracle資料庫備份與恢復之RMAN2Oracle資料庫
- 探索ORACLE之RMAN_03一致性備份Oracle
- RMAN備份、恢復實驗室 之 備份篇 【rman: can't open target】
- oracle rman catalogOracle
- rman備份驗證(之restore validate)REST
- Oracle RMAN 增量備份Oracle
- oracle rman備份命令Oracle
- 【轉】Oracle rman備份Oracle
- RMAN備份中catalog和nocatalog區別[轉]
- RMAN筆記之查詢rman備份資訊狀態筆記
- 循序漸進oracle第7章:備份與恢復之RMAN完整備份指令碼Oracle指令碼