-
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
-
Hi
No.
You should read the oracle documentation on using Datagaurd with no divergence and zero data loss.
regards
Hrishy
-
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.
-
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.
-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|