Clone Oracle Database on the same server question..

Dear all,

I tried to clone an Oracle 8i database in the same server ( a HP-UNIX machine)
The target Oracle is in archive mode and

Here what I did:

1. ALTER TABLESPACE XXXX BEGIN BACKUP;
2. Copy the datafiles to the corresponding directory for clone database.
3. ALTER SYSTEM SWITCH LOGFILE;
4. REPEAT Step 1-3 until all tablespaces have been backup.
5. alter system archive log current;
6. Copy all archive log files to corresponding directory for clone database.
7. startup clone database in nomount mode.
8. recreate controlfiles for the clone database. The command is like following : CREATE CONTROLFILE REUSE DATABASE "ORCL" SET DATABASE "CLONE" RESETLOGS ARCHIVELOG ......

All above are all successfully executed.

9. RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;    Here I encounter error :

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/orcl1/data/system01.dbf'

I guess that may cause by the redo log in target database are not completd "flush" to archive log file since the target database is still running.

I don't know if anyone here ACTUALLY CLONE an ORACLE DATABASE in the same machine.

KEN ...
successfully ?? Received on Mon Mar 03 2003 - 12:34:40 CET