- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: how to recreate database and import my data.
Operating System - HP-UX
1777117
Members
3321
Online
109065
Solutions
Forums
Categories
Company
Local Language
юдл
back
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
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- 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-30-2008 09:39 AM
тАО07-30-2008 09:39 AM
Hi Guys,
I am running oracle 10.1.0.2.0 on HPUX 11i. I want to export my data, drop my existing database, recreate the database and import my data. I like to request detailed action steps on how I can achieve it.
Thanks.
Charles.
I am running oracle 10.1.0.2.0 on HPUX 11i. I want to export my data, drop my existing database, recreate the database and import my data. I like to request detailed action steps on how I can achieve it.
Thanks.
Charles.
Solved! Go to Solution.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-30-2008 11:21 AM
тАО07-30-2008 11:21 AM
Re: how to recreate database and import my data.
This is strictly and only an Oracle question and thus probably better asked in an Oracle Forum.
It is also a very generic and common question, so PLEASE look around for earlier answers and then ask for specific details as they might appy to your setup.
"detailed action steps" can be found in the Oracle (online) documentation as well as earlier replies. Search for it, Read it!
You may want to google for (quoted) "control file to trace" besides the obvious : +oracle +recreate +database
Basic method:
- document al steps as you go/learn!
- grab control file definition
- export (all)
- recreate with control file SQL
- apply catalog.sql, pupbld and such
- load yoru data (no index is my preference)
- create your indexes
Good luck!
Hein.
It is also a very generic and common question, so PLEASE look around for earlier answers and then ask for specific details as they might appy to your setup.
"detailed action steps" can be found in the Oracle (online) documentation as well as earlier replies. Search for it, Read it!
You may want to google for (quoted) "control file to trace" besides the obvious : +oracle +recreate +database
Basic method:
- document al steps as you go/learn!
- grab control file definition
- export (all)
- recreate with control file SQL
- apply catalog.sql, pupbld and such
- load yoru data (no index is my preference)
- create your indexes
Good luck!
Hein.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-31-2008 09:54 AM
тАО07-31-2008 09:54 AM
Re: how to recreate database and import my data.
hi,
If you have enough resources, you can as well create another database on the same server and import the data before you actually drop the old database.
Anyway,
1. Create a new database
use the dbca utility
2. Import and export data
Questions: how many custom schemas do you have?
(if you have only a few, it would be much easier to perform the import and export)
revert
kind regards
yogeeraj
If you have enough resources, you can as well create another database on the same server and import the data before you actually drop the old database.
Anyway,
1. Create a new database
use the dbca utility
2. Import and export data
Questions: how many custom schemas do you have?
(if you have only a few, it would be much easier to perform the import and export)
revert
kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-06-2008 04:58 AM
тАО08-06-2008 04:58 AM
Solution
Below is the kinda syntax that I use:-
Oracle database dumping & loading
1. Shut down all instances associated with the database.
2. Start up the database so that it can be accessed only by DBAs as in the following example:
SVRMGR> STARTUP RESTRICT OPEN
3. Perform a full database export (FULL=Y) to backup the entire database.
source .cshrc920
Oracle 9.2.0 Server
ORACLE_HOME = /ora1/app/oracle/product/9.2.0
--------------------------------------------------
setenv ORACLE_SID BTDADMFX
exp system/T843BTDADMFX FULL=y FILE=/home/nick/exp-BTDADMFX.dmp LOG=/home/nick/exp-BTDADMF
X.log
imp system/T843BTDADMFX FULL=y IGNORE=y COMMIT=N FILE=/home/nick/exp-BTDADMFX.dmp
So you need to take a full dump of your database first, then drop it, create the new database and then load up the dump that you took before you dropped the original database
Oracle database dumping & loading
1. Shut down all instances associated with the database.
2. Start up the database so that it can be accessed only by DBAs as in the following example:
SVRMGR> STARTUP RESTRICT OPEN
3. Perform a full database export (FULL=Y) to backup the entire database.
source .cshrc920
Oracle 9.2.0 Server
ORACLE_HOME = /ora1/app/oracle/product/9.2.0
--------------------------------------------------
setenv ORACLE_SID BTDADMFX
exp system/T843BTDADMFX FULL=y FILE=/home/nick/exp-BTDADMFX.dmp LOG=/home/nick/exp-BTDADMF
X.log
imp system/T843BTDADMFX FULL=y IGNORE=y COMMIT=N FILE=/home/nick/exp-BTDADMFX.dmp
So you need to take a full dump of your database first, then drop it, create the new database and then load up the dump that you took before you dropped the original database
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP