Ref:( Refreshing Dev with RMAN Cold Backup)

[atkinson]

Hi,

Could some guide me how to refresh development database with production database cold backup which was done by RMAN.

I have done following things,

I have used the following script to take the cold backup of production database.

run { allocate channel c1 type disk format '/backup/u00/oracle/prod/df_%d_%p_%c'; backup (database); sql 'alter database open'; release channel c1; }

Developemnt database has the same directory structure as production except init.ora parameters.

It would be help full if some one give me the script or steps.


Cheers,

[atkinson]

Can any one reply to above queries please.

Thanks,

[pando]

no, spammer

[adewri]

Originally posted by atkinson
Can any one reply to above queries please.

Thanks,

If you have heard the concept of auxiliary databases then read this...

http://metalink.oracle.com/metalink/...T&p_id=73912.1

Else RTFM...