Database Software

Hello Gurus,

I'm trying to do RMAN backup and restore using Recovery Catalog (without target database).

So I made an environment like this:

So after making the environment, I created the recovery catalog and registered the target database in recovery catalog.

In the destination host, I connected both instance, recovery catalog and auxiliary (destination):

$ rman CATALOG rman/rman@catdb AUXILIARY /

Then I ran the restore script:

RMAN> DUPLICATE DATABASE orcl DBID 14400XXXXX TO orcl SPFILE NOFILENAMECHECK;

The first error was:

Starting Duplicate Db at 23-MAY-16
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=19 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/23/2016 05:11:29
RMAN-05501: aborting duplication of target database
RMAN-05540: no archived logs found in repository for database ORCL

I tried to find the solution, and I found that you need to add NOREDO. So:

RMAN> DUPLICATE DATABASE orcl DBID 14400XXXXX TO orcl SPFILE NOFILENAMECHECK NOREDO;

Second error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/23/2016 05:11:41
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06729: no backup of the SPFILE found to restore

I found the solution again. So you just delete the SPFILE in the script.

RMAN> DUPLICATE DATABASE orcl DBID 14400XXXXX TO orcl NOFILENAMECHECK NOREDO;

Lastly, i cannot find the solution for this error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/23/2016 05:12:17
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

My Question:

1. Why error and how to solve?

2. Do you just create the recovery catalog and register a database inside? No need to backup from target to recovery catalog?

3. Is my restore script right? DUPLICATE DATABASE <target> DBID <target_dbid> TO <destination>?

I am new, so any hints will be really helpful for me. Thanks a lot in advance.

Warm Regards,

Bryan Adams