Database Backup and Recovery (MOSC)

MOSC Banner

11.2.0.1 Clone to an Oracle 11.2.0.3 database server.

edited Jan 16, 2014 3:18PM in Database Backup and Recovery (MOSC) 14 commentsAnswered
I am wanting to clone a 11.2.0.1 database and move to a 11.2.0.3 database.

I have done the following steps:

On the 11.2.0.1 DB Server:

1. alter database backup controlfile to trace.

2. Copied the file created from step #1 to the new db server /tmp/create_database.sql

3. Shutdown the database

4. Copied all the datafiles to the new db server.

On the 11.2.0.3 DB Server

1. Modified /tmp/create_database.sql to reflect the following:

Changed the 1st line to be :

create controlfile set database <sid> resetlogs

Changed the directory path of the datafiles.

2. Created all the required directories (bdump,cdump,udump)

3. Copied  our "CM" controlfile to $ORACLE_HOME/dbs

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center