Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

create auxailary oracle Databas 9i

SOLVED
Go to solution
Asif_8
Regular Advisor

create auxailary oracle Databas 9i

Hi !

How to create duplicate database by restore the production database for testing backup is good by data protector 5.1
7 REPLIES
Brian Crabtree
Honored Contributor
Solution

Re: create auxailary oracle Databas 9i

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
Honored Contributor

Re: create auxailary oracle Databas 9i

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,
Everything is possible
Bart Paulusse
Respected Contributor

Re: create auxailary oracle Databas 9i

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
Trusted Contributor

Re: create auxailary oracle Databas 9i

Have a look at the new replication functionality using RAC. Using RMAN could be a pain in the behind.
Trying is the first step to failure - Homer Simpson
SteveKirby
Frequent Advisor

Re: create auxailary oracle Databas 9i

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
Trusted Contributor

Re: create auxailary oracle Databas 9i

Steve

Wouldn't a point-in-time export/import be just as good, and less complex?
Trying is the first step to failure - Homer Simpson
Volker Borowski
Honored Contributor

Re: create auxailary oracle Databas 9i

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