Re: hot backup question

I have a related question. After I've done the OS copy of the data files
to a disk on the system, can I then use a backup program to put them to
tape? If so, is this reliable? The reason I ask, is I want to be able
recover the hot backup data files from tape. If I loose the disk drive that
has the hot backup data files I want to be able to recover them as well.
Does this make any sense?

Thank you,

Joe

Andrew Babb wrote:
>
> Hi Peter,
>
> Since it is unwise to read the current Redo Log file while it is still being
> written to (due to inconsistencies), I get round this by;
> 1. Perform a manual Log Switch prior to starting the Hot Backup
> 1a. Put all Archived Log files onto the backup media (optional if you can,
> otherwise leave until step 5).
> 2. Perform the Hot Backup as per current methods
> 3. Perform a manual Log Switch after the Hot Backup
> 4. Create the backup controlfile
> 5. Put the Archived Redo Log files and Backup Control file on to the backup
> media
>
> In this way, if you need to recover from this backup, you know that all the
> Redo Log files that will be needed are available (not still current and
> online) due to step 3.
> If you loose the Control Files, then you have at least the Backup Control
> File from when the database was backed up, step 4.
> You also know that recovery starts from Archive Log file taken in step 1,
> and if you want, you can erase all previous log files. I use this number for
> the next backup, so I know that if the Backup is corrupt, I can get the
> backup from before and still recover with all Log files.
>
> Andrew
>

--

Joe Driscoll
Database / UNIX Systems Administrator
News Internet Services
978-551-1153
joe_at_newsdigital.com
http://www.newsinternet.com

"Whether you think you can
or you can't, you're right"
Henry Ford Received on Tue May 18 1999 - 08:41:34 CDT