Database Backup and Recovery (MOSC)

MOSC Banner

RMAN Active Duplicate Question...RMAN-05500 and RMAN-06217

edited May 12, 2016 3:41PM in Database Backup and Recovery (MOSC) 11 commentsAnswered ✓

Hi...I am trying to do an Active Duplicate of a 11.2 Database.  I will detail my efforts below...

Scenario 1 - Aux DB Open

Note:  Source/Target ASM has FRA Disk Group called something other than +FRA

1.  Create the Database with DBCA that will be the Duplicated DB....aka Auxiliary...called DUPTEST

2.  Create a pfile, shutdown, startup on pfile

3.  Edit TNSNames on Target and Aux to connect Target/Aux, Aux/Target

4.  On Aux Host, run RMAN from DB Home

     rman

     connect auxiliary sys/sysdba@DUPTEST;
     CONNECT CATALOG rman@rmandb;

     connect target user@targetdb;

     DUPLICATE TARGET DATABASE TO duptest

     FROM ACTIVE DATABASE

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