CATALOG DATABASE 目录库的创建
CATALOG DATABASE 目录库的创建
概述 1、catalog database 的功能
1）集中存放rman的资料库（备份的元数据），并且可以和target database 的controlfile 同步。
2）存放rman的备份脚本。
2、catalog database 的配置
1）需要建立一个单独的database
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string cuug
db_unique_name string cuug
global_names boolean FALSE
instance_name string cuug
lock_name_space string
log_file_name_convert string
service_names string cuug
一、新建表空间 新建立一个表空间，专门用来存放目录库的元数据，也可以用已经存放的表空间
SYS @ cuug > create tablespace cattbs datafile '/u01/app/oracle/oradata/cuug/cattbs01.dbf' size 100m;
Tablespace created.
SYS @ cuug > select file_id,file_name,tablespace_name from dba_data_files;
FILE_ID FILE_NAME TABLESPACE_NAME
---------- -------------------------------------------------- ------------------------------
4 /u01/app/oracle/oradata/cuug/users01.dbf USERS
3 /u01/app/oracle/oradata/cuug/sysaux01.dbf SYSAUX
2 /u01/app/oracle/oradata/cuug/undotbs01.dbf UNDOTBS1
1 /u01/app/oracle/oradata/cuug/system01.dbf SYSTEM
5 /u01/app/oracle/oradata/cuug/cattbs01.dbf CATTBS
二、在新建的表空间上建立一个用户并授权 ———— 建立RMAN用户
SQL> create user rman identified by oracle default tablespace cattbs;
User created.
————查看要RMAN用户要用到的CATALOG DB权限
SQL> select role from dba_roles where role like '%CATA%';
ROLE
------------------------------
SELECT_CATALOG_ROLE
EXECUTE_CATALOG_ROLE
DELETE_CATALOG_ROLE
RECOVERY_CATALOG_OWNER
————授权
SQL> grant connect,resource,RECOVERY_CATALOG_OWNER to rman;
Grant succeeded.
三、启动LSNR
配置TNSNAMES ————启动LSNR
S
[oracle@backup dbs]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Cuuguction on 20-DEC-2011 17:31:41
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/cuuguct/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Cuuguction
System parameter file is /u01/app/oracle/cuuguct/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/cuuguct/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backup)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Cuuguction
Start Date 20-DEC-2011 17:31:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/cuuguct/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/cuuguct/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backup)(PORT=1521)))
Services Summary...
Service "plsextproc" has 1 instance(s).
Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@backup dbs]$ lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Cuuguction on 20-DEC-2011 17:32:00
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Cuuguction
Start Date 20-DEC-2011 17:31:42
Uptime 0 days 0 hr. 0 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/cuuguct/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/cuuguct/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=backup)(PORT=1521)))
Services Summary...
Service "cuug" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuugXDB" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuug_XPT" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
Service "plsextproc" has 1 instance(s).
Instance "plsextproc", status UNKNOWN, has 1 handler(s) for this service...
Service "cuug" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuugXDB" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
Service "cuug_XPT" has 1 instance(s).
Instance "cuug", status READY, has 1 handler(s) for this service...
The command completed successfully
————设置TNSNAMES
[oracle@backup admin]$ cd /u01/app/oracle/cuuguct/10.2.0/db_1/network/admin
[oracle@backup admin]$ vi tnsnames.ora
cuug =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.8.147)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.147)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CUUG)
)
)
[oracle@backup ~]$ sqlplus sys/oracle@cuug as sysdba
SQL*Plus: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 17:40:47 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Cuuguction
With the Partitioning, OLAP and Data Mining options
[oracle@backup ~]$ sqlplus rman/oracle@cuug
SQL*Plus: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 17:48:00 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Cuuguction
With the Partitioning, OLAP and Data Mining options
四、连接RMAN ————连接RMAN
[oracle@backup ~]$ export ORACLE_SID=cuug
[oracle@backup ~]$ rman catalog rman/oracle@cuug
Recovery Manager: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 17:52:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN>
————查看RMAN用户无任何对象
[oracle@backup admin]$ export ORACLE_SID=cuug
[oracle@backup admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 17:58:17 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Cuuguction
With the Partitioning, OLAP and Data Mining options
SQL> conn rman/oracle
Connected.
SQL> select * from tab;
no rows selected
五、建立CATALOG对象（资料库） ————连接RMAN
[oracle@backup ~]$ export ORACLE_SID=cuug
[oracle@backup ~]$ rman catalog rman/oracle@cuug
Recovery Manager: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 17:52:18 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to recovery catalog database
RMAN>
————用RMAN用户连接到库CUUG的RMAN，在目录库（资料库）CUUG上建立所需对象
RMAN> create catalog;
recovery catalog created
————建立完成后查看RMAN用户的对象
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
DB TABLE
NODE TABLE
CONF TABLE
DBINC TABLE
CKP TABLE
TS TABLE
TSATT TABLE
DF TABLE
DFATT TABLE
TF TABLE
TFATT TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
OFFR TABLE
RR TABLE
RT TABLE
ORL TABLE
RLH TABLE
AL TABLE
BS TABLE
BP TABLE
BCF TABLE
CCF TABLE
XCF TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BSF TABLE
BDF TABLE
CDF TABLE
XDF TABLE
BRL TABLE
BCB TABLE
CCB TABLE
SCR TABLE
SCRL TABLE
CONFIG TABLE
XAL TABLE
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RSR TABLE
FB 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
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
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
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
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
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
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
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_BACKUP_CONTROLFILE_DETAILS VIEW
RC_BACKUP_ARCHIVELOG_DETAILS VIEW
RC_BACKUP_SPFILE_DETAILS VIEW
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
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
RC_UNUSABLE_BACKUPFILE_DETAILS VIEW
RC_RMAN_BACKUP_TYPE VIEW
90 rows selected.
————生成了90个对象
SQL> desc rc_database;
Name Null? Type
----------------------------------------- -------- ----------------------------
DB_KEY NOT NULL NUMBER
DBINC_KEY NUMBER
DBID NOT NULL NUMBER
NAME NOT NULL VARCHAR2(8)
RESETLOGS_CHANGE# NOT NULL NUMBER
RESETLOGS_TIME NOT NULL DATE
————对象RC_DATABASE 存放注册的目标库
SQL> select name from rc_database;
no rows selected
六、注册目标库到目录库 ————RMAN连接同时连接目标库和目录库
[oracle@backup ~]$ rman target sys/oracle@cuug catalog rman/oracle@cuug
Recovery Manager: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 18:14:57 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: CUUG (DBID=181201175)
connected to recovery catalog database
————注册目标库到目录库
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
————在目录库上查看RMAN用户的对象RC_DATABASE
SQL> select name from rc_database;
NAME
--------
CUUG
————查看对象RC_DATAFILE
SQL> desc rc_datafile;
Name Null? Type
----------------------------------------- -------- ----------------------------
DB_KEY NOT NULL NUMBER
DBINC_KEY NOT NULL NUMBER
DB_NAME NOT NULL VARCHAR2(8)
TS# NOT NULL NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
FILE# NOT NULL NUMBER
CREATION_CHANGE# NOT NULL NUMBER
CREATION_TIME DATE
DROP_CHANGE# NUMBER
DROP_TIME DATE
BYTES NUMBER
BLOCKS NUMBER
BLOCK_SIZE NOT NULL NUMBER
NAME VARCHAR2(1024)
STOP_CHANGE# NUMBER
STOP_TIME DATE
READ_ONLY NOT NULL NUMBER
RFILE# NUMBER
INCLUDED_IN_DATABASE_BACKUP NOT NULL VARCHAR2(3)
AUX_NAME VARCHAR2(1024)
ENCRYPT_IN_BACKUP VARCHAR2(3)
SQL> select db_name,tablespace_name,file#,name,bytes from rc_datafile;
DB_NAME TABLESPACE_NAME FILE# NAME BYTES
-------- ------------------------------ ---------- -------------------------------------------------- ----------
CUUG SYSTEM 1 /u01/app/oracle/oradata/cuug/system01.dbf 503316480
CUUG UNDOTBS1 2 /u01/app/oracle/oradata/cuug/undotbs01.dbf 68157440
CUUG SYSAUX 3 /u01/app/oracle/oradata/cuug/sysaux01.dbf 272629760
CUUG USERS 4 /u01/app/oracle/oradata/cuug/users01.dbf 5242880
CUUG CATTBS 5 /u01/app/oracle/oradata/cuug/cattbs01.dbf 104857600
这些信息都是通过目标库的控制文件同步过来的
SQL> desc RC_BACKUP_FILES
Name Null? Type
----------------------------------------------------------------- -------- --------------------------- PKEY NUMBER
BACKUP_TYPE VARCHAR2(32)
FILE_TYPE VARCHAR2(32)
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(13)
STATUS VARCHAR2(16)
FNAME VARCHAR2(1024)
TAG VARCHAR2(32)
MEDIA VARCHAR2(80)
RECID NUMBER
STAMP NUMBER
DEVICE_TYPE VARCHAR2(255)
BLOCK_SIZE NUMBER
COMPLETION_TIME DATE
COMPRESSED VARCHAR2(3)
OBSOLETE VARCHAR2(3)
BYTES NUMBER
BS_KEY NUMBER
BS_COUNT NUMBER
BS_STAMP NUMBER
BS_TYPE VARCHAR2(32)
BS_INCR_TYPE VARCHAR2(32)
BS_PIECES NUMBER
BS_COPIES NUMBER
BS_COMPLETION_TIME DATE
BS_STATUS VARCHAR2(16)
BS_BYTES NUMBER
BS_COMPRESSED VARCHAR2(3)
BS_TAG VARCHAR2(1024)
BS_DEVICE_TYPE VARCHAR2(255)
BP_PIECE# NUMBER
BP_COPY# NUMBER
DF_FILE# NUMBER
DF_TABLESPACE VARCHAR2(30)
DF_RESETLOGS_CHANGE# NUMBER
DF_CREATION_CHANGE# NUMBER
DF_CHECKPOINT_CHANGE# NUMBER
DF_CKP_MOD_TIME DATE
RL_THREAD# NUMBER
RL_SEQUENCE# NUMBER
RL_RESETLOGS_CHANGE# NUMBER
RL_FIRST_CHANGE# NUMBER
RL_FIRST_TIME DATE
RL_NEXT_CHANGE# NUMBER
RL_NEXT_TIME
SQL> select BACKUP_TYPE,FILE_TYPE,FNAME,BYTES,STATUS from RC_BACKUP_FILES;
select BACKUP_TYPE,FILE_TYPE,FNAME,BYTES,STATUS from RC_BACKUP_FILES
*
ERROR at line 1:
ORA-20021: database not set
ORA-06512: at "RMAN.DBMS_RCVMAN", line 18237
ORA-06512: at "RMAN.RC_LBRECSETIMPL_T", line 53
————以生上面错误后，做了如下操作
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
190 Full 7.36M DISK 00:00:00 20-DEC-11
BP Key: 193 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142736
Piece Name: /u01/app/oracle/flash_recovery_area/CUUG/autobackup/2011_12_20/o1_mf_s_770394456_7h0bps9q_.bkp
Control File Included: Ckp SCN: 1562150 Ckp time: 20-DEC-11
SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
191 Full 7.36M DISK 00:00:00 20-DEC-11
BP Key: 194 Status: AVAILABLE Compressed: NO Tag: TAG20111220T142637
Piece Name: /u01/app/oracle/flash_recovery_area/CUUG/autobackup/2011_12_20/o1_mf_s_770394397_7h0bnxkc_.bkp
Control File Included: Ckp SCN: 1562096 Ckp time: 20-DEC-11
SPFILE Included: Modification time: 20-DEC-11
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
192 Full 7.36M DISK 00:00:02 20-DEC-11
BP Key: 195 Status: AVAILABLE Compressed: NO Tag: TAG20111220T143404
Piece Name: /u01/app/oracle/flash_recovery_area/CUUG/autobackup/2011_12_20/o1_mf_s_770394844_7h0c2y0d_.bkp
Control File Included: Ckp SCN: 1562236 Ckp time: 20-DEC-11
SPFILE Included: Modification time: 20-DEC-11
RMAN> resync catalog;
starting full resync of recovery catalog
full resync complete
RMAN> report schema;
Report of database schema
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 480 SYSTEM YES /u01/app/oracle/oradata/cuug/system01.dbf
2 25 UNDOTBS1 YES /u01/app/oracle/oradata/cuug/undotbs01.dbf
3 260 SYSAUX NO /u01/app/oracle/oradata/cuug/sysaux01.dbf
4 10 USERS NO /u01/app/oracle/oradata/cuug/users01.dbf
5 20 TEST NO /u01/app/oracle/oradata/cuug/test01.dbf
6 20 LX NO /u01/app/oracle/oradata/cuug/lx01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /u01/app/oracle/oradata/cuug/temp01.dbf
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
1 0 /u01/app/oracle/oradata/cuug/system01.dbf
2 0 /u01/app/oracle/oradata/cuug/undotbs01.dbf
3 0 /u01/app/oracle/oradata/cuug/sysaux01.dbf
4 0 /u01/app/oracle/oradata/cuug/users01.dbf
5 0 /u01/app/oracle/oradata/cuug/test01.dbf
6 0 /u01/app/oracle/oradata/cuug/lx01.dbf
RMAN> backup database format='/disk1/rman/cuug/%U';
Starting backup at 20-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/cuug/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/cuug/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/cuug/undotbs01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/cuug/test01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/cuug/lx01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/cuug/users01.dbf
channel ORA_DISK_1: starting piece 1 at 20-DEC-11
channel ORA_DISK_1: finished piece 1 at 20-DEC-11
piece handle=/disk1/rman/cuug/31mun0rk_1_1 tag=TAG20111220T183532 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:26
Finished backup at 20-DEC-11
Starting Control File and SPFILE Autobackup at 20-DEC-11
piece handle=/u01/app/oracle/flash_recovery_area/CUUG/autobackup/2011_12_20/o1_mf_s_770409419_7h0sbf7b_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 20-DEC-11
————还是出现如下错误信息
SQL> select BACKUP_TYPE,FILE_TYPE,FNAME,BYTES,STATUS from RC_BACKUP_FILES;
select BACKUP_TYPE,FILE_TYPE,FNAME,BYTES,STATUS from RC_BACKUP_FILES
*
ERROR at line 1:
ORA-20021: database not set
ORA-06512: at "RMAN.DBMS_RCVMAN", line 18237
ORA-06512: at "RMAN.RC_LBRECSETIMPL_T", line 53
SQL> desc RC_BACKUP_SET_DETAILS
Name Null? Type
----------------------------------------------------------------- -------- --------------------------------------------
SESSION_KEY NUMBER
SESSION_RECID NUMBER
SESSION_STAMP NUMBER
DB_KEY NUMBER
DB_NAME VARCHAR2(8)
BS_KEY NUMBER
RECID NUMBER
STAMP NUMBER
SET_STAMP NUMBER
SET_COUNT NUMBER
BACKUP_TYPE VARCHAR2(1)
CONTROLFILE_INCLUDED VARCHAR2(7)
INCREMENTAL_LEVEL NUMBER
PIECES NUMBER
START_TIME DATE
COMPLETION_TIME DATE
ELAPSED_SECONDS NUMBER
BLOCK_SIZE VARCHAR2
KEEP VARCHAR2(3)
KEEP_UNTIL DATE
KEEP_OPTIONS VARCHAR2(10)
DEVICE_TYPE VARCHAR2(255)
COMPRESSED VARCHAR2(3)
NUM_COPIES NUMBER
OUTPUT_BYTES NUMBER
ORIGINAL_INPUT_BYTES NUMBER
COMPRESSION_RATIO NUMBER
STATUS CHAR(1)
ORIGINAL_INPRATE_BYTES NUMBER
OUTPUT_RATE_BYTES NUMBER
ORIGINAL_INPUT_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_BYTES_DISPLAY VARCHAR2(4000)
ORIGINAL_INPRATE_BYTES_DISPLAY VARCHAR2(4000)
OUTPUT_RATE_BYTES_DISPLAY VARCHAR2(4000)
TIME_TAKEN_DISPLAY VARCHAR2(4000)
SQL> select db_name,stamp,keep,backup_type from RC_BACKUP_SET_DETAILS;
DB_NAME STAMP KEE B
-------- ---------- --- -
CUUG 770409421 NO D
CUUG 770409411 NO D
770394761 NO D
770394761 NO D
770394846 NO D
SQL> select * from rc_database;
DB_KEY DBINC_KEY DBID NAME RESETLOGS_CHANGE# RESETLOGS
---------- ---------- ---------- -------- ----------------- ---------
1 2 181201175 CUUG 1562130 20-DEC-11
________________________________________
————利用catalog database存放rman 脚本
————创建脚本（replace 是修改已经存在的脚本）
[oracle@backup ~]$ rman target sys/oracle@cuug catalog rman/oracle@cuug
Recovery Manager: Release 10.2.0.1.0 - Cuuguction on Tue Dec 20 18:14:57 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: CUUG (DBID=181201175)
connected to recovery catalog database
RMAN> create script users_bak {
> backup datafile '/u01/app/oracle/oradata/cuug/users01.dbf' format '/disk1/rman/cuug/users_%s.bak';
> }
created script users_bak
————通过catalog database 查看
SQL> col SCRIPT_NAME for a30
SQL> col SCRIPT_COMMENT for a50
SQL> col text for a50
SQL> select * from RC_STORED_SCRIPT;
DB_KEY DB_NAME SCRIPT_NAME SCRIPT_COMMENT
---------- -------- ------------------------------ --------------------------------------------------
1 CUUG users_bak
SQL> select * from RC_STORED_SCRIPT_LINE;
DB_KEY SCRIPT_NAME LINE TEXT
---------- ------------------------------ ---------- --------------------------------------------------
1 users_bak 1 {backup datafile '/u01/app/oracle/oradata/cuug/us
ers01.dbf' format '/disk1/rman/cuug/users_%s.bak';
1 users_bak 2 }
————运行脚本
RMAN> run { execute script users_bak;}
————删除脚本
RMAN> delete script users_bak;
deleted script: users_bak
