RMAN Duplicate Command and Target Database

All posts relating to Oracle database administration.

Moderator: Tim...

RMAN Duplicate Command and Target Database

Postby aditya » Wed Sep 12, 2012 3:25 am

Hi Tim,

We need to create an Auxilary instance on to a different Host from a 10gR2 database using RMAN Duplicate command.

We have a Full Backup and Archive Logs Backup on tapes.

We also have Catalog Database.

Referred Document - Oracle Database Backup and Recovery Advanced User's Guide 10gR2 (B14191-02)

Page 13-2 says - For the duplication to work, you must connect RMAN to both the target (primary) database and an auxiliary instance started in NOMOUNT mode.

Page 13-8 says -

Task 5: Mount or Open the Target Database

Before beginning RMAN duplication, connect SQL*Plus to the target database and
mount or open it if it is not already mounted or open. For example, enter:
-- connect to target database
SQL> CONNECT SYS/oracle@trgt AS SYSDBA;
-- mount or open target database
STARTUP MOUNT;



Recovery catalog for RMAN backup [ID 452529.1] says:

The recovery catalog contains information about RMAN operations, including:

+ Datafile and archived redo log backup sets and backup pieces
+ Datafile copies
+ Archived redo logs and their copies
+ Tablespaces and datafiles on the target database
+ Stored scripts, which are named user-created sequences of RMAN commands
+ Persistent RMAN configuration settings


Can you please explain, even with the catalog database having the target database information, for duplication to work why RMAN must connect to Target database (according to 13-2)
and
Why should the target database be open or mounted (according to 13-8)?


Regards,
Aditya.
aditya
Member
 
Posts: 2
Joined: Wed Sep 12, 2012 3:02 am

Re: RMAN Duplicate Command and Target Database

Postby Tim... » Wed Sep 12, 2012 8:32 am

Hi.

To be completely honest, I'm not sure why this dependency is there. I guess if it is available, it may get used in preference to the catalog, because the catalog is only as fresh as the last refresh, which the target database is by definition always up to date.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: RMAN Duplicate Command and Target Database

Postby aditya » Wed Sep 12, 2012 4:13 pm

Thanks Tim for the response.

Regards,
Aditya.
aditya
Member
 
Posts: 2
Joined: Wed Sep 12, 2012 3:02 am

Re: RMAN Duplicate Command and Target Database

Postby Tim... » Wed Sep 12, 2012 4:43 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 6 guests

cron