Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(五)
he Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 05:12:08 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (not mounted)
RMAN> restore controlfile from '/u01/app/oracle/bak/c-582474828-20130920-00_CNT';
Starting restore at 20-SEP-2013 05:12:27
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/zwc/control01.ctl
output file name=/u01/app/oracle/oradata/zwc/control02.ctl
Finished restore at 20-SEP-2013 05:12:30
RMAN> mount database;
database mounted
released channel: ORA_DISK_1
RMAN>
RMAN> catalog start with '/u01/app/oracle/bak/';
searching for all files that match the pattern /u01/app/oracle/bak/
List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/bak/c-582474828-20130920-00_CNT
File Name: /u01/app/oracle/bak/fullbak.tar.gz
Do you really want to catalog the above files (enter YES or NO) yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/bak/c-582474828-20130920-00_CNT
List of Files Which Where Not Cataloged
=======================================
File Name: /u01/app/oracle/bak/fullbak.tar.gz
RMAN-07517: Reason: The file header is corrupted
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion T
ime
------- ---------- ----------- ------------ --------------------
1 14.70M DISK 00:00:00 20-SEP-2013 12:48:05
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130920T124804
Piece Name: /u01/app/oracle/bak/20130920_1_1_ARC
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 6 996244 18-SEP-2013 22:04:47 1003685 18-SEP-2013 22:10:40
1 7 1003685 18-SEP-2013 22:10:40 1003702 18-SEP-2013 22:11:22
1 8 1003702 18-SEP-2013 22:11:22 1043761 20-SEP-2013 11:31:09
1 9 1043761 20-SEP-2013 11:31:09 1055347 20-SEP-2013 12:47:56
2 1 999525 18-SEP-2013 22:06:28 999569 18-SEP-2013 22:06:31
2 2 999862 18-SEP-2013 22:07:20 1003682 18-SEP-2013 22:10:39
2 3 1003682 18-SEP-2013 22:10:39 1023714 18-SEP-2013 22:12:21
2 4 1023714 18-SEP-2013 22:12:21 1023717 18-SEP-2013 22:12:22
2 5 1044191 20-SEP-2013 11:32:25 1055351 20-SEP-2013 12:47:56
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2 Full 1.07G DISK 00:01:40 20-SEP-2013 12:49:50
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130920T124810
Piece Name: /u01/app/oracle/bak/20130920_2_1_DAT
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/system.256.826495029
2 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/sysaux.257.826495