Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> FW: IT FINALLY WORKED
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)
>
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 10 2004 - 14:53:35 CST
![]() |
![]() |