Re: cold backup/ is this right?

No, no, no, no, no!

First, never run a production database in noarchivelog mode. You will never be able to recover to a point in time, nor will you be able to recover just one tablespace.

Second, there are several file types that you must get in order to have a valid backup:

1. data files (v$datafile)
2. control files (v$controlfile)
3. init.ora file ($ORACLE_HOME/dbs/init<SID>.ora)
4. config.ora file (specified in init.ora)
5. password files (?)
6. redo log files (v$logfile)

And for the anal retentive,
7. backup $ORACLE_HOME

Lastly, you didn't mention if your database will be up or down, but I assume you know you can't do a valid cold backup a database while it is up.

Peter Kellner wrote in message <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 - 13:51:06 CST