4 Replies Latest reply: Mar 15, 2013 9:48 AM by 995973 RSS

    managed recovery

    995973
      1) What is the difference between managed recovery as a foreground and managed recovery as background process?

      2) For 11g, STANDBY_ARCHIVE_DEST is no longer necessary. Right? Then at which location the archives will arrive in standby database?

      3) Can i use “archive log list” command to check the archive log destination on standby database?

      Thanks
        • 1. Re: managed recovery
          Chanchal Wankhade
          Hi,

          ******************Answer for the first poing+

          You can specify that log apply services run as a foreground session or as a background process.

          To start a foreground session, issue the SQL statement:

          SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

          Note :- This command will not show you any output as its foreground command.

          If you started a foreground session, by default, control is not returned to the command prompt.

          To start a background process, you must use the DISCONNECT keyword on the SQL statement. For example:

          SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

          Note :- It will show you command output since it will put database in backup mode in background.
          This statement starts a detached server process and immediately returns control to the user. While the managed recovery process is performing recovery in the background, the foreground process that issued the RECOVER statement can continue performing other tasks. This does not disconnect the current SQL session.

          If you did not start log apply services as a detached server process, you can stop log apply services by the issuing the following SQL statement in another window:

          SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

          *********Answer for the second point.

          It will use log_archive_dest of the standby database.


          ********Answer for the third point

          Yes. you can use the parameter archive log list to find the location of the log files.
          • 2. Re: managed recovery
            Sunny kichloo
            1) What is the difference between managed recovery as a foreground and managed recovery as background process?
            SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

            If you start a foreground session, control is not returned to the command prompt until recovery is canceled by another session.

            SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

            This statement starts a detached server process and immediately returns control to the user. While the managed recovery process is performing recovery in the background, the foreground process that issued the RECOVER statement can continue performing other tasks. This does not disconnect the current SQL session.

            Source: http://docs.oracle.com/cd/B28359_01/server.111/b28294/log_apply.htm
            2) For 11g, STANDBY_ARCHIVE_DEST is no longer necessary. Right? Then at which location the archives will arrive in standby database?
            At location specified by you in log_archive_dest_n locations

            3) Can i use “archive log list” command to check the archive log destination on standby database?
            Yes.
            • 3. Re: managed recovery
              CKPT
              1) What is the difference between managed recovery as a foreground and managed recovery as background process?
              Others already mentioned please check.
              2) For 11g, STANDBY_ARCHIVE_DEST is no longer necessary. Right? Then at which location the archives will arrive in standby database?
              Default location of log_archive_Dest_n (or) SQL> archive log list
              3) Can i use “archive log list” command to check the archive log destination on standby database?
              Yes. it refers to local destination
              • 4. Re: managed recovery
                995973
                Thanks Chanchal Wankhade, Sunny kichloo and ckpt