RMAN cloning script

[hrishy]

Hi Folks

I need to devlop a RMAN cloning strategy.My idea is to do this

1)Create a RMAN backup on the source system say at /oradumps destination

2)scp the backups to the clone host at /oradumps destination

3)startup nomount the clone database

4)rman target sys/hrishy auxiliary sys/hrishy@clonedb

5)

run { 
	allocate auxiliary channel ch1 type 'disk'; 
	duplicate target database to clonedb
	nofilenamecheck; 
	}

now will this work ?

regards
Hrishy

[DaPi]

You need the archlogs as well, these must span the backup process and go up to the time you wish to "synchronise" to.

By default it will try to bring your clone up to date with the source db - having the right archlogs in place can be problematic, so I have:

SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS

before running RMAN, and my first RMAN command is:

set until time '19-MAY-2005 21:55:00';

[hrishy]

Hi Dapi

Thanks for your inputs /Do you have a shell script kind of a thing that prompts a user and then goes on to create the RMAN script dynamically ?

regards
Hrishy

[DaPi]

Oh NO! It's all done with a hammer and chisel in Scottish granite

[hrishy]

Hi Dapi

I was thinking on the lines of the new oracle enterprise managers functinality to clone a database :-).

well dapi will my strategy work ? or do i need to take help of the netbackup guys here ?

regards
Hrishy

[DaPi]

That looks like what I do.

[hrishy]

Hi dapi

I am more concerned about step 2.

2)scp the backups to the clone host at /oradumps destination

now when i start up the clone database instance and set the SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS

and then restore the controlfile

run{ 
      allocate channel c1 type disk; 
      restore controlfile; 
    } 
alter database mount; 

and then run 

run { 
 
     allocate channel c1 type disk; 
     allocate channel c2 type disk; 
     allocate channel c3 type disk; 
restore database 

}

I think i cannot use the duplicate command here or can i ?

regards
Hrishy

[hrishy]

Hi

I also have some confusion about the docs

http://download-west.oracle.com/docs...pdb.htm#442271

where it states that i can just run duplicate command and the database would be clones .The question is how RMAN transfer the backup set to the remote host ?

regards
Hrishy

[DaPi]

If the two machines have the same directory structure - then YOU copy backup files & archlogs to the corresponding place on the "auxiliary" machine and execute RMAN (set until, allocate and duplicate). I'm pretty sure that RMAN duplicate creates the control file for you. All you need to create is a pfile.

(If you do a restore it will have the same db_name.)

[hrishy]

Hi Dapi

I had a look at metalink and came up with this note Note:259767.1

was just wundering what was the intention behind using
RMAN Duplication from tape backup using the Oracle disk API

regards
Hrishy