Re: How to OPEN RESETLOGS when not recovering?

From: Allan Plesniarski <aplesnia_at_my-deja.com>
Date: Mon, 27 Mar 2000 16:44:28 GMT
Message-ID: <8bo357$aio$1@nnrp1.deja.com>

fake recovery then resetlogs:

SVRMGRL> recover database until cancel; Media recovery complete - comes back right away because datafiles are consistent
SVRMGRL> alter database open resetlogs; - will write or overwrite logfiles in path stored in controlfiles

In article <8bo1s5$8uf$1_at_nnrp1.deja.com>, argosy22_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 10:44:28 CST