------------------------------
Reading the http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm URL is advisable before one attempt to do cloning the oracle database. This is my view.
As you all know that there are two simplest methods to clone the db
1. active database duplication (source should be available)
2. backup based database duplication (using source backup files, connection to source db is optional)
The following method shows the first way of doing clone the database - active database duplication
Source db is in archivelog and have a valid backup (RMAN> backup database plus archivelog delete input;)
Sys password should be same on both source and target
Requirement is to clone the orcl database to destination clonedb1 db on same host on windows 7
1. Add entry into lsnrctl.ora and tnsnames.ora network config files.
Target database: clonedb1
lsnrctl.ora:
----------------
(SID_DESC =complete: lsnrctl.ora file
(GLOBAL_DBNAME=CLONEDB1)
(SID_NAME = CLONEDB1)
(ORACLE_HOME = F:\app\HOME\product\11.2.0\dbhome_1)
)
# listener.ora Network Configuration File: F:\app\HOME\product\11.2.0\dbhome_1\network\admin\listener.oratnsnames.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = F:\app\HOME\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:F:\app\HOME\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(SID_DESC =
(GLOBAL_DBNAME=CLONEDB1)
(SID_NAME = CLONEDB1)
(ORACLE_HOME = F:\app\HOME\product\11.2.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = F:\app\HOME
----------------
CLONEDB1 =tnsnmaes.ora file:
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLONEDB1)
)
)
# tnsnames.ora Network Configuration File: F:\app\HOME\product\11.2.0\dbhome_1\network\admin\tnsnames.ora2. create service and start the service
# Generated by Oracle configuration tools.
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
CLONEDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CLONEDB1)
)
)
C:\Users\HOME>3. Create password file
C:\Users\HOME>oradim -delete -sid clonedb1
Instance deleted.
C:\Users\HOME>oradim -new -sid clonedb1 -intpwd password=oracle -startmode a -pf
ile D:\TESTDELETE\initclonedb1.ora
OPW-00005: File with same name exists - please delete or rename
Instance created.
C:\Users\HOME>orapwd file=F:\app\HOME\product\11.2.0\dbhome_1\database\PWDcloned4. Create pfile from source db
b1.ora password=oracle entries=50
login soruce db:
C:\Users\HOME>SET ORACLE_SID=ORCL5. Replace orcl in initclonedb1.ora file with clonedb1
C:\Users\HOME>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 17 22:32:01 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL> create pfile='D:\TESTDELETE\initclonedb1.ora' from spfile;
File created.
find (orcl) and replace (clonedb1), do other changes as applicable.
initclonedb1.ora file contents are
Note: create all directoires as shown in the initclonedb1.ora file -- folders can be empty but directory structure should be presented....
clonedb1.__db_cache_size=369098752
clonedb1.__java_pool_size=4194304
clonedb1.__large_pool_size=4194304
clonedb1.__oracle_base='F:\app\HOME'#ORACLE_BASE set from environment
clonedb1.__pga_aggregate_target=427819008
clonedb1.__sga_target=641728512
clonedb1.__shared_io_pool_size=0
clonedb1.__shared_pool_size=255852544
clonedb1.__streams_pool_size=0
*.audit_file_dest='F:\app\HOME\admin\clonedb1\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='F:\app\HOME\oradata\clonedb1\control01.ctl','F:\app\HOME\flash_recovery_area\clonedb1\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='clonedb1'
*.db_recovery_file_dest='F:\app\HOME\flash_recovery_area'
*.db_recovery_file_dest_size=4039114752
*.diagnostic_dest='F:\app\HOME'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=clonedb1XDB)'
*.memory_target=1069547520
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
6. Start the clonedb1 instance
7. Connect source db and target db via rman for db duplication
C:\Users\HOME>set ORACLE_SID=CLONEDB1
C:\Users\HOME>lsrnctl reload
'lsrnctl' is not recognized as an internal or external command,
operable program or batch file.
C:\Users\HOME>lsnrctl reload
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 17-DEC-2011 22:52
:04
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
C:\Users\HOME>
C:\Users\HOME>SET ORACLE_SID=CLONEDB1
C:\Users\HOME>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 17 22:53:03 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='D:\TESTDELETE\initclonedb1.ora'
ORACLE instance started.
Total System Global Area 640286720 bytes
Fixed Size 1376492 bytes
Variable Size 264245012 bytes
Database Buffers 369098752 bytes
Redo Buffers 5566464 bytes
SQL>
Check for the successful login
SQL> conn sys/oracle@clonedb1 as sysdba
Connected.
SQL>
C:\Users\HOME>set ORACLE_SID=ORCLEnsure the above statement is run with sufficent disk space for db_recovery_File_Desk_size on both source and target db.
alter system set db_recovery_file_dest_size=5G;
tnsping orcl
tnsping clonedb1
Ensure that the above both commands give valid output in source system... it means you are able to connect both databases and able to do successfull clone in upcoming steps...
C:\Users\HOME>rman target sys/oracle@orclChange run command when you are cloning on same database to avoid conflcting with source db files. The directory structure should be the one that database files will be created on target cloned db on target system.
Recovery Manager: Release 11.2.0.1.0 - Production on Sat Dec 17 23:00:00 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1297854480)
RMAN> connect auxiliary sys/oracle@clonedb1
connected to auxiliary database: CLONEDB1 (not mounted)
[
one can also connect rman like below
C:\Users\HOME>rman target sys/oracle@orcl auxiliary sys/oracle@clonedb1
]
SQL> select file#, name from v$datafile;
SQL> select file#, name from v$tempfile;
RMAN> run {
2> SET NEWNAME FOR DATAFILE 1 TO 'F:\app\HOME\oradata\clonedb1\SYSTEM01.DBF';
3> SET NEWNAME FOR DATAFILE 2 TO 'F:\app\HOME\oradata\clonedb1\SYSAUX01.DBF';
4> SET NEWNAME FOR DATAFILE 3 TO 'F:\app\HOME\oradata\clonedb1\UNDOTBS01.DBF';
5> SET NEWNAME FOR DATAFILE 4 TO 'F:\app\HOME\oradata\clonedb1\USERS01.DBF';
6> SET NEWNAME FOR DATAFILE 5 TO 'F:\app\HOME\oradata\clonedb1\EXAMPLE01.DBF';
7> SET NEWNAME FOR TEMPFILE 1 TO 'F:\app\HOME\oradata\clonedb1\TEMP01.DBF';
8> duplicate target database to clonedb1 from active database;
9> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting Duplicate Db at 18-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script
sql statement: create spfile from memory
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 640286720 bytes
Fixed Size 1376492 bytes
Variable Size 268439316 bytes
Database Buffers 364904448 bytes
Redo Buffers 5566464 bytes
contents of Memory Script:
{
sql clone "alter system set db_name =
''ORCL'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''CLONEDB1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format 'F:\APP\HOME\ORADATA\CLO
NEDB1\CONTROL01.CTL';
restore clone controlfile to 'F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\CONTR
OL02.CTL' from
'F:\APP\HOME\ORADATA\CLONEDB1\CONTROL01.CTL';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN
duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''CLONEDB1'' comment= ''Modif
ied by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 640286720 bytes
Fixed Size 1376492 bytes
Variable Size 268439316 bytes
Database Buffers 364904448 bytes
Redo Buffers 5566464 bytes
Starting backup at 18-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=24 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=F:\APP\HOME\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFORCL.ORA tag=T
AG20111218T094144 RECID=5 STAMP=770204506
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 18-DEC-11
Starting restore at 18-DEC-11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=133 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 18-DEC-11
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"F:\app\HOME\oradata\clonedb1\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\app\HOME\oradata\clonedb1\SYSAUX01.DBF";
set newname for datafile 3 to
"F:\app\HOME\oradata\clonedb1\UNDOTBS01.DBF";
set newname for datafile 4 to
"F:\app\HOME\oradata\clonedb1\USERS01.DBF";
set newname for datafile 5 to
"F:\app\HOME\oradata\clonedb1\EXAMPLE01.DBF";
backup as copy reuse
datafile 1 auxiliary format
"F:\app\HOME\oradata\clonedb1\SYSTEM01.DBF" datafile
2 auxiliary format
"F:\app\HOME\oradata\clonedb1\SYSAUX01.DBF" datafile
3 auxiliary format
"F:\app\HOME\oradata\clonedb1\UNDOTBS01.DBF" datafile
4 auxiliary format
"F:\app\HOME\oradata\clonedb1\USERS01.DBF" datafile
5 auxiliary format
"F:\app\HOME\oradata\clonedb1\EXAMPLE01.DBF" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 18-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=F:\APP\HOME\ORADATA\ORCL\SYSTEM01.DBF
output file name=F:\APP\HOME\ORADATA\CLONEDB1\SYSTEM01.DBF tag=TAG20111218T09415
8
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=F:\APP\HOME\ORADATA\ORCL\SYSAUX01.DBF
output file name=F:\APP\HOME\ORADATA\CLONEDB1\SYSAUX01.DBF tag=TAG20111218T09415
8
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=F:\APP\HOME\ORADATA\ORCL\EXAMPLE01.DBF
output file name=F:\APP\HOME\ORADATA\CLONEDB1\EXAMPLE01.DBF tag=TAG20111218T0941
58
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=F:\APP\HOME\ORADATA\ORCL\UNDOTBS01.DBF
output file name=F:\APP\HOME\ORADATA\CLONEDB1\UNDOTBS01.DBF tag=TAG20111218T0941
58
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=F:\APP\HOME\ORADATA\ORCL\USERS01.DBF
output file name=F:\APP\HOME\ORADATA\CLONEDB1\USERS01.DBF tag=TAG20111218T094158
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 18-DEC-11
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "F:\APP\HOME\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_12_18\
O1_MF_1_29_7GTT5OFF_.ARC" auxiliary format
"F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_12_18\O1_MF_1_29_%U_.
ARC" ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script
Starting backup at 18-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=29 RECID=24 STAMP=770204687
output file name=F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_12_18\
O1_MF_1_29_ARCH_D-ORCL_ID-1297854480_S-29_T-1_A-770073748_0SMUGP0G_.ARC RECID=0
STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03
Finished backup at 18-DEC-11
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_12_18\O1_MF_
1_29_ARCH_D-ORCL_ID-1297854480_S-29_T-1_A-770073748_0SMUGP0G_.ARC
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_12_18\O1_MF_
1_29_ARCH_D-ORCL_ID-1297854480_S-29_T-1_A-770073748_0SMUGP0G_.ARC
List of files in Recovery Area not managed by the database
==========================================================
File Name: F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\CONTROL02.CTL
RMAN-07526: Reason: File is not an Oracle Managed File
number of files not managed by recovery area is 1, totaling 9.28MB
datafile 1 switched to datafile copy
input datafile copy RECID=5 STAMP=770204693 file name=F:\APP\HOME\ORADATA\CLONED
B1\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=6 STAMP=770204693 file name=F:\APP\HOME\ORADATA\CLONED
B1\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=7 STAMP=770204693 file name=F:\APP\HOME\ORADATA\CLONED
B1\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=8 STAMP=770204693 file name=F:\APP\HOME\ORADATA\CLONED
B1\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=9 STAMP=770204694 file name=F:\APP\HOME\ORADATA\CLONED
B1\EXAMPLE01.DBF
contents of Memory Script:
{
set until scn 1236392;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 18-DEC-11
using channel ORA_AUX_DISK_1
starting media recovery
archived log for thread 1 with sequence 29 is already on disk as file F:\APP\HOM
E\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_12_18\O1_MF_1_29_ARCH_D-ORCL_ID-1
297854480_S-29_T-1_A-770073748_0SMUGP0G_.ARC
archived log file name=F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ARCHIVELOG\2011_
12_18\O1_MF_1_29_ARCH_D-ORCL_ID-1297854480_S-29_T-1_A-770073748_0SMUGP0G_.ARC th
read=1 sequence=29
media recovery complete, elapsed time: 00:00:04
Finished recover at 18-DEC-11
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''CLONEDB1'' comment=
''Reset to original value by RMAN'' scope=spfile";
sql clone "alter system reset db_unique_name scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
database dismounted
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 640286720 bytes
Fixed Size 1376492 bytes
Variable Size 268439316 bytes
Database Buffers 364904448 bytes
Redo Buffers 5566464 bytes
sql statement: alter system set db_name = ''CLONEDB1'' comment= ''Reset to ori
ginal value by RMAN'' scope=spfile
sql statement: alter system reset db_unique_name scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 640286720 bytes
Fixed Size 1376492 bytes
Variable Size 268439316 bytes
Database Buffers 364904448 bytes
Redo Buffers 5566464 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONEDB1" RESETLOGS ARCHIV
ELOG
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
'F:\APP\HOME\ORADATA\CLONEDB1\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"F:\app\HOME\oradata\clonedb1\TEMP01.DBF";
switch clone tempfile all;
catalog clone datafilecopy "F:\APP\HOME\ORADATA\CLONEDB1\SYSAUX01.DBF",
"F:\APP\HOME\ORADATA\CLONEDB1\UNDOTBS01.DBF",
"F:\APP\HOME\ORADATA\CLONEDB1\USERS01.DBF",
"F:\APP\HOME\ORADATA\CLONEDB1\EXAMPLE01.DBF";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to F:\app\HOME\oradata\clonedb1\TEMP01.DBF in control file
cataloged datafile copy
datafile copy file name=F:\APP\HOME\ORADATA\CLONEDB1\SYSAUX01.DBF RECID=1 STAMP=
770204922
cataloged datafile copy
datafile copy file name=F:\APP\HOME\ORADATA\CLONEDB1\UNDOTBS01.DBF RECID=2 STAMP
=770204922
cataloged datafile copy
datafile copy file name=F:\APP\HOME\ORADATA\CLONEDB1\USERS01.DBF RECID=3 STAMP=7
70204922
cataloged datafile copy
datafile copy file name=F:\APP\HOME\ORADATA\CLONEDB1\EXAMPLE01.DBF RECID=4 STAMP
=770204922
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=770204922 file name=F:\APP\HOME\ORADATA\CLONED
B1\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=770204922 file name=F:\APP\HOME\ORADATA\CLONED
B1\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=770204922 file name=F:\APP\HOME\ORADATA\CLONED
B1\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=770204922 file name=F:\APP\HOME\ORADATA\CLONED
B1\EXAMPLE01.DBF
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-DEC-11
RMAN> }
8. login target system and test the newly cloned dbC:\Users\HOME>SET ORACLE_SID=CLONEDB1After doing all these one can see that cloned db is similar to what we see in source db..
C:\Users\HOME>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 18 12:00:53 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
CLONEDB1 READ WRITE
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 2
Current log sequence 2
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
F:\APP\HOME\ORADATA\CLONEDB1\TEMP01.DBF
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
F:\APP\HOME\ORADATA\CLONEDB1\CONTROL01.CTL
F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\CONTROL02.CTL
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ONLINELOG\O1_MF_3_7GTTFNCF_.LOG
F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ONLINELOG\O1_MF_2_7GTTFJD3_.LOG
F:\APP\HOME\FLASH_RECOVERY_AREA\CLONEDB1\ONLINELOG\O1_MF_1_7GTTFF3Y_.LOG
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string F:\app\HOME\flash_recovery_are
a
db_recovery_file_dest_size big integer 3852M
recovery_parallelism integer 0
SQL>
-- Have a fun in working in oracle Technologies-- Cheers
No comments:
Post a Comment