环境
business db target
172.16.18.1
auxiliary db
172.16.18.129
catalog db
172.16.18.128
步骤一:
======================================================================
target端
[oracle@qinghan ~]$rman target / catalog catalog_user/oracle@zhangliang
RUN{
backup DATABASE FORMAT '/bk/dbf_bak_%u';
backup ARCHIVELOG ALL DELETE INPUT FORMAT '/bk/arch_bak_%u';
backup CURRENT CONTROLFILE FORMAT '/bk/ctl_bak_%u';
backup SPFILE FORMAT '/bk/spfile_bak_%u';
CROSSCHECK backup;
CROSSCHECK COPY;
DELETE NOPROMPT OBSOLETE;
}
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jul 14 16:49:41 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: QINGHAN (DBID=3528346275)
connected to recovery catalog database
... ... ...
Recovery Manager complete.
操作顺利完成
将备份集传输到auxiliary db
[...]#scp /bk/* 172.16.129:/bk/
然后在auxiliary db
[...]#chown -R oracle:oinstall /bk/*
======================================================================
步骤二:
======================================================================
catalog端
[oracle@zhangliang ~]$ rman target sys/a@stu119 catalog catalog_user/oracle
RMAN> list backup;
starting full resync of recovery catalog
full resync complete
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1242 Incr 0 227.80M DISK 00:00:09 14-JUL-12
BP Key: 1246 Status: AVAILABLE Compressed: NO Tag: TAG20120714T165742
Piece Name: /bk/QINGHAN_63_1_1vng3686.bk
List of Datafiles in backup set 1242
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 0 Incr 283928 14-JUL-12 /qh_ora/qinghan/dbf/undotbs01.dbf
3 0 Incr 283928 14-JUL-12 /qh_ora/qinghan/dbf/sysaux01.dbf
4 0 Incr 283928 14-JUL-12 /qh_ora/qinghan/dbf/user01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1243 Incr 0 130.69M DISK 00:00:06 14-JUL-12
BP Key: 1247 Status: AVAILABLE Compressed: NO Tag: TAG20120714T165742
Piece Name: /bk/QINGHAN_64_1_20ng368m.bk
List of Datafiles in backup set 1243
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 0 Incr 283934 14-JUL-12 /qh_ora/qinghan/dbf/system01.dbf
5 0 Incr 283934 14-JUL-12 /qh_ora/qinghan/dbf/hanxin01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1244 Incr 0 7.58M DISK 00:00:01 14-JUL-12
BP Key: 1248 Status: AVAILABLE Compressed: NO Tag: TAG20120714T165742
Piece Name: /bk/QINGHAN_65_1_21ng368t.bk
Control File Included: Ckp SCN: 283936 Ckp time: 14-JUL-12
SPFILE Included: Modification time: 14-JUL-12
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1356 10.00K DISK 00:00:01 14-JUL-12
BP Key: 1359 Status: AVAILABLE Compressed: NO Tag: TAG20120714T165811
Piece Name: /bk/arc66_22ng3693.bk
List of Archived Logs in backup set 1356
Thrd Seq Low SCN Low Time Next SCN Next Time