Skip to Main Content
Forums

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!

ora-02095 when trying to change log_file_name_convert

788967Aug 4 2011 — edited Aug 4 2011
Hi all,

Iv'de just rebuilt a standby database 11gR2 under HP-UX (Physical standbyData Guard)

In the alert I see some errors related to the location of the online redo logs.
I think is has to do with LOG_FILE_NAME_CONVERT parameter

I have redo logs in two locations so I should use 2 pairs of parameters to convert path from primary to standby.

When I execute: alter system set LOG_FILE_NAME_CONVERT='/oradata/primary','/oradata/standby','/FRA/primary','/FRA/standby' scope = both; it returns:

ORA-02095 specified initialization parameter cannot be modified.

How can I tell to Oracle that redo log are in a different location at standby site?

If I query v$log in standby, location is wrong, for some redo logs it displays /FRA/primary and it shoud be /FRA/standby

Thanks a lot
This post has been answered by mseberg on Aug 4 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2011
Added on Aug 4 2011
#data-guard, #performance-availability
1 comment
1,482 views