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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re:RE: very urgent

RE: Re:RE: very urgent

From: Rahul <rahul_at_ratelindo.co.id>
Date: Wed, 28 Mar 2001 20:01:17 -0800
Message-ID: <F001.002DAEF4.20010328193625@fatcity.com>

Ajay's going to try that one too, and we are going to get 5 more mails ! :))

> ----------
> From: Winnie_Liu_at_infonet.com[SMTP:Winnie_Liu_at_infonet.com]
> Sent: Thursday, March 29, 2001 4:27 AM
> To: Ajay Jain; kevin.little_at_blueshieldca.com; oracledba_at_lazydba.com
> Subject: Re: Re:RE: very urgent
>
>
> Ajay,
>
> Did you shutdown the database cleanly first? Then delete all the redolog
> files on the OS? If so, of course you can perform a "fake" recovery until
> cancel and open redo log on the database since all the datafile are
> offline
> and checkpoint has been performed.
>
> but if the redolog files are lost when the database is up and the instance
> crashed. I doubt if you can do the same thing.
>
> Winnie
>
>
>
>
>
>
>
> Hi here is how i did it I had a test database i deleted all the redolog
> files. including current. The database was in noarchivelog. But i think
> you
> can do for archivelog also.
>
> Oracle Server Manager Release 3.1.6.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 130801648 bytes
> Fixed Size 69616 bytes
> Variable Size 78213120 bytes
> Database Buffers 52428800 bytes
> Redo Buffers 90112 bytes
> Database mounted.
> ORA-00313: open failed for members of log group 1 of thread 1
> ORA-00312: online log 1 thread 1: '/u21/test/redo_1a.rdo'
> ORA-00312: online log 1 thread 1: '/u22/test/redo_1b.rdo'
> SVRMGR> alter database open resetlogs ;
> alter database open resetlogs
> *
> ORA-01139: RESETLOGS option only valid after an incomplete database
> recovery
> SVRMGR> recover database
> ORA-00283: recovery session canceled due to errors
> ORA-00264: no recovery required
> SVRMGR> recover database until cancel ;
> Media recovery complete.
> SVRMGR> alter database open resetlogs ;
> Statement processed.
> SVRMGR>
>
>
>
>
> > >if you have lost ALL ( including the redolog file with status CURRENT
> in
> > >V$log, V$logfile)
> > >Redolog files then there is no way to open the database .. it is called
> > >single point of failure.
> > >you must recreate the database or restore from old backup
> > >see attached notes.
> >
> > Well Golly Gee Willikers, so THATS why we do backups, eh Tex? Let that
> be
> a
> > lesson to ya varmit. Ya wanna go on the trail, you gotta take
> provisions
> or
> > ya get stranded. Oh also make sure ya don't do stupid stuff like
> rounding
> > up your redo logs on /tmp which likely gets cleared out on reboots.
> >
> > Kevin Little
> > Database Cowboy
> >
> > --------
> > Think you know someone who can answer the above question? Forward it to
> them!
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> >
> >
>
>
>
>
>
> -----------------------------------------------
> Runbox Mail Manager - www.runbox.com
> Free online email application
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>
>
>
>
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 28 2001 - 22:01:17 CST

Original text of this message

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