This was interesting guys! > -----Original Message----- > From: Stankus, Paula G > Sent: Wednesday, March 10, 2004 3:43 PM > To: Stankus, Paula G; Evans, Gary > Subject: RE: fyi > > So - I took a chance and tried to trick Oracle. I knew that I needed to get > the archive log sequence 14613. > > So I used the following: > > recover database until cancel using backup controlfile > > I knew it would prompt me for archive logs by sequence number > > It asked for 14614. I knew I had 14613 so I "cancelled" > > I then did alter database open resetlogs > and got and error because the file system for the logs wasn't there. > > Quickly created that > > alter database open; > > and it did. Let me know if there are problems. However, I believe it is up > and running. > > Will do further verification. > > -----Original Message----- > From: Stankus, Paula G > Sent: Wednesday, March 10, 2004 3:35 PM > To: Evans, Gary > Subject: fyi > > Script - date based on querying rman catalog for last good backup: > > run { > execute script alloc_all_tapes; > restore controlfile to '/data/oradata/CSTAT/ctrl/control01.ctl'; > allocate channel d1 type disk; > replicate controlfile from '/data/oradata/CSTAT/ctrl/control01.ctl'; > sql 'alter database mount'; > restore database until time > "to_date('JAN 27 2004 12:00:00','MON DD YYYY HH24:MI:SS')"; > recover database; > sql 'alter database open resetlogs'; > execute script rel_all_tapes; > } > EOD > > > restore/recovery > > RMAN-03022: compiling command: recover(3) > RMAN-03023: executing command: recover(3) > RMAN-08054: starting media recovery > RMAN-08060: unable to find archivelog > RMAN-08510: archivelog thread=1 sequence=14613 > > RMAN-03022: compiling command: recover(4) > RMAN-03023: executing command: recover(4) > RMAN-08017: channel t1: starting archivelog restore to default destination > RMAN-08022: channel t1: restoring archivelog > RMAN-08510: archivelog thread=1 sequence=14613 > RMAN-08023: channel t1: restored backup piece 1 > RMAN-08511: piece handle=al_CSTAT_s14528_p1 params=NULL > RMAN-08024: channel t1: restore complete > RMAN-08515: archivelog filename=/data/arch/log0000014613.arc thread=1 > sequence=1 > 4613 > ./resctrlcore.sh[18]: 23585 Segmentation Fault(coredump) > > >