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!

Alter system switch logfile

Beauty_and_dBestJul 29 2015 — edited Jul 30 2015

Hi ALL,

rhel5

We are making the standby database as our reporting server. This is to offload some workload from PROD to improve performance.

To get the latest data, or before running the reports on the standby server, I will issue first > alter system switch logfile;

So that the standby database will be updated the latest transactions todate.

How many times should I run the command? Is it enough to run it once only? or I will run it n times depending on the number of redo logs?

Thanks a lot.

This post has been answered by Pravin Takpire on Jul 29 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2015

Added on Jul 29 2015

#data-guard, #performance-availability

20 comments

15,025 views