Re: Clone Oracle Database on the same server question..

KENNY L. CHEN wrote:
> 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 ??

FAQ - search archives/google.
PS - don't forget to take the tablespaces out of backup mode on your source db.

-- 
Regards, Frank van Bortel