DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: recover managed standby database

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    recover managed standby database

    i issued the below to let my oracle to apply the redo logs from the production database.

    SQL> recover managed standby database;

    however, it just hangs like this. what i did is to terminate the telnet session..

    is that command supposed to behave this way?

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    That is how it works.
    In order to cancel a sustained recovery session, from another server manager session issue the following command:
    PHP Code:
    SVRMGRalter database recover managed standby database cancel
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Oct 2002
    Posts
    391
    i only did a "recover managed standby database cancel;"

  4. #4
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by yls177
    i only did a "recover managed standby database cancel;"
    dude you need to read the data guard books, I assume this is 9i as you have so referenced in previous posts

    you would do this on the standby
    ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
    I'm stmontgo and I approve of this message

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    yls177,

    From some other questions you've asked lately it seems that you are seriously diving into the deep watters of Data Guard. If so, why don't you first study the Data Guard Concepts Manual, because it seems that you are lacking some basic standby database features/concepts understanding?
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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