hello,
In a 11.2.0.3 oracle database, I'm trying to setup a physical standby database with rman duplicate from active database.
I run it once, and I had to add new datafiles to the primary. Than, it failed because of out of disk space at standby site. Since it's data is huge (~ 9 TB) I didn't want to start from the begining and tried to resume.
To skip datafiles already copied, I put the "SET UNTIL SCN" clause to the scn of uncomplete standby db. It skipped all datafiles already copied but gave an error for recently added datafiles.
Is it possible to resume with already copied datafiles?
Thanks...
My script:
run {
SET UNTIL SCN 13557146842989;
allocate channel tar1 type disk;
allocate channel tar2 type disk;
allocate channel tar3 type disk;
allocate channel tar4 type disk;
allocate auxiliary channel aux1 type disk;
allocate auxiliary channel aux2 type disk;
allocate auxiliary channel aux3 type disk;
allocate auxiliary channel aux4 type disk;
duplicate target database
for standby
from active database
dorecover
nofilenamecheck;
Output:
sql statement: alter database mount standby database
Using previous duplicated file +DATA/.... for datafile 2 with checkpoint SCN of 13573985035694
Using previous duplicated file +DATA/... for datafile 5 with checkpoint SCN of 13563313852934
....
...
Using previous duplicated file +DATA/... for datafile 377 with checkpoint SCN of 13569256485600
...
...
...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/07/2014 09:46:54
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 299
...
...