Redo logs not copied to standby database

I have created a dataguard using RMAN duplicate for standby database command.

The structure is same on my production and standby server so I did not add the convert parameters. The standby database is doing fine but I do not see the redo logs on my standby database. They did not get copied into the standby database.

I can see them when with v$logfile but physically they do not exist.

How can I create them now on standby database?

do I need to drop them and recreate them?

Thanks in advance....
LVL 7
gattu007Asked:
Who is Participating?
 
johnsoneSenior Oracle DBACommented:
Yes, they will be automatically created when the database is opened after the failover.

This is the default behavior of Oracle.  It works the same way with a hot backup.  After you restore the backup, which will not contain the redo logs, when the database is opened, they will be automatically be created.
0
 
MikeOM_DBACommented:

It may be your stanby is in recovery mode.
The redo logs will not be created until you actually OPEN the database.
0
 
gattu007Author Commented:
I did open the standby database in read only mode but the redo logs did not get created.

0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
MikeOM_DBACommented:

Try normal startup.
0
 
johnsoneSenior Oracle DBACommented:
They will be created with the standby database is activated.  They are not needed while it is recovering.
0
 
gattu007Author Commented:
Thanks for your suggestion. Will they get automatically created if I switch over / failover to standby?

This is 400 GB production database so I cant switchover / failover to check.


I did the same configuration in my test environment and rman has created redo logs...but it had flash recovery area enabled.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.