asked on

duplicate database from previous incarnation

Need to duplicate to a qa database, on seperate host, from prod but need the qa database to be duplicated from the previous incarnation of prod.

Need help figuring out the rman command.

db version is 10.2.0.3.0.

##current rman script
 
run
{
  allocate auxiliary channel aux0 type disk;
  set until SCN 3230385720815;
  duplicate target database to MRPQA;
}

Open in new window

geodin

ASKER

I've found the below metalink article, would need to do Workaround 2 as prod cannot be shutdown.

Has anyone followed this doc and has feedback or can elaborate on any issues that came up?

Link:
https://metalink2.oracle.com/metalink/plsql/f?p=130:14:8604963167937124760::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,293717.1,1,1,1,helvetica

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geodin

ASKER

Thanks,

I have reset the incarnation key and tried running recovery but get error about ambiguous database name which kinda makes sense to me since the document has me connecting to rman from the test server as if the target were the same name as prod.

Any ideas how I get around this?

Thanks,
Geodin

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

geodin

ASKER

Thanks but now I am to the point were I am trying to catalog the backup pieces I moved over from prod on the test server/host and it is failing, I will post the command and message below. I canceled the action as it hung for some time:

RMAN> restore controlfile from '/tmp/autobackup_mrpprod.bak.2';

Starting restore at 29-APR-09
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=432 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
output filename=+FAR/mrpprod/controlfile/current.326.685468029
Finished restore at 29-APR-09

RMAN> catalog start with '/data01/oracle/rman_bkup/mrpprod1';

released channel: ORA_DISK_1
Starting implicit crosscheck backup at 29-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=432 devtype=DISK
Crosschecked 960 objects
Finished implicit crosscheck backup at 29-APR-09

Starting implicit crosscheck copy at 29-APR-09
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-APR-09

searching for all files in the recovery area
cataloging files...
no files cataloged

searching for all files that match the pattern /data01/oracle/rman_bkup/mrpprod1

List of Files Unknown to the Database
=====================================
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_24/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_27/rman_21_51.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_27/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_25/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_26/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_04_23/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_13/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_14/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_15/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_16/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_17/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_18/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_27/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_28/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_26/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_25/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_24/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_23/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_22/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_21/rman_22_30.log
File Name: /data01/oracle/rman_bkup/mrpprod1/09_03_20/rman_22_30.log

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
*** glibc detected *** double free or corruption (!prev): 0x0000000006675610 ***

user interrupt received

SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial