Data Guard problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Data Guard problem

  1. #1
    Join Date
    Jan 2004
    Location
    Bangalore, India
    Posts
    66

    Unhappy Data Guard problem

    All,

    I have configured 2 test servers to act as primary and secondary databases in a Data Guard environment.

    Everything seemed to work fine till I issued :
    ALTER DATABASE RECOVER managed standby database;
    on the standby database. It takes a very long time to execute...

    I have attached part of my alert log for u to assess
    Here it is:
    Thu Mar 18 17:22:42 2004
    ALTER DATABASE RECOVER managed standby database
    Media Recovery Start: Managed Standby Recovery
    Starting datafile 1 recovery in thread 1 sequence 2
    Datafile 1: '/oradata1/stby/prod/system/system01.dbf'
    Starting datafile 2 recovery in thread 1 sequence 2
    Datafile 2: '/oradata2/stby/prod/sfw_undo/sfw_undo_01.dbf'
    Starting datafile 3 recovery in thread 1 sequence 2
    Datafile 3: '/oradata1/stby/prod/sfw_data/assoc_data_01.dbf'
    Starting datafile 4 recovery in thread 1 sequence 2
    Datafile 4: '/oradata2/stby/prod/sfw_index/assoc_index_01.dbf'
    Starting datafile 5 recovery in thread 1 sequence 2
    Datafile 5: '/oradata1/stby/prod/sfw_data/attend_data_01.dbf'
    Starting datafile 6 recovery in thread 1 sequence 2
    Datafile 6: '/oradata2/stby/prod/sfw_index/attend_index_01.dbf'
    Starting datafile 7 recovery in thread 1 sequence 2
    Datafile 7: '/oradata1/stby/prod/sfw_data/hr_evnt_docs_data_01.dbf'
    Starting datafile 8 recovery in thread 1 sequence 2
    Datafile 8: '/oradata2/stby/prod/sfw_index/hr_evnt_docs_index_01.dbf'
    Starting datafile 9 recovery in thread 1 sequence 2
    Datafile 9: '/oradata2/stby/prod/sfw_index/indx01.dbf'
    Starting datafile 10 recovery in thread 1 sequence 2
    Datafile 10: '/oradata1/stby/prod/sfw_data/lt_tables_data_01.dbf'
    Starting datafile 11 recovery in thread 1 sequence 2
    Datafile 11: '/oradata2/stby/prod/sfw_index/lt_tables_index_01.dbf'
    Starting datafile 12 recovery in thread 1 sequence 2
    Datafile 12: '/oradata1/stby/prod/sfw_data/office_config_data_01.dbf'
    Starting datafile 13 recovery in thread 1 sequence 2
    Datafile 13: '/oradata2/stby/prod/sfw_index/office_config_index_01.dbf'
    Starting datafile 14 recovery in thread 1 sequence 2
    Datafile 14: '/oradata1/stby/prod/sfw_data/sched_config_data_01.dbf'
    Starting datafile 15 recovery in thread 1 sequence 2
    Datafile 15: '/oradata2/stby/prod/sfw_index/sched_config_index_01.dbf'
    Starting datafile 16 recovery in thread 1 sequence 2
    Datafile 16: '/oradata1/stby/prod/sfw_data/tools01.dbf'
    Starting datafile 17 recovery in thread 1 sequence 2
    Datafile 17: '/oradata1/stby/prod/sfw_data/users01.dbf'
    Media Recovery Log
    Media Recovery Waiting for thread 1 seq# 2

    All datafiles have been recovered (17 in all). But the command has not been completed on the sql prompt. When I query the session, I see that it's ACTIVE.
    Any suggestions, ideas, solutions.....???

    Thanks in advance...
    Regards,
    Suhas

  2. #2
    Join Date
    May 2001
    Posts
    73
    What is your Oracle version?

Posting Permissions

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


Click Here to Expand Forum to Full Width