Lets do restoration and recoveriration..

Spec pliz.. … … OK!!

Database: Oracle9i Release 9.2.0.6.0 – 64bit Production (Standard i.e. of course not Enterprise)
OS: HP-UX
Error: As mention above at the title of this post. LoL

Workaround:

1. Shutdown db

2. Set dbid

RMAN> set dbid=1372791293

3. Startup NOMOUNT database

RMAN> startup nomount

Oracle instance started

Total System Global Area 320293088 bytes

Fixed Size 727264 bytes
Variable Size 285212672 bytes
Database Buffers 33554432 bytes
Redo Buffers 798720 bytes

4. Restore Controlfile from backupset location:

RMAN> restore controlfile from '/backup/mydb9i/20120419/controlfile/CFILE_MYDB9I_c-1372791293-20120419-01';

Starting restore at 26-APR-12

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
channel ORA_DISK_1: restoring controlfile
channel ORA_DISK_1: restore complete
replicating controlfile
input filename=/oracle/oradata/mydb9i/control01.ctl
output filename=/oracle/oradata/mydb9i/control02.ctl
output filename=/oracle/oradata/mydb9i/control03.ctl
Finished restore at 26-APR-12

5. Mount database, then Restore database:

RMAN> alter database mount;

database mounted

RMAN> restore database;

Starting restore at 26-APR-12

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /tbspace/system01.dbf
..
..
..
restoring datafile 00043 to /tbspace/MYDF4.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/backup/mydb9i/20120419/backupset/BACKUPSET9081_MYDB9I_20120419_rpn8p9o3_1_1 tag=TAG20120419T000211 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 26-APR-12

6. Its time for RECOVERIRATION

RMAN> recover database;

Starting recover at 26-APR-12
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 4396 is already on disk as file /oracle/oradata/mydb9i/redo03.log
archive log filename=/oracle/oradata/mydb9i/redo03.log thread=1 sequence=4916
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 5 needs more recovery to be consistent
ORA-01110: data file 5: '/tbspace/example01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/26/2012 01:21:49
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/oracle/oradata/mydb9i/redo03.log'
ORA-00310: archived log contains sequence 4396; sequence 4916 required
ORA-00334: archived log: '/oracle/oradata/mydb9i/redo03.log'

Err..dafuk is this? Why cannot recover?

Lets try another method..

1st Attempt – recover until latest -1 sequence: FAILED

RMAN> recover database until sequence 4916 thread 1;

Starting recover at 26-APR-12
using channel ORA_DISK_1

starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 5 needs more recovery to be consistent
ORA-01110: data file 5: '/tbspace/example01.dbf'

media recovery complete

Finished recover at 26-APR-12

RMAN> exit

2nd Attempt – recover from SQLPLUS Utility: FAILED

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE until cancel;
ORA-00279: change 2598617024 generated at 04/19/2012 00:02:11 needed for thread
1
ORA-00289: suggestion : /arch/1_4916.dbf
ORA-00280: change 2598617024 for thread 1 is in sequence #4916
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/arch/1_4916.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-00308: cannot open archived log '/arch/1_4916.dbf'
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 5 needs more recovery to be consistent
ORA-01110: data file 5: '/tbspace/example01.dbf'

Ok, got some clue now. Oracle looking for the archive in /arch/1_4916.dbf.

Now, try to restore the archive.

3rd Attempt – Restore Archivelog

RMAN> restore archivelog from logseq=4916 thread 1;

Starting restore at 26-APR-12

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=4916
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=4917
channel ORA_DISK_1: restored backup piece 1
piece handle=/backup/mydb9i/20120419/archivelog/ARCH_mydb9i_20120419_rrn8paa9_1_1 tag=TAG20120419T001153 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 26-APR-12

Now Recover Successful – Yeay!!

RMAN> recover database until logseq=4917 thread=1;

Starting recover at 26-APR-12
using channel ORA_DISK_1

starting media recovery
media recovery complete

Finished recover at 26-APR-12

Next.next..Open resetlogs, Check DB Status, create temporary tablespaces

RMAN> alter database open resetlogs;

database opened

RMAN> exit
Recovery Manager complete.

backup, database error, Oracle, recovery Oracle, Software, Technology