From: kenny_60559@yahoo.com (KENNY L. CHEN)
Newsgroups: comp.databases.oracle
Subject: Clone Oracle Database on the same server question..
Date: 3 Mar 2003 03:34:40 -0800
Organization: http://groups.google.com/
Lines: 43
Message-ID: <83f59352.0303030334.184e4665@posting.google.com>
NNTP-Posting-Host: 211.79.0.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1046691280 7936 127.0.0.1 (3 Mar 2003 11:34:40 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 3 Mar 2003 11:34:40 GMT


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 ??