How to OPEN RESETLOGS when not recovering?

From: <argosy22_at_my-deja.com>
Date: Mon, 27 Mar 2000 16:22:48 GMT
Message-ID: <8bo1s5$8uf$1@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 - 10:22:48 CST