Hi,
How to deal with offline dropped datafiles on source when creating standby .
I've 4 node rac, and one tablespace offline and related bigdatafile droped offline (because of corruption).
SQL> select tablespace_name , status from dba_tablespaces order by status ;
TABLESPACE_NAME STATUS
------------------------------ ---------
OLD_TBS OFFLINE
SQL> select TS#,STATUS,ENABLED from v$datafile order by status;
TS# STATUS ENABLED
---------- ------- ----------
16 OFFLINE DISABLED
Its 4 node RAC 10.2.0.3 and ASM .
select name,TS#,STATUS,ENABLED from v$datafile order by status
+DBG1/dbname/datafile/bigfile.279.615031073
Currently I'm doing something like that
rman target /
catalog backuppiece '/oarch/backup/bigfile.279.615031073';
run{
allocate channel ch1 type disk;
SET NEWNAME FOR DATAFILE 16 TO '+DBG1';
restore datafile 16 from tag='TAG20100209T124507';
SWITCH DATAFILE 16;
release channel ch1;
}
and then after duplicate is end
SQL> alter database datafile 16 offline drop;
SQL> recover automatic standby database;
Please advice.
Regards
GregG