Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cold backup/ is this right?
Peter,
I think if you query the following data dictionary views, you should get the files needed for a valid cold backup:
SELECT name FROM v$datafile;
SELECT member FROM v$logfile;
SELECT name FROM v$controlfile;
As for question 1, aren't we all??? (why no archivelog? it would make your life easier, probably, if it were on!)
Sarah
Peter Kellner wrote:
> 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 - 02:44:12 CST