Home » RDBMS Server » Server Administration » how to clone oracle10g database
how to clone oracle10g database [message #252311] Wed, 18 July 2007 10:17 Go to next message
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 #252312 is a reply to message #252311] Wed, 18 July 2007 10:24 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
My advice is to do the process at least twice for practice before attempting to do it for real & DOCUMENT every action.
Re: how to clone oracle10g database [message #252364 is a reply to message #252312] Wed, 18 July 2007 12:52 Go to previous messageGo to next message
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 #252492 is a reply to message #252311] Thu, 19 July 2007 00:53 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Many ways .

1. DBCA Template.
2. RMAN DUPLICATE
3. DATA PUMP EXPORT/IMPORT
4. COLD BACKUP and copy these datafiles into new database
Re: how to clone oracle10g database [message #252493 is a reply to message #252311] Thu, 19 July 2007 00:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Arju,
OK plz demostrate 1 each you advise.
Re: how to clone oracle10g database [message #252509 is a reply to message #252311] Thu, 19 July 2007 01:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Dream already said about no 1.
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.


About 2.

1.create oralce password file for auxiliary instance
2.create initialization parameter file for auxiliary instance
3.then start auxiliary instace
4. then mount / open the target database
5. allocate auxiliary channels.
6.Duplicate target database
Re: how to clone oracle10g database [message #252669 is a reply to message #252509] Thu, 19 July 2007 10:46 Go to previous messageGo to next message
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.
Re: how to clone oracle10g database [message #253051 is a reply to message #252669] Sun, 22 July 2007 00:10 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

[quote title=DreamzZ wrote on Thu, 19 July 2007 21:46]
Quote:

Step# 6: Pre create database with same tablespaces and users.




No need to Pre- create user. Import will automatically create user.
If the user already exist then oracle will generate,



ORA-31684: Object type USER:"PROD" already exists
Re: how to clone oracle10g database [message #253085 is a reply to message #253051] Sun, 22 July 2007 04:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
USE
IGNORE=YES
Re: how to clone oracle10g database [message #253086 is a reply to message #252311] Sun, 22 July 2007 04:19 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Dream are you answering while sleeping? I don't see you on during this time!!! Cool Cool Cool
Previous Topic: Failed to create standby database, how do I resovle it?
Next Topic: Auto Extension of Tablespaces
Goto Forum:
  


Current Time: Thu Dec 08 16:14:19 CST 2016

Total time taken to generate the page: 0.10483 seconds