Database Software

Oracle 9i. <cry> on Solaris

Copied pfile + password file from Production.


Restored controlfile successfully from backup. I want to restore to a previous point in time so I then ran

RMAN> run {
allocate channel tivoli type 'SBT_TAPE'
parms 'ENV=(TDPO_OPTFILE=/u1/app/oracle/TSM/tdpo.opt)';
set until time "to_date('03/31/10 23:30:00','mm/dd/yy hh24:mi:ss')";
alter database mount;
restore database;
recover database;
alter database open resetlogs;
release channel tivoli;
}


this restored all my datafiles successfully then......

Finished restore at 09-SEP-10

Starting recover at 09-SEP-10

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u2/oradata/DB/system01.dbf'

released channel: tivoli
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/09/2010 07:22:34
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 8425 scn 7252066329402 found to restore
RMAN-06025: no backup of log thread 1 seq 8424 scn 7252066328952 found to restore
RMAN-06025: no backup of log thread 1 seq 8423 scn 7252066328503 found to restore
RMAN-06025: no backup of log thread 1 seq 8422 scn 7252066327998 found to restore
RMAN-06025: no backup of log thread 1 seq 8421 scn 7252066326149 found to restore

so it needs archivelogs ....

listed the archivelogs in the catalog and they are there

53175 1 8421 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8421.arc
53176 1 8422 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8422.arc
53177 1 8423 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8423.arc
53178 1 8424 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8424.arc
53508 1 8425 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8425.arc
53509 1 8426 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8426.arc
53510 1 8427 X 31-MAR-10 /u4/oradata/DB/dgarc/1_8427.arc

Tried to restore the archivelogs from Tape:

RMAN> run {
allocate channel tivoli type 'SBT_TAPE'
parms 'ENV=(TDPO_OPTFILE=/u1/app/oracle/TSM/tdpo.opt)';
set archivelog destination to '/u4/oradata/DB/dgarc';
restore archivelog from logseq=8420 until logseq=8427;
release channel tivoli;
}2> 3> 4> 5> 6> 7>

allocated channel: tivoli
channel tivoli: sid=10 devtype=SBT_TAPE
channel tivoli: Data Protection for Oracle: version 5.3.3.0

executing command: SET ARCHIVELOG DESTINATION

Starting restore at 09-SEP-10

released channel: tivoli
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/09/2010 08:46:51
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 8427 scn 7252066330305 found to restore
RMAN-06025: no backup of log thread 1 seq 8426 scn 7252066329862 found to restore
RMAN-06025: no backup of log thread 1 seq 8425 scn 7252066329402 found to restore
RMAN-06025: no backup of log thread 1 seq 8424 scn 7252066328952 found to restore
RMAN-06025: no backup of log thread 1 seq 8423 scn 7252066328503 found to restore
RMAN-06025: no backup of log thread 1 seq 8422 scn 7252066327998 found to restore
RMAN-06025: no backup of log thread 1 seq 8421 scn 7252066326149 found to restore
RMAN-06025: no backup of log thread 1 seq 8420 scn 7252066325711 found to restore


Any ideas how I get this in sync then open resetlogs?