Database Administration (MOSC)

MOSC Banner

Errors when clone database in oracle 9i

edited Aug 30, 2012 11:33PM in Database Administration (MOSC) 3 commentsAnswered ✓
Hi all,

   I meet a problem when clone database between two server (both of them use Linux 32 bit and Oracle 9.2.0.4 32 bit).

   Because of this is a test environment, so I cloning such as:

     1. At the database A, I use alter database backup controlfile to trace as '/tmp/ctl.sql'; to backup control file.

     2. Shutdown database A and B.

    3. Copy datafiles (include temp, redo log file)  and control file (created at step 1) from A to B.

    4. Edit controlfile just created at step 1 correct to database B (path of datafiles, controlfiles, ..).

    5. Startup nomount database B, and create control file that just edited at step 4.

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