Re: Recovery practice

Thanks a lot for your response!

Sybrand Bakker wrote:
> Comments embedded
>

[...]
> >If I instead had used
> >SQL> ALTER DATABASE BACKUP CONTROLFILE TO
'/oracle/backup/control.bkp';
> >
> >could I have done
> >$ cp /oracle/backup/control.bkp
> >/u01/app/oracle/oradata/test/control01.ctl
> >and been saved?
>
> Yes, exactly. But then how likely is it you loose all copies of your
> controlfile in a crash?
> Rman (when properly configured) autobackups the controlfile in this
> format.

I hade some idle time, and found note 60545.1 on metalink, which helped me getting the database up again. So it seems that the controlfile was in the backupset even though rman reports that controlfile autobackup is off...

Is setting controlfile autobackup to on what you mean by properly configured?

> >---
> >connect target;
> >run {
> > RECOVER COPY OF DATABASE WITH TAG "S";
> > BACKUP INCREMENTAL LEVEL 1
> > FOR RECOVER OF COPY WITH TAG "S"
> > DATABASE;
> >}
> This is a very strange and likely dangerous script as it makes an
> *incremental* backup (ie changed blocks only). You do have a level 0
> backup somewhere don't you? Otherwise you are toast.

Now, that scares me...

from:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10735/bkup.htm#1034168 (might be wraped)

"The BACKUP INCREMENTAL LEVEL 1... FOR RECOVER OF COPY WITH TAG... command does not always create a level 1 incremental backup. If there is no incremental level 0 backup of an individual datafile to use with this level 1 backup, then executing this command creates a level 0 backup of the datafile with the specified tag."

Am I missunderstanding the concept?

ph Received on Fri Apr 15 2005 - 17:33:44 CDT