try open resetlogs. you won't be able to fully recover but you might
get the database open
- Rahul <rahul_at_ratelindo.co.id> wrote:
> i am able to re-create the control file ..
> but on doing "recover database using backup controlfile" the
> database is
> requesting a "change#" which was in the deleted online redo log !!!
> now what ???
>
>
> > ----------
> > From: Rahul
> > Sent: Friday, August 16, 2002 1:57 PM
> > To: 'Oracle List I'
> > Subject: test scenario # 1, dropped online redo logs
> >
> > list, i will be testing various recovery scenarios on a test
> instance..
> >
> > my db is in archive log.. i hv a cold backup, i created a table,
> inserted
> > some records and
> > switched the logfile.. (i dnt hv a hot backup) , then i deleted
> both the
> > online redo logs.
> >
> > now i;m trying to re-create the controlfile (with resetlogs) but
> it fails
> > with..
> >
> > CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS ARCHIVELOG
> > *
> > ORA-01503: CREATE CONTROLFILE failed
> > ORA-01158: database already mounted
> >
> > before i issue the create controlfile command... i do a .
> >
> > svrmgr30> startup nomount
> >
> > i have the following questions..
> >
> > 1) why i'm getting this error
> > 2) is re-creating the controlfile the *only* way out after the
> online logs
> > are removed ?
> >
> > TIA
> > rahul
> >
> >
> >
> >
> --
> 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).
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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 Fri Aug 16 2002 - 06:08:25 CDT