Hi Rich... I think your problem is here: > the create statement, so it looks like: > CREATE CONTROLFILE SET DATABASE "DST" RESETLOGS > ARCHIVELOG If I'm wrong, others can correct me, but,... if you are using RESETLOGS, then you are resetting your log sequence to 0. I think you can try this: sql> @/tmp/cntrl.sql sql> recover database until cancel using backup controlfile; when asked for archive logs, type: CANCEL then... sql> alter database open resetlogs; this should open your db... HTH JL --- Rich Holland <holland@xxxxxxxxxxxxxxxx> wrote: > On the source system (SRC), I create a SQL copy of > the control file: > SQL> alter database backup controlfile to trace; > > Then I force log switches (four, just to be safe): > SQL> alter system archive log current; > SQL> alter system archive log current; > SQL> alter system archive log current; > SQL> alter system archive log current; > > the create statement, so it looks like: > CREATE CONTROLFILE SET DATABASE "DST" RESETLOGS > ARCHIVELOG > > SQL> @/tmp/cntrl.sql > > This creates the control files successfully. I > realize there will likely be > some media recovery needed > > SQL> recover database using backup controlfile > until CANCEL; > > ...It rolls through log 400, > which was the last of the 4 I > created with the 'alter system archive log current' > commands earlier. When it > asks for 401, there isn't anything to give it, so I > CANCEL the recovery, but I > see this error: > > ORA-01547: warning: RECOVER succeeded but OPEN > RESETLOGS would get > error > below > ORA-01195: online backup of file 1 needs more > recovery to be consistent > ORA-01110: data file 1: > '/oracle/DST/sapdata1/system_1/system.data1' > > Help! What am I overlooking here? I could swear > I've done it this way in > previous releases with no problems.... > > Thanks! > Rich > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: > oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at > //www.freelists.org/archives/oracle-l/ > FAQ is at > //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- __________________________________ Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------