| how to clone oracle10g database [message #252311] |
Wed, 18 July 2007 10:17  |
pra_dbaquery
Messages: 6
Registered: June 2007
Location: Jamnagar
|
Junior Member |
|
|
I have one query.
We have one production database server with following details.
1. OS -> Windows Server 2003 Enterprise Edition
2. Database -> Oracle10g.
3. Existing Drive Info
- c:\
- d:\
- e:\
4. Database installation Details:-
4.1 Oracle_sid = lir1
4.2 Path :- E:\oracle\product\10.1.0\Db_1
Now requirement is I have to create new Oracle10g database on new fresh server and bring up the database with this old ( as like above setup) server.
Query :-
1. Is it necessary to install oracle db 10g on new server with same folder architecture like in E:\ Drive.
means can we install on another drive and bring up the database ?
As per my view I have designed steps like below. kindly modify if anything wrong.
- Database Clone Steps:
1. Cold backup is ready as taking daily.
2. New server with proper space.
3. Install Oracle 10g with same instance name and folder architecture on new server
4. Shutdown the instance after complete install
5. Restore the cold backup of old server
6. Bring up the database
7. Check the data availability from application side
8. On new server database is ready for use
|
|
|
|
|
|
| Re: how to clone oracle10g database [message #252364 is a reply to message #252312] |
Wed, 18 July 2007 12:52  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | Cloning Databases Using DBCA
The "Template Management" section of the Database Configuration Assistant (DBCA) can be used to clone databases. The following method creates a clone of and existing database including both the structure and the data:
* Start the Database Configuration Assistant (DBCA).
* On the "Welcome" screen click the "Next" button.
* On the "Operations" screen select the "Manage Templates" option and click the "Next" button.
* On the "Template Management" screen select the "Create a database template" option and select the "From and existing database (structure as well as data)" sub-option then click the "Next" button.
* On the "Source database" screen select the relevant database instance and click the "Next" button.
* On the "Template properties" screen enter a suitable name and description for the template, confirm the location for the template files and click the "Next" button.
* On the "Location of database related files" screen choose either to maintain the file locations or to convert to OFA structure (recommended) and click the "Finish" button.
* On the "Confirmation" screen click the "OK" button.
* Wait while the Database Configuration Assistant progress screen gathers information about the source database, backs up the database and creates the template.
By default the template files are located in the "$ORACLE_HOME/assistants/dbca/templates" directory.
|
http://www.oracle-base.com/articles/10g/ServerConfiguration10g.php#dbca_clone_database
[Updated on: Wed, 18 July 2007 12:52] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: how to clone oracle10g database [message #252669 is a reply to message #252509] |
Thu, 19 July 2007 10:46 |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | I am saying about number 3,
1. Create a directory in the database in which you want to export data by data pump.
2. grant read , write permission to that directory to a particular user by which u r performing data pump export opertaion
3. Run the expdp command
4. after sueessfully exported copy this dump files to the new host.
5. again create directory where this export file reside and grant permision to a user who will import it.
6. Run impdp operation.
|
Step# 6: Pre create database with same tablespaces and users.
Step# 7:6. Run impdp operation.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
