- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Setting up a duplicate Oracle 7 database
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
тАО08-07-2003 12:48 AM
тАО08-07-2003 12:48 AM
Setting up a duplicate Oracle 7 database
I need to setup a duplicate oracle instance/database on another server. I'm currently using Oracle7 and HPUX10.20
A physical file copy of the database from the source to the destination server is impossible as the source server runs 24 hours a day. A database export is done daily.
The same version of Oracle7 is already installed on the destination server
This is my rough plan so far..
1) Copied the initSID.ora, tnsnames.ora and listener.ora to the destination server
2) edit /etc/oratab
3) Copied the dump files into a temporary directory in the destination server
My next step will be to recreate the database again using SQL. Is this correct? Or will my dump files automatically recreate the database?
After recreating the database, my next step will be to import the dump files?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:11 AM
тАО08-07-2003 01:11 AM
Re: Setting up a duplicate Oracle 7 database
see this thread :
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x2a7eef70e827d711abdc0090277a778c,00.html
Rgds,
Jean-Luc
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 01:12 AM
тАО08-07-2003 01:12 AM
Re: Setting up a duplicate Oracle 7 database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 05:24 AM
тАО08-07-2003 05:24 AM
Re: Setting up a duplicate Oracle 7 database
A full imp should be imported into a "clean" database. It imports everything -- SYSTEM owned objects and all. It cannot be used to overwrite an existing database with its data.
You should only simply create a minimal database to import fully into.
hope this helps too!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 06:34 PM
тАО08-07-2003 06:34 PM
Re: Setting up a duplicate Oracle 7 database
When you are complete, make sure your source database is completely out of backup mode (check v$backup) and copy all logfiles from the start to the end of the backup period to the secondary server, and roll the database forward. Dont forget to get a backup copy of the controlfile (alter database backup controlfile to 'file' or trace).
If you have questions, please post them back.
Thanks,
brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 06:55 PM
тАО08-07-2003 06:55 PM
Re: Setting up a duplicate Oracle 7 database
The best way is cold backup.
My suggestion is a hotbackup not export/import.
During the import,you need to recreate the datafile and tablespace at least a big as the original database.(I think I done this long-long time ago)
But I still think cold backup is the best way.
anyway this how do I duplicate using coldbackup:
1) copy the data to the new location - without control file.
2) create a file to recreate the control file.see the attachment :
3) everything in place
do svrmgrl> startup nomount
svrmgrl> @rcfDWH6
svrmgrl> alter database open resetlogs;
Now you have the new database with different SID.
Make sure you changes the file rcfDWH6.sql
regards
mB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 09:06 PM
тАО08-07-2003 09:06 PM
Re: Setting up a duplicate Oracle 7 database
From the steps that you have planned, this is what you need to do next.
1. You have already installed Oracle7 on the target server.
2. You have copied the init.ora file on to the target server.
Check that the control file parameter specified in the init.ora file has the same path on the target system and oracle account should have privilage to write to.
Check the udump and bdump paramenets in the init.ora file and see the path on the target server and oracle account should have privilage to write to.
2. You need to create a base database as oracle before you can import into from the export dump files.
Use the attached script as the base DB creation script, Chnage the sid name, system dbf file path and name and redo logs names and path according to your system.
Then execute the following script to create the base tablespaces (ROLLBACK SEGMENT, TEMP, USERS, TOOLS)
3. Then run the following scripts as oracle. This will build you data dictionary
$ORACLE_HOME//rdbms/admin/catalog.sql
$ORACLE_HOME/rdbms/admin/catdbsyn.sql
$ORACLE_HOME/rdbms/admin/catproc.sql
$ORACLE_HOME/sqlplus/admin/pupbld.sql
4. Check the schema (table_owner)and other users in your source database and the default tablespace of these users. Then you have to create these users and assign the default tablespace to them.
5. Now you can import the tables and data from the exprot dump files.
6. You have copied the tnsnames.ora and listener.ora to the destination server. Make sure the host name in the files is reflecting to the target host name.
I hope this helps. I had tested this many times on oracle 7.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-07-2003 09:07 PM
тАО08-07-2003 09:07 PM