Re: Cold backups on linux

You didn't mention archivelog mode, so I assume you are not archiving the redo logs.

If you are taking daily cold backups but not archiving your redo logs, then a media failure just before the daily backup can cause the loss of that full day's production. Is this OK with your users? Maybe they think they are fully protected?

I am not making this judgment -- just be sure the users understand that they may have to repeat a full day of work.

I have found that most users tell me not to go to any extremes like archiving, but I should be sure that they are protected up to the second.

Mark Wagner wrote:

> This is how I'm doing cold backups and recovery: Is this ok? Are there any
> problems i might run in to later?
>
> Im running Oracle 8.0.5 on redhat linux 5.2
> The box im working on is scheduled to go into production in the next few
> weeks. currently i am doing a cold backup nightly of:
> /u01/app/oracle/product/8.0.5/dbs/mydatafile.ORA
> and everything inside of:
> /u02/oradata/ORCL/
> /u03/oradata/ORCL/
> /u04/oradata/ORCL/
>
> When formatted all the drives, and reinstalled....
> and recovered the datafiles, control files, and redologs back to there
> original locations
> The database starts just fine....
>
> Mark Wagner
> New DBA
Received on Sat Jun 12 1999 - 10:16:35 CDT