• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2496
  • Last Modified:

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

0
geodin
Asked:
geodin
  • 3
  • 3
3 Solutions
 
geodinAuthor Commented:
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
0
 
schwertnerCommented:
Before doing the import you have to switch to the desired incarnation.
RMAN provides both Incarnation List and Switch commands.
0
 
geodinAuthor Commented:
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
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
schwertnerCommented:
1.      The previous (the first) restore if done with catalog creates a new incarnation in the catalog. This incarnation is CURRENT. So you have to switch to the old incarnation:

RMAN>reset database to incarnation 2;

2.      Restore the control file. Use the normal instruction to do this i.e. with catalog. May be the same good result can be reached without catalog.
3.      When beginning to restore the data files if we use the catalog we run in Oracle error: ORA&. File header not valid &.   To work around turn off RMAN and invoke it again but without catalog we succeeded  to finish the job successfully.


Also post the exactly error messages here!
0
 
geodinAuthor Commented:
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
0
 
schwertnerCommented:
using target database control file instead of recovery catalog

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

I think you have to use   catalog Data base not the Control File as repository of the Backups.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now