How different is to backup and restore the RAC database VS. single instance database?
Consider the architectural nature of the Oracle RAC cluster:
In RAC setup, you have at least two different servers, oracle uses this hardware by creating two instances,
one on each node, with their own instance memory area(SGA).
Each instance has its own redo logs, but they exist on the shared disk and are accessible by all the nodes in the cluster.
All controlfiles and datafiles are shared between the two/more instances in the cluster.
RMAN perspective, this architecture creates interesting challenges for taking backups and restores, rman can connect to only a single node.
This shouldn't pose any problems for taking backup, but we do have a interesting challenge when it comes to restore.
In other words, we have to start the restore from the same node as backup was performed or need to use parms "ENV=(NB_ORA_CLIENT=atlt47)" in your allocate channel command.
CASE:
Scenario:
In one of our application, customer pre-requisite is to set NLS_DATE_FORMAT to 'RRRR-MON-DD' (default is 'DD-MON-RR').
Steps:
a.
Setting the NLS_DATE_FORMAT to 'RRRR-MON-DD' and restarting the RAC database:
SQL> alter system set NLS_DATE_FORMAT='RRRR-MON-DD' scope=spfile sid='*';
$ srvctl stop database -d DBName
$ srvctl start database -d DBName
b.
Resetting the NLS_DATE_FORMAT to default: <<<<< user set NLS_DATE_FORMAT to NULL, thinking resetting it to default value!!! and got oracle internal error.
SQL> alter system set NLS_DATE_FORMAT=NULL scope=spfile sid='*';
$ srvctl stop database -d DBName
$ srvctl start database -d DBName
ORA-00600: internal error code, arguments: [kccsbck_first], [1], [2792458534], [], [], [], [], []
c.
1.
So user decided to restore the DB to just before step a backup (Yes, user did take full rman backup!!!)
Important points to observe about the rman full backup:
Backup was taken from OEM GRID on cluster database level, instead of instance level.
In this case backup was taken from node 2(instance 2).
RMAN backup configured to VTL's (Via VERITAS NetBackup for Oracle - Release 5.1).
2.
User who scheduled a rman restore from OEM GRID, thinking that OEM GRID can automatically detect the backup performed node and restores it to point of time requested in the restore.
3.
What happened?
This time restore job connected to node 1(instance 1) and started the restore and recovery.
Did the restore successful?
Yes, but it restored the latest backup taken from the node 1(instance 1), which is 19 days old and it reset the logs to open the database.
RMAN error log and restoring 19 days old backup from OEM GRID:
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> SQL> Connected to an idle instance.
SQL> SQL> ORACLE instance started.
Total System Global Area 1157627904 bytes
Fixed Size 2072224 bytes
Variable Size 285213024 bytes
Database Buffers 855638016 bytes
Redo Buffers 14704640 bytes
Database mounted.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
Recovery Manager: Release 10.2.0.3.0 - Production on Sun Jun 29 16:26:28 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: ORADB (DBID=390676631, not open)
RMAN>
connected to recovery catalog database
RMAN>
echo set on
RMAN> run {
2> restore database;
3> recover database noredo;
4> }
Starting restore at 29-JUN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1077 instance=ORADB1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1076 instance=ORADB1 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1075 instance=ORADB1 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=1074 instance=ORADB1 devtype=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=1073 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=1072 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=1071 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=1070 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: sid=1069 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_5: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: sid=1068 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_6: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_7
channel ORA_SBT_TAPE_7: sid=1067 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_7: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: ORA_SBT_TAPE_8
channel ORA_SBT_TAPE_8: sid=1066 instance=ORADB1 devtype=SBT_TAPE
channel ORA_SBT_TAPE_8: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
channel ORA_SBT_TAPE_2: starting datafile backupset restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
channel ORA_SBT_TAPE_2: reading from backup piece 0qjk51um_1_1
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to +INF_T1_BACKUP_01/qroa1inf/datafile/infinys_data1.ora
channel ORA_SBT_TAPE_1: reading from backup piece 0sjk51un_1_1
channel ORA_SBT_TAPE_3: starting datafile backupset restore
channel ORA_SBT_TAPE_3: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
channel ORA_SBT_TAPE_3: reading from backup piece 0pjk51um_1_1
channel ORA_SBT_TAPE_4: starting datafile backupset restore
channel ORA_SBT_TAPE_4: specifying datafile(s) to restore from backup set
restoring datafile 00004 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
channel ORA_SBT_TAPE_4: reading from backup piece 0rjk51un_1_1
channel ORA_SBT_TAPE_5: starting datafile backupset restore
channel ORA_SBT_TAPE_5: specifying datafile(s) to restore from backup set
restoring datafile 00003 to +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
channel ORA_SBT_TAPE_5: reading from backup piece 0ojk51um_1_1
channel ORA_SBT_TAPE_6: starting datafile backupset restore
channel ORA_SBT_TAPE_6: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
channel ORA_SBT_TAPE_6: reading from backup piece 0njk51um_1_1
ORA-19870: error reading backup piece 0sjk51un_1_1
ORA-19507: failed to retrieve sequential file, handle="0sjk51un_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0sjk51un_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0qjk51um_1_1
ORA-19507: failed to retrieve sequential file, handle="0qjk51um_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0qjk51um_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0pjk51um_1_1
ORA-19507: failed to retrieve sequential file, handle="0pjk51um_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0pjk51um_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0rjk51un_1_1
ORA-19507: failed to retrieve sequential file, handle="0rjk51un_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0rjk51un_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0ojk51um_1_1
ORA-19507: failed to retrieve sequential file, handle="0ojk51um_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0ojk51um_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0njk51um_1_1
ORA-19507: failed to retrieve sequential file, handle="0njk51um_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0njk51um_1_1> not found in NetBackup catalog
failover to previous backup
channel ORA_SBT_TAPE_3: starting datafile backupset restore
channel ORA_SBT_TAPE_3: specifying datafile(s) to restore from backup set
restoring datafile 00003 to +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
channel ORA_SBT_TAPE_3: reading from backup piece 0gjk2tut_1_1
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
channel ORA_SBT_TAPE_1: reading from backup piece 0jjk2tuu_1_1
channel ORA_SBT_TAPE_2: starting datafile backupset restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
channel ORA_SBT_TAPE_2: reading from backup piece 0ijk2tuu_1_1
channel ORA_SBT_TAPE_4: starting datafile backupset restore
channel ORA_SBT_TAPE_4: specifying datafile(s) to restore from backup set
restoring datafile 00006 to +INF_T1_BACKUP_01/qroa1inf/datafile/infinys_data1.ora
channel ORA_SBT_TAPE_4: reading from backup piece 0kjk2tuu_1_1
channel ORA_SBT_TAPE_5: starting datafile backupset restore
channel ORA_SBT_TAPE_5: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
channel ORA_SBT_TAPE_5: reading from backup piece 0hjk2tuu_1_1
channel ORA_SBT_TAPE_6: starting datafile backupset restore
channel ORA_SBT_TAPE_6: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
channel ORA_SBT_TAPE_6: reading from backup piece 0fjk2tut_1_1
ORA-19870: error reading backup piece 0jjk2tuu_1_1
ORA-19507: failed to retrieve sequential file, handle="0jjk2tuu_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0jjk2tuu_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0ijk2tuu_1_1
ORA-19507: failed to retrieve sequential file, handle="0ijk2tuu_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0ijk2tuu_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0gjk2tut_1_1
ORA-19507: failed to retrieve sequential file, handle="0gjk2tut_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0gjk2tut_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0kjk2tuu_1_1
ORA-19507: failed to retrieve sequential file, handle="0kjk2tuu_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0kjk2tuu_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0hjk2tuu_1_1
ORA-19507: failed to retrieve sequential file, handle="0hjk2tuu_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0hjk2tuu_1_1> not found in NetBackup catalog
ORA-19870: error reading backup piece 0fjk2tut_1_1
ORA-19507: failed to retrieve sequential file, handle="0fjk2tut_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Backup file <0fjk2tut_1_1> not found in NetBackup catalog
failover to previous backup
the filename for datafile 6 is missing in the control file
channel ORA_SBT_TAPE_4: starting datafile backupset restore
channel ORA_SBT_TAPE_4: specifying datafile(s) to restore from backup set
restoring datafile 00003 to +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
channel ORA_SBT_TAPE_4: reading from backup piece 09jjvff1_1_1
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
channel ORA_SBT_TAPE_1: reading from backup piece 0djjvff2_1_1
channel ORA_SBT_TAPE_2: starting datafile backupset restore
channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set
restoring datafile 00004 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
channel ORA_SBT_TAPE_2: reading from backup piece 0bjjvff1_1_1
channel ORA_SBT_TAPE_3: starting datafile backupset restore
channel ORA_SBT_TAPE_3: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
channel ORA_SBT_TAPE_3: reading from backup piece 0ajjvff1_1_1
channel ORA_SBT_TAPE_5: starting datafile backupset restore
channel ORA_SBT_TAPE_5: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
channel ORA_SBT_TAPE_5: reading from backup piece 08jjvff1_1_1
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=0djjvff2_1_1 tag=BACKUP_ORADB.WO_062708093125
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:03:25
channel ORA_SBT_TAPE_2: restored backup piece 1
piece handle=0bjjvff1_1_1 tag=BACKUP_ORADB.WO_062708093125
channel ORA_SBT_TAPE_2: restore complete, elapsed time: 00:03:40
channel ORA_SBT_TAPE_3: restored backup piece 1
piece handle=0ajjvff1_1_1 tag=BACKUP_ORADB.WO_062708093125
channel ORA_SBT_TAPE_3: restore complete, elapsed time: 00:03:40
channel ORA_SBT_TAPE_4: restored backup piece 1
piece handle=09jjvff1_1_1 tag=BACKUP_ORADB.WO_062708093125
channel ORA_SBT_TAPE_4: restore complete, elapsed time: 00:03:40
channel ORA_SBT_TAPE_5: restored backup piece 1
piece handle=08jjvff1_1_1 tag=BACKUP_ORADB.WO_062708093125
channel ORA_SBT_TAPE_5: restore complete, elapsed time: 00:03:40
Finished restore at 29-JUN-08
Starting recover at 29-JUN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
using channel ORA_SBT_TAPE_3
using channel ORA_SBT_TAPE_4
using channel ORA_SBT_TAPE_5
using channel ORA_SBT_TAPE_6
using channel ORA_SBT_TAPE_7
using channel ORA_SBT_TAPE_8
temporary file +INF_T1_BACKUP_01/qroa1inf/tempfile/temp.263.657026087 size altered in control file
Finished recover at 29-JUN-08
RMAN> exit;
Recovery Manager complete.
Recovery Manager: Release 10.2.0.3.0 - Production on Sun Jun 29 16:31:36 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: ORADB (DBID=390676631, not open)
RMAN>
connected to recovery catalog database
RMAN>
echo set on
RMAN> alter database open resetlogs;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> exit;
Recovery Manager complete.
Action plan:
Connect to rman catalog (very important, default is NOCATALOG) and
reset the database incarnation Key to PARENT(before resetlogs) from the node 2(rman backup performed node).
Restore controlfile and database and recover the database to open.
RMAN restore log:
atlt47 | ORADB2 | /u00/app/oracle/product/10.2.0/DB
> rman TARGET / CATALOG rman/rman@prman.world
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 30 12:20:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORADB (not mounted)
connected to recovery catalog database
RMAN> shutdown immediate;
set DBID 390676631;
startup nomount;
Oracle instance shut down
RMAN>
RMAN>
executing command: SET DBID
database name is "ORADB" and DBID is 390676631
RMAN>
RMAN>
connected to target database (not started)
Oracle instance started
Total System Global Area 1157627904 bytes
Fixed Size 2072224 bytes
Variable Size 285213024 bytes
Database Buffers 855638016 bytes
Redo Buffers 14704640 bytes
RMAN> LIST INCARNATION OF DATABASE ORADB;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
4710871 4710872 ORADB 390676631 PARENT 1 10-JUN-08
4710871 4931854 ORADB 390676631 CURRENT 1971243 29-JUN-08
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
4710871 4710872 ORADB 390676631 PARENT 1 10-JUN-08
4710871 4931854 ORADB 390676631 CURRENT 1971243 29-JUN-08
-------------------------------------------- <<<<<<<< giving the wrong(CURRENT) database incarnation Key.
RMAN> reset database to incarnation 4931854;
database reset to incarnation 4931854
RMAN> run {
2> set until time "to_date('JUN 29 2008 12:21:00','Mon DD YYYY HH24:MI:SS')";
3> allocate channel d1 type 'SBT_TAPE';
4> allocate channel d2 type 'SBT_TAPE';
5> allocate channel d3 type 'SBT_TAPE';
6> allocate channel d4 type 'SBT_TAPE';
7> restore controlfile;
8> sql "alter database mount";
9> restore database;
10> recover database;
11> sql "alter database open resetlogs";
12> release channel d1;
13> release channel d2;
14> release channel d3;
15> release channel d4;
16> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 06/30/2008 13:29:08
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time
--------------------------------------------
RMAN> reset database to incarnation 4710872; <<<<<<<< giving the correct(PARENT) database incarnation Key.
database reset to incarnation 4710872
RMAN> run {
2> set until time "to_date('JUN 29 2008 12:21:00','Mon DD YYYY HH24:MI:SS')";
3> allocate channel d1 type 'SBT_TAPE';
4> allocate channel d2 type 'SBT_TAPE';
5> allocate channel d3 type 'SBT_TAPE';
6> allocate channel d4 type 'SBT_TAPE';
7> restore controlfile;
8> sql "alter database mount";
9> restore database;
10> recover database;
11> sql "alter database open resetlogs";
12> release channel d1;
13> release channel d2;
14> release channel d3;
15> release channel d4;
16> }
executing command: SET until clause
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
released channel: ORA_DISK_4
released channel: ORA_SBT_TAPE_1
released channel: ORA_SBT_TAPE_2
released channel: ORA_SBT_TAPE_3
released channel: ORA_SBT_TAPE_4
released channel: ORA_SBT_TAPE_5
released channel: ORA_SBT_TAPE_6
released channel: ORA_SBT_TAPE_7
released channel: ORA_SBT_TAPE_8
allocated channel: d1
channel d1: sid=1079 instance=ORADB2 devtype=SBT_TAPE
channel d1: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: d2
channel d2: sid=1080 instance=ORADB2 devtype=SBT_TAPE
channel d2: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: d3
channel d3: sid=1078 instance=ORADB2 devtype=SBT_TAPE
channel d3: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
allocated channel: d4
channel d4: sid=1077 instance=ORADB2 devtype=SBT_TAPE
channel d4: VERITAS NetBackup for Oracle - Release 5.1 (2006040520)
Starting restore at 30-JUN-08
channel d1: starting datafile backupset restore
channel d1: restoring control file
channel d1: reading from backup piece 0tjk51un_1_1
channel d1: restored backup piece 1
piece handle=0tjk51un_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d1: restore complete, elapsed time: 00:03:35
output filename=+INF_T1_DATA_01/qroa1inf/controlfile/current.290.658762389
Finished restore at 30-JUN-08
sql statement: alter database mount
Starting restore at 30-JUN-08
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
channel d2: reading from backup piece 0qjk51um_1_1
channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to +INF_T1_BACKUP_01/qroa1inf/datafile/infinys_data1.ora
channel d1: reading from backup piece 0sjk51un_1_1
channel d1: restored backup piece 1
piece handle=0sjk51un_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d1: restore complete, elapsed time: 00:03:25
channel d2: restored backup piece 1
piece handle=0qjk51um_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d2: restore complete, elapsed time: 00:03:25
channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
channel d1: reading from backup piece 0rjk51un_1_1
channel d2: starting datafile backupset restore
channel d2: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
channel d2: reading from backup piece 0pjk51um_1_1
channel d1: restored backup piece 1
piece handle=0rjk51un_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d1: restore complete, elapsed time: 00:03:25
channel d2: restored backup piece 1
piece handle=0pjk51um_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d2: restore complete, elapsed time: 00:03:25
channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
channel d1: reading from backup piece 0ojk51um_1_1
channel d1: restored backup piece 1
piece handle=0ojk51um_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d1: restore complete, elapsed time: 00:03:35
channel d1: starting datafile backupset restore
channel d1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
channel d1: reading from backup piece 0njk51um_1_1
channel d1: restored backup piece 1
piece handle=0njk51um_1_1 tag=BACKUP_ORADB.WO_062908121740
channel d1: restore complete, elapsed time: 00:03:35
Finished restore at 30-JUN-08
Starting recover at 30-JUN-08
starting media recovery
released channel: d1
released channel: d2
released channel: d3
released channel: d4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/30/2008 13:47:58
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 2 seq 13 lowscn 2607439 found to restore
RMAN-06025: no backup of log thread 1 seq 26 lowscn 2723046 found to restore
RMAN>
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 06/30/2008 13:49:38
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> alter database open RESETLOGS;
database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
RMAN> exit
Recovery Manager complete.
Side Note:
To avoid manual "alter database open RESETLOGS;" use below rman commands.
recover database noredo; -- For NOARCHIVE LOG
recover database; -- For ARCHIVE LOG
P.S.
So, how is my list backupset command looks with NOCATALOG and CATALOG?
atlt47 | ORADB2 | /u00/app/oracle/product/10.2.0/DB> rman target / <<<<<<<<<< NOCATALOG
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 30 11:01:30 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORADB (DBID=390676631, not open)
RMAN> list backupset;
using target database control file instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 256.00K SBT_TAPE 00:01:28 13-JUN-08
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 06jircsb_1_1 Media:
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 256.00K SBT_TAPE 00:01:36 13-JUN-08
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 07jircsb_1_1 Media:
SPFILE Included: Modification time: 13-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 14.75M SBT_TAPE 00:01:37 13-JUN-08
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 05jircsb_1_1 Media:
Control File Included: Ckp SCN: 862074 Ckp time: 13-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 5.00M SBT_TAPE 00:01:43 13-JUN-08
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 04jircsa_1_1 Media:
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5 Full 210.25M SBT_TAPE 00:01:55 13-JUN-08
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 03jircsa_1_1 Media:
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 333.25M SBT_TAPE 00:01:56 13-JUN-08
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 02jircsa_1_1 Media:
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 356.50M SBT_TAPE 00:01:58 13-JUN-08
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 01jircsa_1_1 Media:
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
RMAN>
RMAN> exit
Recovery Manager complete.
atlt47 | ORADB2 | /u00/app/oracle/product/10.2.0/DB> rman target / <<<<<<<<<< CATALOG
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jun 30 11:07:03 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORADB (DBID=390676631, not open)
RMAN> connect catalog rman/rman@prman.world <<<<<<<<<< CATALOG
connected to recovery catalog database
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728914 Full 256.00K SBT_TAPE 00:01:28 13-JUN-08
BP Key: 4728921 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 06jircsb_1_1 Media:
List of Datafiles in backup set 4728914
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728915 Full 256.00K SBT_TAPE 00:01:36 13-JUN-08
BP Key: 4728922 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 07jircsb_1_1 Media:
SPFILE Included: Modification time: 13-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728916 Full 14.75M SBT_TAPE 00:01:37 13-JUN-08
BP Key: 4728923 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 05jircsb_1_1 Media:
Control File Included: Ckp SCN: 862074 Ckp time: 13-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728917 Full 5.00M SBT_TAPE 00:01:43 13-JUN-08
BP Key: 4728924 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 04jircsa_1_1 Media:
List of Datafiles in backup set 4728917
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728918 Full 210.25M SBT_TAPE 00:01:55 13-JUN-08
BP Key: 4728925 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 03jircsa_1_1 Media:
List of Datafiles in backup set 4728918
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728919 Full 333.25M SBT_TAPE 00:01:56 13-JUN-08
BP Key: 4728926 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 02jircsa_1_1 Media:
List of Datafiles in backup set 4728919
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4728920 Full 356.50M SBT_TAPE 00:01:58 13-JUN-08
BP Key: 4728927 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_061308050625
Handle: 01jircsa_1_1 Media:
List of Datafiles in backup set 4728920
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 862074 13-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904245 Full 256.00K SBT_TAPE 00:01:17 27-JUN-08
BP Key: 4904253 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 0djjvff2_1_1 Media:
List of Datafiles in backup set 4904245
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 1971242 27-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904246 Full 14.75M SBT_TAPE 00:01:21 27-JUN-08
BP Key: 4904254 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 0cjjvff1_1_1 Media:
Control File Included: Ckp SCN: 1971242 Ckp time: 27-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904247 Full 256.00K SBT_TAPE 00:01:26 27-JUN-08
BP Key: 4904255 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 0ejjvff2_1_1 Media:
SPFILE Included: Modification time: 27-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904248 Full 21.25M SBT_TAPE 00:01:31 27-JUN-08
BP Key: 4904256 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 0bjjvff1_1_1 Media:
List of Datafiles in backup set 4904248
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 1971242 27-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904249 Full 333.25M SBT_TAPE 00:01:45 27-JUN-08
BP Key: 4904257 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 0ajjvff1_1_1 Media:
List of Datafiles in backup set 4904249
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 1971242 27-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904250 Full 344.00M SBT_TAPE 00:01:47 27-JUN-08
BP Key: 4904258 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 09jjvff1_1_1 Media:
List of Datafiles in backup set 4904250
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 1971242 27-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4904251 Full 362.00M SBT_TAPE 00:01:47 27-JUN-08
BP Key: 4904259 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062708093125
Handle: 08jjvff1_1_1 Media:
List of Datafiles in backup set 4904251
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1971242 27-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920736 Full 14.75M SBT_TAPE 00:01:32 28-JUN-08
BP Key: 4920745 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0ljk2tuu_1_1 Media:
Control File Included: Ckp SCN: 2589364 Ckp time: 28-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920737 Full 256.00K SBT_TAPE 00:01:42 28-JUN-08
BP Key: 4920746 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0mjk2tuu_1_1 Media:
SPFILE Included: Modification time: 28-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920738 Full 155.25M SBT_TAPE 00:01:46 28-JUN-08
BP Key: 4920747 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0jjk2tuu_1_1 Media:
List of Datafiles in backup set 4920738
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920739 Full 124.50M SBT_TAPE 00:01:52 28-JUN-08
BP Key: 4920748 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0ijk2tuu_1_1 Media:
List of Datafiles in backup set 4920739
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920740 Full 347.50M SBT_TAPE 00:01:55 28-JUN-08
BP Key: 4920749 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0gjk2tut_1_1 Media:
List of Datafiles in backup set 4920740
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920741 Full 256.00K SBT_TAPE 00:01:56 28-JUN-08
BP Key: 4920750 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0kjk2tuu_1_1 Media:
List of Datafiles in backup set 4920741
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/infinys_data1.ora
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920742 Full 333.25M SBT_TAPE 00:01:58 28-JUN-08
BP Key: 4920751 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0hjk2tuu_1_1 Media:
List of Datafiles in backup set 4920742
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4920743 Full 471.00M SBT_TAPE 00:02:02 28-JUN-08
BP Key: 4920752 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062808045704
Handle: 0fjk2tut_1_1 Media:
List of Datafiles in backup set 4920743
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2589364 28-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929973 Full 14.75M SBT_TAPE 00:01:23 29-JUN-08
BP Key: 4929982 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0tjk51un_1_1 Media:
Control File Included: Ckp SCN: 2780259 Ckp time: 29-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929974 Full 256.00K SBT_TAPE 00:01:31 29-JUN-08
BP Key: 4929983 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0ujk51un_1_1 Media:
SPFILE Included: Modification time: 29-JUN-08
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929975 Full 256.00K SBT_TAPE 00:01:32 29-JUN-08
BP Key: 4929984 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0sjk51un_1_1 Media:
List of Datafiles in backup set 4929975
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/infinys_data1.ora
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929976 Full 137.00M SBT_TAPE 00:01:40 29-JUN-08
BP Key: 4929985 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0qjk51um_1_1 Media:
List of Datafiles in backup set 4929976
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
5 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/users.265.657026093
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929977 Full 333.25M SBT_TAPE 00:01:41 29-JUN-08
BP Key: 4929986 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0pjk51um_1_1 Media:
List of Datafiles in backup set 4929977
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs1.261.657026085
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929978 Full 155.25M SBT_TAPE 00:01:42 29-JUN-08
BP Key: 4929987 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0rjk51un_1_1 Media:
List of Datafiles in backup set 4929978
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
4 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/undotbs2.264.657026091
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929979 Full 348.25M SBT_TAPE 00:01:49 29-JUN-08
BP Key: 4929988 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0ojk51um_1_1 Media:
List of Datafiles in backup set 4929979
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
3 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/sysaux.262.657026087
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4929980 Full 471.25M SBT_TAPE 00:01:52 29-JUN-08
BP Key: 4929989 Status: AVAILABLE Compressed: NO Tag: BACKUP_ORADB.WO_062908121740
Handle: 0njk51um_1_1 Media:
List of Datafiles in backup set 4929980
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2780259 29-JUN-08 +INF_T1_BACKUP_01/qroa1inf/datafile/system.260.657026077
RMAN>
RMAN> exit
Recovery Manager complete.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment