[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 501
  • Last Modified:

How do I connect RMAN to the TARGET backup file set so I can proceed to DUPLICATE to my AUXILIARY database?

I am trying to DUPLICATE a database for a online/hot backup set.  The DUPLICATE will be on a different host than the TARGET.  I have the Backup files and the Auxiliary instance is all set - I'm stuck on how to connect RMAN to the Target backup set so it can duplicate to the Auxiliary instance.  I don't want to have to connect to the TARGET host - just want to use the backup file set from there.  I can get the control, init param, pwd, listener, tnsnames - whatever from the Target - I just don't want to connect to the host - only the backup file set.  Thanks.
0
pt_wood
Asked:
pt_wood
  • 3
  • 2
  • 2
  • +1
2 Solutions
 
pt_woodAuthor Commented:
edit: "I am trying to DUPLICATE a database FROM an online/hot backup FILE set."  sorry.
0
 
mcmonapCommented:
Hi pt_wood,

Is this an issue within an oracle setup?
0
 
shuminzhouCommented:
Restore the db to the new server as you would in a disaster situation. The db will have same DBId and DBNAME as you production.
The procedure will be something like this (please note, I tested this on version 10G):
RMAN> set DBID <you db id>; --Get this from your source db.
RMAN>startup nomount;
RMAN>restore controlfile from '.....'; --Your backup control file
RMAN>mount database;
RMAN>restore database;
RMAN>recover database;
RMAN>alter database open resetlogs;

Follow the instruction on Oracle doc if you want to restore file to different location using the SET NEWNAME FOR DATAFILE commands.

Once it is restored and recovered, you can then use DBNEWID Utility to change the DBID and DBNAME if you wish to.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
anand_2000vCommented:
if you are not using 10g, then set up the oracle service(sid) in the new machine. connect to the repository(I hope u r using one). make sure that the backup taken on the original machine and the archivelogs are available in the correct directory in the new machine also.
here the commands
RMAN>startup nomount;
RMAN>restore controlfile from '.....'; --Your backup control file
RMAN>mount database;
RMAN>restore database;
RMAN>recover database;
RMAN>alter database open;
will work. you might have to recover the latest logfiles manually/or open the db with resetlogs.
0
 
pt_woodAuthor Commented:
shuminzhou & anand_2000v - thank you for your comments.

So based on both of your recommendations - I should use RESTORE rather than DUPLICATE - correct?

I failed to specify that we are NOT using CATALOGING.  I do have an Oracle Management Server (OMS) setup with a standalone database OEMREP as the repository on the machine where I want to duplicate the Auxiliary instance to.  (That is required to run AUTOARCHIVE mode.)

anand_2000v - so where you write "...connect to the repository..."  - may I presume that would be my OEMREP database?

Please advise - Thank you!
0
 
pt_woodAuthor Commented:
NOTE - The TARGET machine (source of the backup to be restored - is running in AUTOARCHIVE mode and presumably has repository - but I don't have access to that - just the multiplexed backup of database and control files - I can get archive logs too - if necessary.  
-p
0
 
shuminzhouCommented:
You don't need to use catalog or OEM repository. Put the backup sets to a place your new server can see.

With the following command, it should point to a control file in your backup directory. After that, it should know about your backed up archived logs.
RMAN>restore controlfile from '............'; --Your backup control file

Why don't you give it a go and see what happens.
0
 
anand_2000vCommented:
i meant the catalog...but as shuminzhou says. why don't u give his solution a try? i should solve ur problem
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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