Re: Simple archive question

You are missing some important points.

First, what type of recovery are you trying to simulate? Loss of only some db files? Loss of entire machine? The type loss dictates what you would restore. You just don't go copying all backup files into production if you don't need them for the recovery.

Second, you should not be backing up the online redo log files. These should be multiplexed, but not included in a backup scenario (for just the reason you discovered, you over-wrote the production ones when you copied your files back).

Third, your control files should be multiplexed as well. You should also back them up, but should only restore them if absolutely necessary.

Read up on backup/recovery concepts because there are so many different ways to backup and recover and you need to be familar with all of them. Received on Thu Mar 10 2005 - 13:21:09 CST