Hello,
I have a 12.1.0.2 SE2 DB that I duplicate using RMAN DUPLICATE commands and tape as device (Netbackup).
The duplicate operation changes db_unique_name from MYDB to DMYDB (as expected, reading the docs).
I have then no problems to keep aligned in time the standby database applying recovery with command like
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'
PARMS 'ENV=(NB_ORA_CLIENT=source_server,NB_ORA_POLICY=MY_POLICY,NB_ORA_SERV=netbackup_Server)';
RECOVER DATABASE UNTIL TIME 'SYSDATE - 1/24';
RELEASE CHANNEL ch00;
}
But on another database, same version, where backup is not on tape but on a NFS share accessible from both source and target server, the duplicate command is ok, but then when I try to recover with similar statement, I get error about not finding archived redo logs
The backup statement for archived redo logs is:
BACKUP FORMAT '/nfs_share_path/arc_%d_set%s_piece%p_%T_%U' TAG 'source_server' ARCHIVELOG ALL
On standby the statement to recover is
RUN {
ALLOCATE CHANNEL ch00 DEVICE TYPE DISK ;
RECOVER DATABASE UNTIL TIME 'SYSDATE - 1/24';
RELEASE CHANNEL ch00;
}
But I get errors of archived logs not found..
RMAN-06025: no backup of archived log for thread 1 with sequence 414 and starting SCN of 13319099311863 found to restore
Tried some combinations of format for recovery, but it seems it doesn't recognized the files as from the original one
If I try a crosscheck from standby it clearly returns warning about different db_unique_name... and from docs I should NEVER crosscheck from the standby:
RMAN-06216: WARNING: db_unique_name mismatch - 1434 objects could not be updated
RMAN-06218: List of objects requiring same operation on database with db_unique_name MYDB
How can I reach same target as in tape configuration? Any hint in syntax?
Thanks in advance,
Gianluca