Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 684
  • Last Modified:

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....
0
gattu007
Asked:
gattu007
  • 2
  • 2
  • 2
4 Solutions
 
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
 
MikeOM_DBACommented:

Try normal startup.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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
 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now