Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    38

    Unanswered: recovery in standby

    Hello 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?

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    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?
    My answer to this would be that it depends entirely on what the error message is. It's like saying "if my car doesn't start in the morning should I change the engine?" Who knows what needs doing unless you've got some diagnosis to work with.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2009
    Posts
    7
    fastest way will be copy datafile changed in primary to secondary and then controlfile and restart the recovery.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •