Re: Are cold backups necessary?

ccisaac_at_mtu.edu (Chuck Isaacson) wrote:

]This is off the point, but what were the circumstances that had a
]shutdown abort corrupt the database? I have never experienced this.
]In fact, I typically shutdown abort and then immediately bring Oracle
]back up and then shutdown normally without a problem.

While this doesn't really corrupt the database, it can cause some heartache. If Oracle goes down during a hot backup, you have to do media recovery on the tablespaces that were in backup at the time. Thus if your archive logs are not available in the ARCH directory, and uncompressed, you have a bit of fiddling to do before you can restart Oracle.

If the archive logs are available, you need to do a "recover database".

I would like to see someone tell me I am wrong here, and tell me an easier way of restarting Oracle during a hot backup. The above is a pain early in the morning.

gedau_at_mim.com.au Received on Mon Mar 18 1996 - 00:00:00 CET