Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why create redo logs in standby?

unknown-2698904Jul 9 2014 — edited Jul 10 2014

Hi all,

11.2.0.3.10

aix 6

I tried to follow this doc which installing/configuring dataguard > http://www.oracle-base.com/articles/11g/data-guard-setup-11gr2.php

I am just confused about the following steps:

Restore the backup files.

==================

$ export ORACLE_SID=DB11G

$ rman target=/

RMAN> STARTUP MOUNT;

RMAN> RESTORE DATABASE;

Create Redo Logs

=============

Create online redo logs for the standby. It's a good idea to match the configuration of the primary server.

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=MANUAL;

ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/oradata/DB11G/online_redo01.log') SIZE 50M;

ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/oradata/DB11G/online_redo02.log') SIZE 50M;

ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/oradata/DB11G/online_redo03.log') SIZE 50M;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

My question is, why do I need to create online redo logs for standby, when they are already created when you restore the backup?

Are the online redo logs does not match with the backup? or not being backed-up?

Thanks,

mk

This post has been answered by Hemant K Chitale on Jul 10 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2014
Added on Jul 9 2014
24 comments
6,086 views