create auxailary oracle Databas 9i

[Asif_8]

Hi !

How to create duplicate database by restore the production database for testing backup is good by data protector 5.1

[Brian Crabtree · Accepted solution]

Asif,

I would recommending downloading the Rman documentation from technet.oracle.com. The following are links to it:

8i:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990.pdf

A quick run down would be (from inside rman)

connect target user/pass@TGTDB
connect auxilary user/pass@SRCDB
connect rcvcat user/pass@RCATDB
run {
allocate channel t1 type 'sbt_tape';
allocate channel t2 type 'sbt_tape';
allocate channel t3 type 'sbt_tape';
duplicate database;
}

That will most likely not work, but not knowing your situation and what you want, that should give you the idea. I would recommend reading through the documentation on rman if you are going to use DP.

Thanks,

Brian

[Sanjiv Sharma_1]

Hi Asif,

This link will get you started:
http://openview.hp.com/sso/ecare/getsupportdoc?docid=KBRC00003519

It is for Oracle 8 with OB-II.

Hope this help.

Thanks,

[Bart Paulusse]

What I usually do is make a filesystem backup of the shutdown production database,
restore this database to a new location/server (filesystem restore is very straightforward/easy to perform) and then rename the database.

I've done this successfully for Oracle 8 and 9 databases.

[Jakes Louw]

Have a look at the new replication functionality using RAC. Using RMAN could be a pain in the behind.

[SteveKirby]

What you are looking for is a clone script. You are looking to take the data from production and then use that to create a 'copy' for testing and/or development.

The basic steps are:

1. Create your backup
2. Create a trace of the controlfile
3. Move/Recover the backup datafiles to the new location
4. Edit the create controlfile script with new locations and name
5. Run the create controlfile script
6. Recover the database using archive logs
7. Open the database reset logs

Steve

[Jakes Louw]

Steve

Wouldn't a point-in-time export/import be just as good, and less complex?

[Volker Borowski]

Hi,

I did copys like Steve described very often.
It is by far one of the fastest and easiest methods.

Single Pitfall: The new database keeps it's uniqe id, even if you change the SID.
So if you do backups with RMAN of the original and the copy to the same catalog DB, you will get trouble.
You need to copy (reincarnate) the DB with RMAN in this case.

Hope this helps
Volker