揭秘ORACLE备份之----RMAN之五（CATALOG）
[root@rhel5 ~]# su - oracle
[oracle@rhel5 ~]$ rman catalogscott/tiger@wailon
创新互联公司是专业的江南网站建设公司，江南接单;提供网站建设、网站设计,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行江南网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!
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 catalogscott/tiger@wailon
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 catalogscott/tiger@wailon
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 catalogrman/rman@wailon
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 / catalogrman/rman@wailon
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;
}
网站名称：揭秘ORACLE备份之----RMAN之五（CATALOG）
网站链接：http://6mz.cn/article/pcdijs.html