Catlog的作用是将备份记录在catlog服务器，防止记录丢失
源库（172.16.100.100）
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 839282688 bytes
Fixed Size 2217992 bytes
Variable Size 503318520 bytes
Database Buffers 331350016 bytes
Redo Buffers 2396160 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> create tablespace rmanuserstbs datafile '/u01/app/oracle/oradata/orcl/rmanuserstbs' size 100m;
Tablespace created.
SQL> create temporary tablespace tmp tempfile
'/u01/app/oracle/oradata/orcl/tmp.dbf' size 10m;
Tablespace created.
SQL> create user rmanadmin identified by rmanadmin default tablespace rmanuserstbs temporary tablespace tmp;
User created.
SQL> grant connect,resource,recovery_catalog_owner to rmanadmin;
Grant succeeded.
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.100.100)(PORT=1521)))';
备份库（172.16.100.200）
[oracle@localhost admin]$ pwd
/u01/app/oracle/product/11.2.0.1/network/admin
[oracle@localhost admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0.1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL_100 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.localdomain)
)
)
[oracle@localhost admin]$ rman target sys/oracle@ORCL_100 catalog rmanadmin/rmanadmin@ORCL_100
RMAN> create catalog tablespace rmanuserstbs;(在100.100已创建)
recovery catalog created
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
之后就可以查看源库的信息
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
83 Full 428.42M DISK 00:01:48
30-AUG-15
BP Key: 89 Status: AVAILABLE Compressed: NO Tag: TAG20150830T142843
Piece Name: /u01/backup2/0cqftdkr_1_1
List of Datafiles in backup set 83
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1100783
30-AUG-15 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 1100783
30-AUG-15 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 1100783
30-AUG-15 /u01/app/oracle/oradata/orcl/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
84 Full 662.33M DISK 00:03:12
30-AUG-15
BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20150830T142843
Piece Name: /u01/backup/0bqftdkr_1_1
List of Datafiles in backup set 84
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1100782
30-AUG-15 /u01/app/oracle/oradata/orcl/system01.dbf
5 Full 1100782
30-AUG-15 /u01/app/oracle/oradata/orcl/example01.dbf
