1 Reply Latest reply: Sep 17, 2013 8:44 AM by mseberg RSS

    recovering standby database

    951674

      Hallo,

       

      i am working to prepare a manual managed standby database.

      When i say recover standby database - from which place the database will read archivelog files?

      any help is appreciated

       

      thanks in advance

        • 1. Re: recovering standby database
          mseberg

          Hello;

           

          Not sure I understand the question. But if you setup FRA on both the Primary and Standby servers you can collect and managed archive there very nicely.

           

          log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRIMARY'

           

          log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STANDBY'

           

          Best Regards

           

          mseberg