Hi,
We have a Target Database as PROD and catalog database as RMANREP.
we use the following script to take the backup.
===================================
connect catalog rman/rman@RMANREP;
connect target sys/manager@PROD;
run {
allocate channel t1 type 'SBT_TAPE';
backup full filesperset 10
format 'FULL_%d_%U'
(database);
release channel t1;
}
===================================
The backup is successful and we are able to see the log files correctly.
While restoring as a first case
--------------------------------------
1. We want to restore the backup which was taken few minutes back.
So we shutdown the DB.started the DB in nomount state.
restored the files using set until time.
the correct backup got restored and the database was opened with reset logs.
now when we try to restore further old backup with the same script by
changing the time
=====================================================
RMAN-20208: UNTIL CHANGE is before RESETLOGS change
=====================================================
So I reset the DB incarnation to the date.
Shutdown the DB.
started the DB with nomount.
restored the controlfile and all datafiles of the desired date.
Now till restoration from tape is perfectly working. But while
recovering the DB using
RMAN>recover database
we are having the error
===============================================================
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20208: UNTIL
CHANGE is before RESETLOGS change
===============================================================
Hence we are unable to recover the database using these files.What are
the steps to recover the old backed up files from TAPE using oracle RMAN?
Please advice any body who is using Oracle databases to recover.
Thanks for your support.
Bhaskar
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
| 