cold backup/ is this right?

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 - 01:26:09 CST