From rahul@ratelindo.co.id Wed, 28 Mar 2001 20:01:17 -0800 From: Rahul Date: Wed, 28 Mar 2001 20:01:17 -0800 Subject: RE: Re:RE: very urgent Message-ID: MIME-Version: 1.0 Content-Type: text/plain Ajay's going to try that one too, and we are going to get 5 more mails ! :)) > ---------- > From: Winnie_Liu@infonet.com[SMTP:Winnie_Liu@infonet.com] > Sent: Thursday, March 29, 2001 4:27 AM > To: Ajay Jain; kevin.little@blueshieldca.com; oracledba@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@LAZYDBA.com > > to subscribe send a blank email to oracledba-subscribe@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@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@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@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@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@LAZYDBA.com > to subscribe send a blank email to oracledba-subscribe@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@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@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).