Home » RDBMS Server » Backup & Recovery » recovery in stndby
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?

Previous Topic: recover dbf
Next Topic: Need a procedure to restore ASM RAC instance on to FileSystem.
Goto Forum:
  


Current Time: Fri Mar 29 09:52:35 CDT 2024