| recovery in stndby [message #409592] |
Tue, 23 June 2009 04:13 |
tjay
Messages: 37
Registered: September 2008
|
Member |
|
|
Hi DBAs
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;
So on...
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
