Database - RAC/Scalability (MOSC)

MOSC Banner

log_file_name_convert

edited Aug 28, 2009 3:23AM in Database - RAC/Scalability (MOSC) 17 commentsAnswered
Hi,

we have created a stand alone physical standby database from a 2 node RAC database

On Primary database, the REDO LOGS are located as follows

Member # 1 -- W:\oradata\redo_1a.log
Member # 2 -- X:\oradata\redo_1a.log

On standby database, we wanted the REDO LOGS to be created under 'e:\oradata\ and hence
set the following

log_file_name_convert='w:\oradata','e:\oradata\qaracdr\','x:\oradata\','e:\oradata\qaracdr\'

We completed all the steps and verified that the physical database is up and running
Whe we we query --> select member from v$logfile; it shows

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center