SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:15:16 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Parameter 1:
param# processes=150
Parameter 2:
param# memory_target=1728053248
Parameter 3:
param# control_files=G:\APP\VISHWAKARMA\ORADATA\TEST\CONTROL01.CTL, G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL
Parameter 4:
param# db_block_size=8192
Parameter 5:
param# compatible=11.2.0.0.0
Parameter 6:
param# db_recovery_file_dest=G:\app\Vishwakarma\flash_recovery_area
Parameter 7:
param# db_recovery_file_dest_size=4102029312
Parameter 8:
param# undo_tablespace=UNDOTBS1
Parameter 9:
param# remote_login_passwordfile=EXCLUSIVE
Parameter 10:
param# db_domain=""
Parameter 11:
param# dispatchers=(PROTOCOL=TCP) (SERVICE=testXDB)
Parameter 12:
param# audit_file_dest=G:\APP\VISHWAKARMA\ADMIN\TEST\ADUMP
Parameter 13:
param# audit_trail=NONE
Parameter 14:
param# db_name=test
Parameter 15:
param# open_cursors=300
Parameter 16:
param# diagnostic_dest=G:\APP\VISHWAKARMA
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Step: Destination Preparation
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 19-MAY-2017 22:16:05
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 19-MAY-2017 21:33:20
Uptime 0 days 0 hr. 42 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File G:\app\Vishwakarma\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File g:\app\vishwakarma\diag\tnslsnr\Vishwakarma-PC\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Vishwakarma-PC)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 19-MAY-2017 22:16:05
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:16:19 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected.
SQL> ORACLE instance shut down.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:16:20 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance shut down.
SQL>
File created.
SQL> ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2176448 bytes
Variable Size 1006635584 bytes
Database Buffers 704643072 bytes
Redo Buffers 6873088 bytes
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Step: Duplicate Database
Recovery Manager: Release 11.2.0.1.0 - Production on Fri May 19 22:16:36 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN>
echo set off
RMAN>
connected to target database: TEST (DBID=2242576134)
RMAN>
connected to auxiliary database: TEST1 (not mounted)
RMAN>
echo set on
RMAN> run {
2> SET NEWNAME FOR DATAFILE 1 TO 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSTEM01.dbf';
3> SET NEWNAME FOR DATAFILE 2 TO 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSAUX01.dbf';
4> SET NEWNAME FOR DATAFILE 3 TO 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\UNDOTBS01.dbf';
5> SET NEWNAME FOR DATAFILE 4 TO 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\USERS01.dbf';
6> SET NEWNAME FOR TEMPFILE 1 TO 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\TEMP01.dbf';
7> allocate channel tgt1 type disk;
8> allocate channel tgt2 type disk;
9> allocate auxiliary channel dup1 type disk;
10> DUPLICATE TARGET DATABASE TO 'test1'
11> FROM ACTIVE DATABASE
12> LOGFILE
13> GROUP 1 ('G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO01.log') size 20M reuse,
14> GROUP 2 ('G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO02.log') size 20M reuse,
15> GROUP 3 ('G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO03.log') size 20M reuse
16> ;
17> }
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
using target database control file instead of recovery catalog
allocated channel: tgt1
channel tgt1: SID=151 device type=DISK
allocated channel: tgt2
channel tgt2: SID=28 device type=DISK
allocated channel: dup1
channel dup1: SID=134 device type=DISK
Starting Duplicate Db at 19-MAY-17
contents of Memory Script:
{
sql clone "alter system set db_name =
''TEST'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''TEST1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format 'G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL01.CTL';
restore clone controlfile to 'G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL02.CTL' from
'G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL01.CTL';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''TEST'' comment= ''Modified by RMAN duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''TEST1'' comment= ''Modified by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 1720328192 bytes
Fixed Size 2176448 bytes
Variable Size 1006635584 bytes
Database Buffers 704643072 bytes
Redo Buffers 6873088 bytes
allocated channel: dup1
channel dup1: SID=134 device type=DISK
Starting backup at 19-MAY-17
channel tgt1: starting datafile copy
copying current control file
output file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTEST.ORA tag=TAG20170519T221650 RECID=1 STAMP=944432211
channel tgt1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 19-MAY-17
Starting restore at 19-MAY-17
channel dup1: copied control file copy
Finished restore at 19-MAY-17
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSTEM01.dbf";
set newname for datafile 2 to
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSAUX01.dbf";
set newname for datafile 3 to
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\UNDOTBS01.dbf";
set newname for datafile 4 to
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\USERS01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSTEM01.dbf" datafile
2 auxiliary format
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\SYSAUX01.dbf" datafile
3 auxiliary format
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\UNDOTBS01.dbf" datafile
4 auxiliary format
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\USERS01.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
Starting backup at 19-MAY-17
channel tgt1: starting datafile copy
input datafile file number=00001 name=G:\APP\VISHWAKARMA\ORADATA\TEST\SYSTEM01.DBF
channel tgt2: starting datafile copy
input datafile file number=00002 name=G:\APP\VISHWAKARMA\ORADATA\TEST\SYSAUX01.DBF
output file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF tag=TAG20170519T221659
channel tgt2: datafile copy complete, elapsed time: 00:00:45
channel tgt2: starting datafile copy
input datafile file number=00003 name=G:\APP\VISHWAKARMA\ORADATA\TEST\UNDOTBS01.DBF
output file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSTEM01.DBF tag=TAG20170519T221659
channel tgt1: datafile copy complete, elapsed time: 00:00:45
channel tgt1: starting datafile copy
input datafile file number=00004 name=G:\APP\VISHWAKARMA\ORADATA\TEST\USERS01.DBF
output file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF tag=TAG20170519T221659
channel tgt1: datafile copy complete, elapsed time: 00:00:03
output file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF tag=TAG20170519T221659
channel tgt2: datafile copy complete, elapsed time: 00:00:04
Finished backup at 19-MAY-17
sql statement: alter system archive log current
contents of Memory Script:
{
backup as copy reuse
archivelog like "G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST\ARCHIVELOG\2017_05_19\O1_MF_1_4_DKY8FORR_.ARC" auxiliary format
"G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_%U_.ARC" ;
catalog clone recovery area;
switch clone datafile all;
}
executing Memory Script
Starting backup at 19-MAY-17
channel tgt1: starting archived log copy
input archived log thread=1 sequence=4 RECID=2 STAMP=944432270
output file name=G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_ARCH_D-TEST_ID-2242576134_S-4_T-1_A-944429704_06S4LP4E_.ARC RECID=0 STAMP=0
channel tgt1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 19-MAY-17
searching for all files in the recovery area
List of Files Unknown to the Database
=====================================
File Name: G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_ARCH_D-TEST_ID-2242576134_S-4_T-1_A-944429704_06S4LP4E_.ARC
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_ARCH_D-TEST_ID-2242576134_S-4_T-1_A-944429704_06S4LP4E_.ARC
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=944432272 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=944432272 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=944432272 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=944432272 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF
contents of Memory Script:
{
set until scn 979934;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 19-MAY-17
starting media recovery
archived log for thread 1 with sequence 4 is already on disk as file G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_ARCH_D-TEST_ID-2242576134_S-4_T-1_A-944429704_06S4LP4E_.ARC
archived log file name=G:\APP\VISHWAKARMA\FLASH_RECOVERY_AREA\TEST1\ARCHIVELOG\2017_05_19\O1_MF_1_4_ARCH_D-TEST_ID-2242576134_S-4_T-1_A-944429704_06S4LP4E_.ARC thread=1 sequence=4
media recovery complete, elapsed time: 00:00:01
Finished recover at 19-MAY-17
contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
sql clone "alter system set db_name =
''TEST1'' 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 1720328192 bytes
Fixed Size 2176448 bytes
Variable Size 1006635584 bytes
Database Buffers 704643072 bytes
Redo Buffers 6873088 bytes
allocated channel: dup1
channel dup1: SID=133 device type=DISK
sql statement: alter system set db_name = ''TEST1'' comment= ''Reset to original 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 1720328192 bytes
Fixed Size 2176448 bytes
Variable Size 1006635584 bytes
Database Buffers 704643072 bytes
Redo Buffers 6873088 bytes
allocated channel: dup1
channel dup1: SID=133 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO01.log' ) SIZE 20 M REUSE,
GROUP 2 ( 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO02.log' ) SIZE 20 M REUSE,
GROUP 3 ( 'G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\REDO03.log' ) SIZE 20 M REUSE
DATAFILE
'G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSTEM01.DBF'
CHARACTER SET WE8MSWIN1252
contents of Memory Script:
{
set newname for tempfile 1 to
"G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\TEMP01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF",
"G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF",
"G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to G:\app\Vishwakarma\product\11.2.0\dbhome_1\oradata\test1\TEMP01.dbf in control file
cataloged datafile copy
datafile copy file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF RECID=1 STAMP=944432290
cataloged datafile copy
datafile copy file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF RECID=2 STAMP=944432290
cataloged datafile copy
datafile copy file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF RECID=3 STAMP=944432290
datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=944432290 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=944432290 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=944432290 file name=G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 19-MAY-17
released channel: tgt1
released channel: tgt2
released channel: dup1
RMAN> EXIT;
Recovery Manager complete.
Step: Recover Database
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:18:56 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> ORACLE instance started.
Total System Global Area 1720328192 bytes
Fixed Size 2176448 bytes
Variable Size 1006635584 bytes
Database Buffers 704643072 bytes
Redo Buffers 6873088 bytes
Database mounted.
SQL>
Database altered.
SQL>
STATUS
------------
OPEN
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Step: Add Temporary Files
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:19:26 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 Row count: 1
Reset ORACLE_OCM_CONFIG_DIR
PL/SQL procedure successfully completed.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Step: Check Database and Run Post Cloning Scripts
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:19:36 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected.
SQL>
datafile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSTEM01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF
SQL>
tempfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\TEMP01.DBF
SQL>
logfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO03.LOG
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO02.LOG
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO01.LOG
SQL>
controlfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL01.CTL
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL02.CTL
SQL>
directory name
------------------------------
directory path
--------------------------------------------------------------------------------
XMLDIR
c:\ade\aime_dadvfh0169\oracle/rdbms/xml
DATA_PUMP_DIR
G:\app\Vishwakarma/admin/test/dpdump/
ORACLE_OCM_CONFIG_DIR
G:\app\Vishwakarma\product\11.2.0\dbhome_1/ccr/state
SQL>
no rows selected
SQL>
spfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILETEST1.ORA
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Step: Mask data
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 19 22:19:46 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> Connected.
SQL>
datafile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSTEM01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\SYSAUX01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\UNDOTBS01.DBF
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\USERS01.DBF
SQL>
tempfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\TEMP01.DBF
SQL>
logfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO03.LOG
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO02.LOG
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\REDO01.LOG
SQL>
controlfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL01.CTL
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\ORADATA\TEST1\CONTROL02.CTL
SQL>
directory name
------------------------------
directory path
--------------------------------------------------------------------------------
XMLDIR
c:\ade\aime_dadvfh0169\oracle/rdbms/xml
DATA_PUMP_DIR
G:\app\Vishwakarma/admin/test/dpdump/
ORACLE_OCM_CONFIG_DIR
G:\app\Vishwakarma\product\11.2.0\dbhome_1/ccr/state
SQL>
no rows selected
SQL>
spfile
--------------------------------------------------------------------------------
G:\APP\VISHWAKARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILETEST1.ORA
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options