New Instance Name with Different (RMAN)

[elidias7]

Environment information:
* Oracle version: 10g
* Operating system: Linux

Good morning.

Someone would know how to inform or pass some documentation of how I can carry out the following task.

I have an instance in production and it is backed up RMAN, I would like to get this backup of RMAN and restore the Datafiles in another instance that is on another server and with the different name.
Is it possible to carry out this process of restoring the Datafiles and your data in a totally different instance?

Hugs,

[Andre-PE]

Good morning,

First, let us know how this structure of your backup model!
Is it in "Noarchivelog" or "Archivelog" mode?

[] 's

[elidias7]

Good morning André.

This in Archive mode and RMAN is working without catalog.

Hugs

[Andre-PE]

OK, you must perform a backup of ControlFile to then restore it.

Next:
Connect to RMAN and make sure you already have a BKP of ControlFile:

Select all

[oracle@localhost oracle]$ rman 
 
Recovery Manager: Release 10.1.0.5.0 - Production 
 
Copyright (c) 1995, 2004, Oracle.  All rights reserved. 
 
RMAN> connect target / 
 
connected to target database: ORCL (DBID=1106549991) 
 
RMAN> list backup controlfile;

If you are already Great, if not, do it:

Select all

RMAN> run { 
2> allocate channel t1 type disk format '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/\BKP_CF_%d_%t_%s.rman'; 
3> backup current controlfile tag 'BKP_CF'; 
4> release channel t1; 
5> }

In case, you must by the destination where you usually insert your backups from RMAN or in a location where you The other server can access ok? After this, make sure a ".rman" was generated in the directory that you specified in Allocate.

Ok, done this, you should go on the new server, I suppose the same is pre-installed and also that you are using the OFA structure, connect in the RMAN and run the following command:
Ps: If the instance is initialized OK! If you do not start the same:

Select all

RMAN> startup nomount; 
 
instância Oracle iniciada 
 
RMAN> restore controlfile from ' /u01/app/oracle/oradata/orcl/BKP_CF_ORCL_663427972_18.RMAN';

After restoring:

Select all

RMAN> alter database mount; 
 
banco de dados montado 
canal liberado: ORA_DISK_1 
 
RMAN> alter database open resetlogs; 
banco de dados aberto.

Post the result OK?
And any doubt, put there!

[] 's

[Andre-PE]

Good afternoon,
friend, just correcting a mistake I made without a precise in the second line of the command to generate the controlling:

wrong:

Select all

2> allocate channel t1 type disk format '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/\BKP_CF_%d_%t_%s.rman';

right:

Select all

2> allocate channel t1 type disk format '/u01/app/oracle/flash_recovery_area/ORCL/autobackup/BKP_CF_%d_%t_%s.rman';

OK?

[] 's

[elidias7]

Good morning André.

This procedure you passed will make the right controlling restore, if the instance has another name I will have trouble performing what I need.

I tried a few things around here and I could not, anyway thanks for the attention.

Hugs,

[Andre-PE]

Good morning Eli,
Have you ever managed to solve or will you give up? With a little more persistence we can;)

There are some information that you can provide so we can solve your problem, such as the OS and version of the BD of the other server What do you want to restore Datafiles?

[] 's

[Andre-PE]

If opposite,
was a pleasure to try to help!

[] 's

[elidias7]

Andre speaks

in fact it's only the tablespace that I would like to restore André, in fact this is my curiosity, but from what you helped and for what I'vê been testing I can not do it directly in instance with A different name, because I will need to load the controllingfiles.

The less complicated form is to create an instance with the same name, restore this Tablespace / Datafile and export your data to later matter it in instance that has another name.

I am still researching this but nothing desperation.

Hugs,

[Andre-PE]

Was this tip that would tell you, create an instance with the same name and make the backup full, but as I like adventure did not want to pronounce me and I was checking a way to do the way you were trying not to impossible, A little more work and configuration!

Ok, good luck in your searches

[] 's

[elidias7]

It cost!

Thanks for the attention Anything you need and I can help We are there

Hugs

[mpvargas]

Dear friends,
I'm going through the same situation.
I would like to know if you can restore a RMAN backup on another server in an instance with a different name.
Thanks.

[gilbertoca]

Dear friends,
I'm going through the same situation.
I would like to know if you can restore a RMAN backup on another server in an instance with a different name.
Thank you.

This post http://www.jroller.com/gilbertoca/entry ... nco_oracle can help a little.
But see, you need to consider binary compatibility. Another thing, the processed procedure is to duplicate on the same server, then adjust it so that after the transfer of the backups, the RMAN utility think that you are working locally.

Gilberto

[alexandre_costa]

Friends,

I took a look at the link that Gilberto passed, I already created another bank using the Dump (Export and Import of the Schemas). Now a curiosity came, is it possible through RMAN to create a new bank (test for example, from a production bank) and apply the archiviogs of the production bank in this test bank?

Ex:

I create a test bench (Noarchivelog), and every day I update it with the archivelogs of production.


Hugs,

[gilbertoca]

This idea is essentially the concept of Data-Guard, or Standby database. See [url=http://download.oracle.com/docs/cd/B193 ... m#CIHCIBAB]aqui Lguns scenarios, more specifically Section 12.7.

Gilberto

[alexandre_costa]

Speak Gilberto,

Thanks for the link you sent, that's exactly what I want.

Hugs!