RMAN - Bank Test - Urgent

[ruibarros]

Environment Information:
* Oracle version: 10g Enterprise Edition
* Operating system: Windows 2008 Server

Personal, in our production bank, Old DBA He left backup from RMAN.
The bank is in Archivelog mode ...

Run {
Allocate Channel T1 Type Disk Format 'D: \ Oracle \ Backup_Fisico \ BCK_FISICO_0_% U.

Incremental backup Level 0
(Database Include Current ControlFile tag 'bkp_cf');

Release Channel T1;
}

This is the command of the script that he mounted to back up.
Until then beauty .. it generates 2 files for me, being a full backup and the other of the controller.
This is not mistaken.
The question is the following .. I need to set up an urgent test bench, and I can not ...
I was giving a read, the staff speaks in set the DBID. Which DBID I have to set, from the production bank
in the test bench, or pick up the bank test in the v $ database and set on it?
Another thing is the name of different banks ... can anyone help me in a step by step?
I'll be very grateful!

Rui Barros

[pauloaleo]

DBID is from the V $ database from the source bank. Do you use RMAN catalog?

or is it only controlling?

[ruibarros]

Friend, if I'm not mistaken I think it's just controlling.
How can I do to identify this?

Thanks.

[pauloaleo]

You trigger RMAN and make a connect

Select all

connect target /

or you trigger RMAN and make two connects

Select all

connect target /

and
2]] That is the bank where it has the RMAN catalog.

???

[pauloaleo]

Another thing, your test bench is in the same machine as the production?

[ruibarros]

In the 1st (Connect Target /)
erred ...

in the 2nd connected beauty in the catalog ..

The machines are distinct. . is one for production and one for testing ..

[pauloaleo]

In the test machine:

Do you have the same structure as the source machine?
You got the profile for the bank you want to generate (Export Oracle_SID)?

[ruibarros]

So ... what would this structure be? Give me what I would have to do? Would not it be easier?
to the raw test bench, I only set up the bench.


I even apologize, but I am kind of lay in the subject, but I am in order to learn.
Thank you for understanding.

[pauloaleo]

Let's assume that machines are Windows.

The source bank has the Datafiles in the directory

Select all

c:\dados\datafiles\

in the test machine you have to have the same directory structure.

If you do not have this structure you need to do an equal, or if there is no way, let's assume, only another disk has space, then you need to have a directory structure there.

understood?

[ruibarros]

I did ... have the same ... !! What is the next step ?

[pauloaleo]

Let's go.

If the test machine is Windows

you type CMD
falls at the prompt
Digital

Select all

export ORACLE_SID=nnnnnnn

It is the name of your new bank, and what should have an initounnnnnn.ora in the directory

Select all

$ORACLE_HOME/dbs

Is there that?

[ruibarros]

I opened the prompt and I typed

Select all

export ORACLE_SID=teste

gave error ...

has yes the init.ora only has in several directory ... I confuse .. .
has in ..

Select all

D:\oracle\product\10.2.0\admin\teste\pfile\ini.ora.912009175014 
D:\oracle\product\10.2.0\db_1\srvm\admin\init.ora

Anyway .. And now?

[ruibarros]

Paul ... ?

[vandclem]

for windows is set oracle_sid = test

[pauloaleo]

Well, the name of your bank will be?

goes on the source server is looking there where the initnnnnnn.ora where xxxx is the name of the bank that is in the air.

take this initnnnnnn.ora, copy to the destination machine in the same principal of origin, rename the same for inityyyy.ora where yyyyy is the name of the bank that you will restore.

Open inityyyyy.ora, look for the name of the bank that is on the source machine and put the name of the bank that you will restore.

must be in parameters, instance_name and db_name.

is right, in Windows is

Select all

set ORACLE_SID=nnnnn

I passed eating to UNIX.

[ruibarros]

Paul,
I had to search for * .ora, brought the init.ora, but it does not have
initbdrod.ora ...

has an init.ora, With a lot of configuration, I believe it is ...
Inclusive has the directories of controlling and tals ...

Is this?

The name of the production bank is bdprod ...
the name of the test bank is test ...

The path of controllingfiles

Select all

d:\oracle\...\NOMEDOBANCO\...

Do I need to change this directory nomedobanco?

[ruibarros]

Complementing .. Within this init.ora ta so ..

Select all

########################################### 
# File Configuration 
########################################### 
control_files=("d:\oracle\oradata\bdprod\control01.ctl", "d:\oracle\oradata\bdprod\control02.ctl", "d:\oracle\oradata\bdprod\control03.ctl") 
db_recovery_file_dest=D:\oracle\product\10.2.0\flash_recovery_area 
db_recovery_file_dest_size=157286400000 
 
########################################### 
# Database Identification 
########################################### 
db_domain=hgu.br 
db_name=bdprod

...

[pauloaleo]

YES. Change the name of the bank for the name of the destination bank, on the machine where you will do the restore, copy this init.ora into this directory and change the bank name to the bank name to restore.