Database Administration (MOSC)

MOSC Banner

issues during data guard setup

edited Aug 29, 2014 5:02AM in Database Administration (MOSC) 1 commentAnswered

Hello,

for a test dataguard set up I have done below steps:

took database backup of primary rac database alfresut running on dev-oragrdi-ux01 and dev-oragrid-ux02

Copied backup to dev-oragrid-ux02 and changed db_unique_name to alfresut_dr and did configuration change on log_file_name_convert and log_archive_dest 1 and 2 and other configs

on bringing up alfresut_dr in mount stage below is location of redo logfiles

SQL> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

/oradata/database/alfresut/redo03.log

/oradata/database/alfresut/redo02.log

/oradata/database/alfresut/redo01.log

/oradata/database/alfresut/redo04.log

/oradata/database/alfresut/redo05.log

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