channel t1: starting datafile backupset restore channel t1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /oracle/304/oradata/inst933/system01.dbf restoring datafile 00002 to /oracle/304/oradata/inst933/undotbs01.dbf restoring datafile 00003 to /oracle/304/oradata/inst933/users01.dbf restoring datafile 00004 to /oracle/304/oradata/inst933/perfstat01.dbf restoring datafile 00005 to /oracle/304/oradata/inst933/insite_suz.dbf restoring datafile 00006 to /oracle/304/oradata/inst933/insiteint01.dbf restoring datafile 00007 to /oracle/304/oradata/inst933/insiteque.dbf restoring datafile 00008 to /oracle/304/oradata/inst933/undotbs02.dbf restoring datafile 00009 to /oracle/304/oradata/inst933/aud_data01.dbf restoring datafile 00010 to /oracle/304/oradata/inst933/perfstat02.dbf restoring datafile 00011 to /oracle/304/oradata/inst933/insite_suz01.dbf restoring datafile 00012 to /oracle/304/oradata/inst933/undotbs03.dbf restoring datafile 00013 to /oracle/304/oradata/inst933/undotbs04.dbf channel t1: restored backup piece 1 piece handle=bk_6231_1_664203616 tag=FULL_ORACLE_BACKUP params=NULL channel t1: restore complete Finished restore at 02-SEP-08
Starting recover at 02-SEP-08 channel t1: starting incremental datafile backupset restore channel t1: specifying datafile(s) to restore from backup set destination for restore of datafile 00001: /oracle/304/oradata/inst933/system01.dbf destination for restore of datafile 00002: /oracle/304/oradata/inst933/undotbs01.dbf destination for restore of datafile 00003: /oracle/304/oradata/inst933/users01.dbf destination for restore of datafile 00004: /oracle/304/oradata/inst933/perfstat01.dbf destination for restore of datafile 00005: /oracle/304/oradata/inst933/insite_suz.dbf destination for restore of datafile 00006: /oracle/304/oradata/inst933/insiteint01.dbf destination for restore of datafile 00007: /oracle/304/oradata/inst933/insiteque.dbf destination for restore of datafile 00008: /oracle/304/oradata/inst933/undotbs02.dbf destination for restore of datafile 00009: /oracle/304/oradata/inst933/aud_data01.dbf destination for restore of datafile 00010: /oracle/304/oradata/inst933/perfstat02.dbf destination for restore of datafile 00011: /oracle/304/oradata/inst933/insite_suz01.dbf destination for restore of datafile 00012: /oracle/304/oradata/inst933/undotbs03.dbf destination for restore of datafile 00013: /oracle/304/oradata/inst933/undotbs04.dbf channel t1: restored backup piece 1 piece handle=bk_6256_1_664286419 tag=INCREMENTAL_ORACLE_BACKUP params=NULL channel t1: restore complete
RMAN> RUN{ SET UNTIL SEQUENCE 7974 THREAD 1; RECOVER DATABASE; } 2> 3> 4> executing command: SET until clause
Starting recover at 02-SEP-08 using channel ORA_SBT_TAPE_1 using channel ORA_DISK_1
starting media recovery media recovery complete
Finished recover at 02-SEP-08
RMAN> RMAN> exit
Recovery Manager complete.
bash-3.00$ sqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Sep 2 13:35:04
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production
SQL> alter database open resetlogs;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE ---------- READ WRITE
SQL> quit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.8.0 - Production bash-3.00$