Muhammad Nadeem Chaudhry's Blog


Database Cloning

Posted in Uncategorized by Muhammad Nadeem Chaudhry on March 14, 2011
  • First of all I created the file hierarchy for datafiles and logfiles.
  • Created a pfile of Old Database (Test).

CREATE PFILE=’C:\Init{NEW DATABASE}.ORA’ FROM SPFILE;

  • Spool a datafile copy command from directory structure of Old Database to directory structure of New database.
  • Generate trace file for creation of control files.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  • Modify controlfilecreation script.
    • Change REUSE with SET.
    • Remove all lines above ‘Startup mount’.
    • Remove all lines starting with ‘- -‘.
    • Remove RECOVER DATABASE and ALTER SYSTEM ARCHIVE LOG ALL;
    • Save script like C:\CreateDB.SQL.
  • Modified the init{New Database}.ora with the new datafile,logfile, dumpfile flash recovery area destinations and new SID.
  • Shutdown DB immediately.
  • Copy data & redo files to new location. Don’t copy Temp.DBF and .CTL files
  • Create service as:

oradim -NEW -SID NEWNAME -SRVC OracleServiceNEWNAME -STARTMODE manual -PFILE D:\oracle\product\10.2.0\db_1\database\initNEW DATABASE.ora.

  • Register newly created service with LISTENER.
  • Set servive varriable & connect to new database as SQLPLUS /nolog.
  • Startup nomount;

Error: ORA-01081: cannot start already-running ORACLE – shut it down first.

Solution: Shutdown other oracle services.

  • @CreateDB.sql;
  • ALTER DATABASE OPEN RESETLOGS;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: