Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create standby having offline dropped datafile .

698658Jun 12 2012 — edited Jun 18 2012
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
This post has been answered by Hemant K Chitale on Jun 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2012
Added on Jun 12 2012
15 comments
1,978 views