Database Administration (MOSC)

MOSC Banner

convert log file parameter for clonning

edited Feb 21, 2024 9:49AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

DB 19c , On AIX

I want to duplicate Prod to DEV using RMAN.

Production database has 6 log file but DEV has 3.

How should I set log_file_convert parameter in DEV initdev.ora file?

==============DEV=======================

SQL> select member from v$logfile;

/v/sgbd/dv/cdb/cd/redo03.log

/v/sgbd/dv/cdb/cd/redo02.log

/v/sgbd/dv/cdb/cd/redo01.log

==============PRoD=======================

SQL> select member from v$logfile;

MEMBER

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

/PROD/sgbd/proddb/diskredo02/cdb/prodcdb/redo03a.rdo

/PROD/sgbd/proddb/diskredo03/cdb/prodcdb/redo03b.rdo

/PROD/sgbd/proddb/diskredo01/cdb/prodcdb/redo02a.rdo

/PROD/sgbd/proddb/diskredo03/cdb/prodcdb/redo02b.rdo

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