Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> FW: IT FINALLY WORKED

FW: IT FINALLY WORKED

From: <Paula_Stankus_at_doh.state.fl.us>
Date: Wed, 10 Mar 2004 15:48:07 -0500
Message-ID: <80D4A99A2715674EB2D256DAD89219F60222AB4E@dohsmail02.doh.ad.state.fl.us>


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)
>
>
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US