- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- how to copy 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
тАО07-31-2007 09:53 PM
тАО07-31-2007 09:53 PM
how to copy database
Thank you,
Ramana.Sv
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2007 12:02 AM
тАО08-01-2007 12:02 AM
Re: how to copy database
Each has some tools to export/import the data out/in.
You can transfer the exported data from one server to another.
But there are many different db's and tools ...
Hope this helps!
Regards
Torsten.
__________________________________________________
There are only 10 types of people in the world -
those who understand binary, and those who don't.
__________________________________________________
No support by private messages. Please ask the forum!
If you feel this was helpful please click the KUDOS! thumb below!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2007 12:25 AM
тАО08-01-2007 12:25 AM
Re: how to copy database
I assume you have an Oracle RDBMS. The easiest way is to first create a plaintext export of your control files (ALTER DATABASE BACKUP CONTROLFILE TO TRACE AS '...'). Then shutdown the database and copy the generated script, configuration files, and datafiles using your preferred method (e.g. NFS, CIFS, NFS, tape). Arrange the datafiles as you see fit, and modify the script to reflect their new locations. Create necessary directory structures and place configuration files appropriately. Then make additional changes to the script as outlined here:
http://www.dba-oracle.com/oracle_tips_db_copy.htm
Don't forget to modify your init.ora file, if you also brought this over. The beauty of doing a cold backup is your database is consistent, so there are no archivelogs to apply after you do a startup.
PCS
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2007 12:38 AM
тАО08-01-2007 12:38 AM
Re: how to copy database
Method 1.
Shutdown the database and copy the files from server A to server B. Startup database on Server A and startup database on B. Assumptions, the filesystems are identical and the installation of the Oracle Software is the same.
Method 2.
Export the database using the EXP or EXPDP utility on server A and import in a clean database on server B.
if you need further assistance, please let us know
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2007 02:38 AM
тАО08-01-2007 02:38 AM