Errors when clone database in oracle 9i
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.