Re: cold backup/ is this right?

Please keep in mind any change after the cold backup will be lost after a crash when running in noarchivelog.
IMO, running a production instance in noarchivelog is just plain stupid. Just to warn you.

Hth,

--
Sybrand Bakker, Oracle DBA
Peter Kellner <peter_at_kellner.com> wrote in message news:387ada4c.111984830_at_news.pacbell.net...
> I want to make a general "cold" backup procedure for my many customers
> running oracle 7.3.4 in noarchivelog mode on windows NT. My thoughts
> are that if I get a list of all the datafiles (select * from
> v$datafile), backup those, then backup the control files, that this
> should be everything. Is this true?
>
> My thoughts are that if there is a crash, the user can restore a full
> cold tape backup (or install NT and oracle just as they did the first
> time), then simply put all the datafiles back, then put the control
> files back, restart oracle, and they should be good as new.
>
> Two questions:
>
> 1. Am I out to lunch? If so, how
>
> 2. Is there an sql select that tells me what the names and directory
> locations of the control files are.
>
> Thanks in advance.
>
> -Peter
Received on Tue Jan 11 2000 - 04:11:23 CST