Re: resetlogs

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Mar 2002 19:15:53 +0100
Message-ID: <e1nc8u01bdur8updplda7dcnqo576h6kk3@4ax.com>

On Wed, 06 Mar 2002 14:42:26 GMT, "clueless" <ro_cright_at_hotmail.com> wrote:

>Is there a way I can resetlogs on the production instance while it is open
>and then redo the hot backup???

Let me just laugh...
Question : what is the syntax for resetlogs? Answer: alter database open resetlogs
So when can you issue this statement?
Answer: after a startup mount
What do you need to do prior to a mount? Answer: close the database and dismount the instance, also known as shutdown.
So can you issue resetlogs on an open database. NO WAY, AND THAT IS GOOD Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Mar 06 2002 - 12:15:53 CST