> 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@(protected) > 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 (See ORA-01547.ora-code.com): warning: RECOVER succeeded but OPEN
> RESETLOGS would get
> error
> below
> ORA-01195 (See ORA-01195.ora-code.com): online backup of file 1 needs more
> recovery to be consistent
> ORA-01110 (See ORA-01110.ora-code.com): 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@(protected)
> 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
>
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
__ ____ ____ ____ ____ ____ ______
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
