17 | 10 | 2017
Latest Articles
Popular Articles

RMAN

Clone active database with RMAN

User Rating:  / 1
PoorBest 

Clone Active Database ( without taking a backup prior to the operation )

 

From the very beginning in database information technology people sometimes want a copy of a database for various reasons I don' t mention here.

The procedure used to be :

1. make a backup of the target database

2. move the backupsets to the "clone" database server

3. restore the backup on the "clone" database server

Depending on the release you use you could use RMAN the duplicate target database syntax to make it more easy

Oracle 11G comes with the possibility to clone a target database on another server or on the same server WITHOUT the need to make any kind of backup of the target database prior to the clone operation.

If you ask me, this is a nice feature. In the below example I clone a database CAIT11 to a database PLATINUM. Step by step.

 

STEP 1 : Create a text parameter file

 

C:\Users\Guy>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Dec 23 18:56:56 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create pfile from spfile;

File created.


STEP 2 : Create the Windows Service for the new SID

 

C:\Windows\system32>ORADIM -NEW -SID PLATINUM

Instance created.

De Oracle PLATINUM VSS Writer Service-service wordt gestart.
De Oracle PLATINUM VSS Writer Service-service is gestart.


STEP 3 : Create a password file for the new instance.

 

My colleague Priyanka Kohli who was using this procedure for her first duplicate active database excersise found out that during the cloning process the sys password for both target and auxiliary database should be the same. One can consider to copy the passwordfile from source to destination.

C:\Windows\system32>orapwd file=%ORACLE_HOME%\database\orapwPLATINUM password=palladium entries=5

 

STEP 4 : Adjust the parameter file ( init file )

 

Keep the below listed parameters.

If you do not use OMF — Oracle Managed Files --- and if you want to clone your database on the same server you may want to add the initialization parameters db_file_name_convert and log_file_name_convert

 

*.db_name='PLATINUM'

*.db_unique_name='PLATINUM'

*.compatible=11.1.0.0.0

*.db_create_file_dest='C:\oracle\product\11.1.0\oradata'

*.db_recovery_file_dest='C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA'

*.db_recovery_file_dest_size=10G

 

 STEP 5 : Startup NOMOUNT the new database instance

 

C:\Windows\system32>SET ORACLE_SID=PLATINUM

C:\Windows\system32>sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Dec 23 19:08:42 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

SQL> startup nomount;

ORACLE instance started.

Total System Global Area  150667264 bytes

Fixed Size                  1331740 bytes
Variable Size              92278244 bytes
Database Buffers           50331648 bytes
Redo Buffers                6725632 bytes

 

STEP 6 : Edit the listener.ora in use and add a STATIC ENTRY for the new database instance. 

 

SID_LIST_LISTENER =

(SID_LIST = 
  (SID_DESC =
    (SID_NAME = CAIT11)
    (ORACLE_HOME = C:\ORACLE\PRODUCT\11.1.0\db_1)  
  )
  (SID_DESC =
    (SID_NAME = PLATINUM)
    (ORACLE_HOME = C:\ORACLE\PRODUCT\11.1.0\db_1)
    (GLOBAL_DBNAME = PLATINUM)
  )
  (SID_DESC =
    (SID_NAME = CAITLANN)
    (ORACLE_HOME = C:\ORACLE\PRODUCT\10.2.0\db_1)
  )
)

 

STEP 7 : Test whether you can access the database instance.

 

C:\Users\Guy>sqlplus "sys/This email address is being protected from spambots. You need JavaScript enabled to view it. .2.3:1521/PLATINUM as sysdba"

 

STEP 8 : Launch RMAN

 

C:\Users\Guy>rman

Recovery Manager: Release 11.1.0.6.0 - Production on Tue Dec 23 19:34:59 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

RMAN> connect target sys/This email address is being protected from spambots. You need JavaScript enabled to view it. .2.3:1521/CAIT11

connected to target database: CAIT11 (DBID=3818981531)

RMAN> connect auxiliary sys/This email address is being protected from spambots. You need JavaScript enabled to view it. .2.3:1521/PLATINUM

connected to auxiliary database: PLATINUM (not mounted) 

RMAN> duplicate target database to platinum from active database;

Starting Duplicate Db at 23-DEC-08

using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
contents of Memory Script:{
set newname for datafile  1 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSTEM_4BOM38YJ_.DBF";
set newname for datafile  2 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_4BOM391C_.DBF";
set newname for datafile  3 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_4BOM394F_.DBF";
set newname for datafile  4 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_4BOM395W_.DBF";
set newname for datafile  5 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_4LXKXGV1_.DBF";
set newname for datafile  6 to
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_4LXKY645_.DBF";
backup as copy reuse
datafile  1 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSTEM_4BOM38YJ_.DBF"
datafile  2 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_4BOM391C_.DBF"
datafile 3 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_4BOM394F_.DBF"
datafile 4 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_4BOM395W_.DBF"
datafile 5 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_4LXKXGV1_.DBF"  
datafile 6 auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_4LXKY645_.DBF"   ;
sql 'alter system archive log current';
}
executing Memory Script
 executing command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting backup at 23-DEC-08allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=120 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DATAFILE\O1_MF_SYSTEM_4BOM38YJ_.DBF
channel ORA_DISK_2: starting datafile copy
input datafile file number=00002 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DATAFILE\O1_MF_SYSAUX_4BOM391C_.DBF
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSTEM_DATA_D-CAIT11_I-3818981531_TS-SYSTEM_FNO-1_0LK30K1Q_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:03:19
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DA
TAFILE\O1_MF_UNDOTBS1_4BOM394F_.DBF
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_DATA_D-CAIT11_I-3818981531_TS-SYSAUX_FNO-2_0MK30K1T_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:03:20
channel ORA_DISK_2: starting datafile copy
input datafile file number=00005 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DATAFILE\O1_MF_USERS_AR_4LXKXGV1_.DBF
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_01_FNO-5_0OK30K89_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:46
channel ORA_DISK_2: starting datafile copy
input datafile file number=00006 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DATAFILE\O1_MF_USERS_AR_4LXKY645_.DBF
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_DATA_D-CAIT11_I-3818981531_TS-UNDOTBS1_FNO-3_0NK30K84_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:57
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\CAIT11\DATAFILE\O1_MF_USERS_4BOM395W_.DBF
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_DATA_D-CAIT11_I-3818981531_TS-USERS_FNO-4_0QK30KA1_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
output file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_02_FNO-6_0PK30K9S_.DBF tag=TAG20081223T210145 RECID=0 STAMP=0
channel ORA_DISK_2: datafile copy complete, elapsed time: 00:00:32
Finished backup at 23-DEC-08
sql statement: alter system archive log currentsql statement: CREATE CONTROLFILE REUSE SET DATABASE "PLATINUM" RESETLOGS ARCHIVELOG
MAXLOGFILES     16
MAXLOGMEMBERS      3
MAXDATAFILES      100
MAXINSTANCES     8
MAXLOGHISTORY      292
LOGFILE
GROUP  1  SIZE 50 M ,
GROUP  2  SIZE 50 M ,
GROUP  3  SIZE 50 M
DATAFILE
'C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSTEM_DATA_D-CAIT11_I-3818981531_TS-SYSTEM_FNO-1_0LK30K1Q_.DBF'
CHARACTER SET AL32UTF8
 contents of Memory Script:
{
backup as copy reuse
archivelog like  "C:\ORACLE\PRODUCT\11.1.0\DB_1\RDBMS\ARC00036_0663176286.001" auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_%U_.ARC"   archivelog like
"C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\CAIT11\ARCHIVELOG\2008_12_23\O1_MF_1_36_4O2K6M9Y_.ARC" auxiliary format
"C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_%U_.ARC"   ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script
Starting backup at 23-DEC-08using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=36 RECID=65 STAMP=674255209
channel ORA_DISK_2: starting archived log copy
input archived log thread=1 sequence=36 RECID=66 STAMP=674255209
output file name=C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0RK30KBG_.ARC RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07
output file name=C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0SK30KBM_.ARC RECID=0 STAMP=0
channel ORA_DISK_2: archived log copy complete, elapsed time: 00:00:07
Finished backup at 23-DEC-08
searching for all files in the recovery areaList of Files Unknown to the Database=====================================
File Name: C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0RK30KBG_.ARC
File Name: C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0SK30KBM_.ARCcataloging files...cataloging doneList of Cataloged Files=======================
File Name: C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0RK30KBG_.ARC
File Name: C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0SK30KBM_.ARCdatafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=674255237 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_DATA_D-CAIT11_I-3818981531_TS-SYSAUX_FNO-2_0MK30K1T_.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=674255237 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_DATA_D-CAIT11_I-3818981531_TS-UNDOTBS1_FNO-3_0NK30K84_.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=674255237 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_DATA_D-CAIT11_I-3818981531_TS-USERS_FNO-4_0QK30KA1_.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=674255237 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_01_FNO-5_0OK30K89_.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=674255238 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_02_FNO-6_0PK30K9S_.DBF
contents of Memory Script:{
set until scn  1556756;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clauseStarting recover at 23-DEC-08using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
starting media recoveryarchived log for thread 1 with sequence 36 is already on disk as file C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0RK30KBG_.ARCarchived log file name=C:\ORACLE\PRODUCT\11.1.0\FLASH_RECOVERY_AREA\PLATINUM\ARCHIVELOG\2008_12_23\O1_MF_1_36_ARCH_D-CAIT11_ID-3818981531_S-36_T-1_A-663176286_0RK30KBG_.ARC thread=1 sequence=36
media recovery complete, elapsed time: 00:00:07
Finished recover at 23-DEC-08
contents of Memory Script:{
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script
database dismounted
Oracle instance shut downconnected to auxiliary database (not started)
Oracle instance startedTotal System Global Area     150667264 bytes Fixed Size                     1331740 bytes
Variable Size                 92278244 bytes
Database Buffers              50331648 bytes
Redo Buffers                   6725632 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PLATINUM" RESETLOGS ARCHIVELOG
MAXLOGFILES     16
MAXLOGMEMBERS      3
MAXDATAFILES      100
MAXINSTANCES     8
MAXLOGHISTORY      292
LOGFILE
GROUP  1  SIZE 50 M ,
GROUP  2  SIZE 50 M ,
GROUP  3  SIZE 50 M
DATAFILE
'C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSTEM_DATA_D-CAIT11_I-3818981531_TS-SYSTEM_FNO-1_0LK30K1Q_.DBF'
CHARACTER SET AL32UTF8

contents of Memory Script:
{
set newname for clone tempfile  1 to new;
switch clone tempfile all;
catalog clone datafilecopy  "C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_DATA_D-CAIT11_I-3818981531_TS-SYSAUX_FNO-2_0MK30K1T_.DBF";
catalog clone datafilecopy  "C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_DATA_D-CAIT11_I-3818981531_TS-UNDOTBS1_FNO-3_0NK30K84_.DBF";
catalog clone datafilecopy  "C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_DATA_D-CAIT11_I-3818981531_TS-USERS_FNO-4_0QK30KA1_.DBF";
catalog clone datafilecopy  "C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_01_FNO-5_0OK30K89_.DBF";
catalog clone datafilecopy  "C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_02_FNO-6_0PK30K9S_.DBF";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME renamed tempfile 1 to C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_TEMP_%U_.TMP in control file cataloged datafile copy
datafile copy file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_DATA_D-CAIT11_I-3818981531_TS-SYSAUX_FNO-2_0MK30K1T_.DBF RECID=1 STAMP=674255277cataloged datafile copy
datafile copy file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_DATA_D-CAIT11_I-3818981531_TS-UNDOTBS1_FNO-3_0NK30K84_.DBF RECID=2 STAMP=674255277cataloged datafile copy
datafile copy file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_DATA_D-CAIT11_I-3818981531_TS-USERS_FNO-4_0QK30KA1_.DBF RECID=3 STAMP=674255277cataloged datafile copy
datafile copy file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_01_FNO-5_0OK30K89_.DBF RECID=4 STAMP=674255278cataloged datafile copy
datafile copy file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_02_FNO-6_0PK30K9S_.DBF RECID=5 STAMP=674255278datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=674255277 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_SYSAUX_DATA_D-CAIT11_I-3818981531_TS-SYSAUX_FNO-2_0MK30K1T_.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=674255277 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_UNDOTBS1_DATA_D-CAIT11_I-3818981531_TS-UNDOTBS1_FNO-3_0NK30K84_.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=674255277 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_DATA_D-CAIT11_I-3818981531_TS-USERS_FNO-4_0QK30KA1_.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=674255278 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_01_FNO-5_0OK30K89_.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=674255278 file name=C:\ORACLE\PRODUCT\11.1.0\ORADATA\PLATINUM\DATAFILE\O1_MF_USERS_AR_DATA_D-CAIT11_I-3818981531_TS-USERS_ARCHIVE_02_FNO-6_0PK30K9S_.DBF
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 23-DEC-08