当前位置: 代码迷 >> Oracle管理 >> 请教上面这个rman恢复案例的有关问题出在哪里
  详细解决方案

请教上面这个rman恢复案例的有关问题出在哪里

热度:20   发布时间:2016-04-24 05:11:59.0
请问下面这个rman恢复案例的问题出在哪里
环境
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