Re: Simple backup questions

Yes, you need to back up your redo logs.

When attempting to recover your database, you should only restore any deleted or damaged files from your last backup. Leave any intact files in place. Do not replace your control files. When you attempt to open the database Oracle will realize that some of the files are out of synch and need recovery, and will prompt you for the archive logs.
If you restore all the files from your cold backup they will all be in synch and there will be no way for Oracle to know that recovery is needed.

Before doing anything, it's always a good idea to backup everything first. If you make a mistake, you can always go back to where you started.

Good luck!

poohland_at_hotmail.com wrote:

> Just two very simple backup questions,
>
> 1. I've read several books talking about whether we should backup the online
> redo log files. Oracle Press book say yes but I remember some one post in this
> newsgroup earlier saying that we don't need to backup the online redo log
> files. Can some one verify that for me please?
>
> 2. When I use the cold backup to recover the database to the point of failure
> (database in archivelog mode), I think that I only have to restore all the
> datafiles to its original location but definitely not the controlfiles? I
> think if you restore all the datafiles to its original location and leave the
> controlfiles as current. when we try to open the database, Oracle should
> discover that the header of the datafile and the controlfile is not in sync
> and should start the recovery process and ask for archive logs, right? (I
> hope I am right, but I am not sure any more!) What if the backup utility that
> we use force me to restore the controlfiles and replace those current
> controlfiles with those old controlfiles? If I still have all the archive
> logs from that cold backup onwards, can I force Oracle to start the recovery
> process even though the controlfiles(restored one) and the datafiles
> (restored one) are in sync already?
>
> It's really urgent, please help me with that!
>
> Winnie Liu
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Jul 21 1998 - 00:04:05 CDT