Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(六)
029
3 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/undotbs1.258.826495029
4 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/users.259.826495029
5 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/example.264.826495145
6 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/undotbs2.265.826495425
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
3 11.50K DISK 00:00:00 20-SEP-2013 12:50:00
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130920T125000
Piece Name: /u01/app/oracle/bak/20130920_3_1_ARC
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 10 1055347 20-SEP-2013 12:47:56 1055468 20-SEP-2013 12:49:59
2 6 1055351 20-SEP-2013 12:47:56 1055464 20-SEP-2013 12:49:57
RMAN>
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
1 B A A DISK 20-SEP-2013 12:48:05 1 1 NO TAG20130920T124804
2 B F A DISK 20-SEP-2013 12:49:50 1 1 NO TAG20130920T124810
3 B A A DISK 20-SEP-2013 12:50:00 1 1 NO TAG20130920T125000
RMAN>
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:18:32 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
set lines 100 pages 100
SQL> select name from v$datafile
2 union all
3 select name from v$tempfile
4 union all
5 select member from v$logfile
6 union all
7 select name from v$controlfile
8 /
NAME
----------------------------------------------------------------------------------------------------
+DATADG/zwc/datafile/system.256.826495029
+DATADG/zwc/datafile/sysaux.257.826495029
+DATADG/zwc/datafile/undotbs1.258.826495029
+DATADG/zwc/datafile/users.259.826495029
+DATADG/zwc/datafile/example.264.826495145
+DATADG/zwc/datafile/undotbs2.265.826495425
+DATADG/zwc/tempfile/temp.263.826495137
+DATADG/zwc/onlinelog/group_2.262.826495123
+FRADG/zwc/onlinelog/group_2.258.826495125
+DATADG/zwc/onlinelog/group_1.261.826495119
+FRADG/zwc/onlinelog/group_1.257.826495121
+DATADG/zwc/onlinelog/group_3.266.826495573
+FRADG/zwc/onlinelog/group_3.259.826495577
+DATADG/zwc/onlinelog/group_4.267.826495581
+FRADG/zwc/onlinelog/group_4.260.826495585
/u01/app/oracle/oradata/zwc/control01.ctl
/u01/app/oracle/oradata/zwc/control02.ctl
17 rows selected.
SQL> col name for a50
SQL> select file#,name from v$datafile;
FILE# NAME
---------- --------------------------------------------------
1 +DATADG/zwc/datafile/system.256.826495029
2 +DATADG/zwc/datafile/sysaux.257.826495029
3 +DATADG/zwc/datafile/undotbs1.258.826495029
4 +DATADG/zwc/datafile/users.259.826495029
5 +DATADG/zwc/datafile/example.264.826495145
6 +DATADG/zwc/datafile/undotbs2.265.826495425
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.