standby database query - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: standby database query

  1. #11
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    Hi i have tried this command several times but shipped logs do not get applied to standby database.
    the seq of commands i executed is as follows:

    SQL> startup nomount
    ORACLE instance started.

    Total System Global Area 135338868 bytes
    Fixed Size 453492 bytes
    Variable Size 109051904 bytes
    Database Buffers 25165824 bytes
    Redo Buffers 667648 bytes
    SQL> alter database mount standby database;

    Database altered.

    SQL> recover managed standby database disconnect from session;
    Media recovery complete.
    SQL> recover managed standby database cancel;
    ORA-16136: Managed Standby Recovery not active


    SQL> alter database open read only;

    Database altered.

  2. #12
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Oracle for sure provide some information in the alert log. Why don't you read your alert log or any trace files and find out what is going on after you start the MRM?

    once again make sure that all the logs are are shipping to standby location and you don't have any archive log gaps.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  3. #13
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    man i read those files the first time i encountered the error. But not able to figure out what went wrong..MRP0 starts and completes successfully but logs do not get applied. anyways thanks for responding.

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