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

Thread: Can you mirror online logs onto a Standby remote server?

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Can you mirror online logs onto a Standby remote server?

    We are using the Standard Edition of Oracle, and we have a Standby server set up. When we do a disaster recover, we apply all the archive logs but then open up the database 'resetlogs'. Can we mirror the online logs to the standby database, and then,once we have done a recovery, open the standby using the 'mirrored' online logs, so the Standby database will have no 'lag' behind the Primary database? Thanks. Rgds. Sheryl

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    No.
    You should read the oracle documentation on using Datagaurd with no divergence and zero data loss.

    regards
    Hrishy

  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Hi, thanks for the info. Do you know why you can't use the mirrored online logs?

    We are using Oracle Standard and Dataguard is not available with this option. We use Dataguard on other sites that have the Enterprise license.

    Thanks.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by hrishy
    You should read the oracle documentation on using Datagaurd with no divergence and zero data loss.
    Isn't Dataguard an Enterprise Edition feature? Poster states to be running on Standard Edition.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Hi, I don't understand what you are asking?

    As mentioned above, we are running on Oracle Standard, therefore we can't use Dataguard. This is why I am asking the question on using mirrored online logs. Thanks.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by ssmith
    Hi, I don't understand what you are asking?

    As mentioned above, we are running on Oracle Standard, therefore we can't use Dataguard. This is why I am asking the question on using mirrored online logs. Thanks.
    Please read again my post... I was asking hrishy and also making a note about you being running on SE.

    In regards to your question, you already got your answer. If you do not truth hrishy why don't you try?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Thanks for your input. I just wanted to understand the reason why we can't use mirrored online logs for a standby database. Thanks. Rgds. Sheryl

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