I'll take that as a no... Sybrand, you crack me up.
Thanks Gang, thought so, just checking...
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:e1nc8u01bdur8updplda7dcnqo576h6kk3_at_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 - 15:23:30 CST
