Re: How to OPEN RESETLOGS when not recovering?

From svrmgrl (the database must be open and quiet):

connect internal
alter system switch logfile;
shutdown
startup mount
recover until cancel
...
<say "cancel" at the first "suggestion" prompt> ...
alter database open resetlogs;
shutdown
exit

Don't forget to make a full database backup before and after that operation.

<argosy22_at_my-deja.com> wrote in message news:8bo1s5$8uf$1_at_nnrp1.deja.com...
> Hi all,
>
> We are using Oracle 7.3.4.
>
> I shutdown the database and did a full backup
> of all the files.
>
> I wanted to OPEN RESETLOGS and whack all the
> archived redo information.
>
> In svrmgrl, I did:
>
> connect internal
> alter database open resetlogs
>
>
> but got the error:
> ORA-01139: RESETLOGS option only valid after an incomplete database
> recovery
>
> Trying the command:
> alter database recover database
>
> gave:
>
> ORA-00283: Recovery session canceled due to errors
> ORA-00264: no recovery required
>
>
> What do I need to do, to reset the archiving to the beginning?
>
>
> Thanks,
>
> Argosy
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 27 2000 - 11:00:28 CST