Re: Is this method of offline backup OK?

"Howard J. Rogers" wrote:
>
> "Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
> news:3C8F0E4E.77831FA5_at_BACKSIESearthlink.net...
>
> > If you have a more authoritative source for what Oracle recommends than
> > the company's own documentation, I'd love to see it.
>
> It's in the Oracle Backup and Recovery course material (which I teach
> regularly):

And you're saying that Oracle course materials trump Oracle standard documentation?

> You've missed the point. The man is in NOARCHIVELOG mode.

Really? Where did he say that? I don't see anything in his post indicating his archivelog status. All he said was that he's doing offline backups.

> Therefore he
> loses those transactions anyway, since in that mode, recovery is to the time
> of the last backup, not the time of the failure.

*IF* he's in noarchivelog mode, then yes, of course.  

> Look at the list of v$ views the original poster was using before taking his
> backup. Do you see any mention of v$archive_log there? If you're going to
> take a backup, and you are running in archivelog mode, don't you think you
> should know what archives you should include in the backup?

No, since it's a COLD backup. Why would he care about v$archived_log for a cold backup? Nothing he wrote says he wasn't doing a cold backup of a database in archivelog mode.

Regards,
Sean Received on Wed Mar 13 2002 - 13:47:07 CST