Re: Is this method of offline backup OK?

> > Care to explain what you would do, in noarchivelog mode, when it comes time
> > to restoring a cold backup missing the online logs? How will you get the
> > database open without redo logs? Right: you'll have to sit there in the
> > mount stage issuing 'alter database add logfile' commands. Fine if you know
> > the syntax off the top of your head. Fine if you have the Big Boy's Book of
> > Syntax ready to hand. Personally, I'd just as happily restore *.*, and
> > issue the startup command.
>
> Sorry, "alter database add logfile"? Why would I do that? Why wouldn't
> I just do an alter database clear logfile group "x"? That way I don't
> have to bother getting the file format correct, and I don't have to
> bother dropping the old groups.
>

Sorry for jumping in at this juncture, but why drop, add or clear logfiles ? You can do an "alter database recover until cancel" (fake recovery) and then open resetlogs. That will create the logfiles anew. Unless, of course, you have something against resetting the logs back to zero (I know some people who dont like it).

Murali
http://www.dbaquest.com/ Received on Thu Mar 14 2002 - 09:58:27 CST