- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: create auxailary oracle Databas 9i
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2004 03:46 AM
тАО01-26-2004 03:46 AM
How to create duplicate database by restore the production database for testing backup is good by data protector 5.1
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2004 09:11 AM
тАО01-26-2004 09:11 AM
SolutionI 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2004 12:55 PM
тАО01-26-2004 12:55 PM
Re: create auxailary oracle Databas 9i
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-26-2004 07:13 PM
тАО01-26-2004 07:13 PM
Re: create auxailary oracle Databas 9i
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2004 12:44 AM
тАО01-27-2004 12:44 AM
Re: create auxailary oracle Databas 9i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2004 03:36 AM
тАО01-27-2004 03:36 AM
Re: create auxailary oracle Databas 9i
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-27-2004 06:47 PM
тАО01-27-2004 06:47 PM
Re: create auxailary oracle Databas 9i
Wouldn't a point-in-time export/import be just as good, and less complex?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2004 04:14 AM
тАО02-05-2004 04:14 AM
Re: create auxailary oracle Databas 9i
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