|recovery in stndby [message #409592]
||Tue, 23 June 2009 04:13
Registered: September 2008
I have been thinking about the below scenerio for the last two weeks, but still have doubts.
I have a primary database and a standby database ( not a real standby,it is in mount state, and
I apply archivelogs manually).
I will rebuild some tablespaces from DMT to LMT.
After I move the data inside the test1 I will issue:
drop tablespace test1;
create tablespace test1
datafile 'C:\oraclexe\oradata\XE\test1.dbf' reuse;
Move the data back to the test1;
Again, I move the data inside the test2 and issue:
drop tablespace test2;
create tablespace test2
datafile 'C:\oraclexe\oradata\XE\test2.dbf' reuse;
Move the data back to the test2;
What I want to ask is, during recovery I hit an error message in standby database.
What should I do in standby database in this issue?
If I copy the controlfile from primary database and issue:
alter database create datafile 'C:\oraclexe\oradata\XE\test1.dbf' as 'C:\oraclexe\oradata\XE\test1.dbf';
alter database create datafile 'C:\oraclexe\oradata\XE\test2.dbf' as 'C:\oraclexe\oradata\XE\test2.dbf';
and then start recovery, will it solve the problem?
I am not sure if I need to copy controlfile or something else?