Recovery Area Restore

[elmaazouz kamal]

Hello,

My backups are made in the flash recovery area.
I'm using an RMAN incrementally updated backup policy.
run
{
BACKUP INCREMENTAL LEVEL 1
FOR RECOVER OF COPY
WITH TAG 'DAILY' DATABASE;
RECOVER COPY OF DATABASE WITH TAG 'DAILY';
}
I backed up the FRA using a script like this:

run
{
allocate channel ch00 device type 'SBT_TAPE'
PARMS="SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/oracle/FRA/)";
backup recovery area;
}

Then I want to restored the control file using this script :
run
{
allocate channel ch00 device type 'SBT_TAPE'
PARMS="SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/oracle/FRA/)";
allocate channel CDISK DEVICE TYPE DISK;
restore controlfile from '/oracle/FRA/c-1862944626-20100616-00';
}

It went ok, but when I wanted to restore the database :
run
{
allocate channel ch00 device type sbt
PARMS="SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/oracle/FRA)";
allocate channel CDISK DEVICE TYPE DISK;
restore database ;
}
I got the following error:
released channel: ch00
released channel: CDISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/17/2010 18:15:32
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

My question for experts:
1- How to restore the database from the FRA backup.
2- How to restore the FRA it Self from a backup made using the
SBT_LIBRARY=oracle.disksbt.
( I'm using this because I don't have a backup robot to test with SBT).

[ddf]

1- It is incomplete so you cannot. How large is your FRA? What
release of Oracle are you using? What is your retention policy?

2- You cannot, to my knowledge.


David Fitzjarrell

[elmaazouz kamal]

1- I think I can restore the db from the FRA.
20G is the db_recovery_file_dest_size, It just almost 700M ( the
backup copy size +backupsets of 1 or 2 archives).

2- Ok, Do you know if we can do it from a real TAPE, I mean from a
real backup robot such :
- Restore the FRA first.
- Restore the database.

We're using FRA & incrementally updated backups to facilitate the
partial recovery of the database. no need to look for files in tapes.
And we try to avoid to launch two types of backups because there are
some night batches which take the whole night running.
Is there any other way to use the backup made in the FRA .

> --
> You received this message because you are subscribed to the Google Groups "ORACLE_DBA_EXPERTS" group.
> To post to this group, send email to oracle_db...@googlegroups.com.
> To unsubscribe from this group, send email to oracle_dba_expe...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/oracle_dba_experts?hl=en.
>
>

--
Amicalement
Kamal ELMAAZOUZ

[ddf]

> Kamal ELMAAZOUZ- Hide quoted text -
>
> - Show quoted text -

1 -- With a complete backup YES it is possible to restore from the FRA
but your current backup is incomplete, thus my answer.

2 -- Yes, you should be able to backup the FRA to tape and restore
from the tape backup. RMAN, however, allows you to backup the FRA but
provides no direct command to restore it.


David Fitzjarrell

[elmaazouz kamal]

1- the backup is complete it's a copy rman updated daily.
I restored from the FRA.
2- this is the problem. what is the benefit from a functionality if we
canot restore the RMAN backup of the FRA to the original disk
structure and restore from ?

Thank you for assist.

[ddf]

1 -- How can it be when RMAN reports this:

RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of restore command at 06/17/2010 18:15:32
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

2 -- There was another thread on this same topic with the same
resulting question. I find no mention of restoring the FRA from an
RMAN backup in the online documentation; there MAY be some way that
RMAN can restore it from a backup but I find no mention of that
anywhere.


David Fitzjarrell

[elmaazouz kamal]

this error is displayed because the rman didnot catalog the files of
the backup of recovery area.
but when I have the FRA in files the restore is going fine.

[ddf]

And I have learned yet another new fact.


David Fitzjarrell

[jgar the jorrible]

Of course, RMAN can run any shell script, this would be considered
doing things outside of RMAN, so one would have to understand the
rules to be sure the proper things are done. Among other things, see
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1.htm#i1009968
and think about exemptions from retentions for what you will be
restoring from tape, if this is going to be a common thing. I think a
lot of people have unrealistically short retention times.

HOST '<fullpathtoyourscript>';

jg
--
@home.com is bogus.
"Nothing like the fear of getting yelled at to make me work...." - Tom
Kyte
Funny, it has the opposite effect on me.