Source 2-Nodes Oracle 11.2.0.4.0 RAC
alert_zwc.log
listener.ora & tnsnames,ora
Target Single Instance Oracle 11.2.0.4.0
Source
[oracle@vzwc1 oracle]$ mkdir /u01/app/oracle/bak
[oracle@vzwc1 oracle]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 12:45:57 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828)
RMAN> run
2> {
3> CONFIGURE CONTROLFILE AUTOBACKUP ON;
4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/bak/%F_CNT';
5> BACKUP FORMAT '/u01/app/oracle/bak/%T_%s_%p_DAT' DATABASE
6> PLUS ARCHIVELOG FORMAT '/u01/app/oracle/bak/%T_%s_%p_ARC' DELETE ALL INPUT;
7> }
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/bak/%F_CNT';
new RMAN configuration parameters are successfully stored
Starting backup at 20-SEP-2013 12:47:54
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 instance=zwc1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=2 STAMP=826495840
input archived log thread=2 sequence=1 RECID=1 STAMP=826495593
input archived log thread=2 sequence=2 RECID=3 STAMP=826495840
input archived log thread=2 sequence=3 RECID=5 STAMP=826495942
input archived log thread=1 sequence=7 RECID=4 STAMP=826495882
input archived log thread=1 sequence=8 RECID=7 STAMP=826630270
input archived log thread=2 sequence=4 RECID=6 STAMP=826495944
input archived log thread=1 sequence=9 RECID=8 STAMP=826634876
input archived log thread=2 sequence=5 RECID=9 STAMP=826634878
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:48:05
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:48:06
piece handle=/u01/app/oracle/bak/20130920_1_1_ARC tag=TAG20130920T124804 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_1_seq_6.263.826495841 RECID=2 STAMP=826495840
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_1.261.826495591 RECID=1 STAMP=826495593
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_2.262.826495839 RECID=3 STAMP=826495840
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_3.265.826495943 RECID=5 STAMP=826495942
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_1_seq_7.264.826495883 RECID=4 STAMP=826495882
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_1_seq_8.267.826630269 RECID=7 STAMP=826630270
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_4.266.826495943 RECID=6 STAMP=826495944
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_1_seq_9.268.826634877 RECID=8 STAMP=826634876
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_2_seq_5.269.826634877 RECID=9 STAMP=826634878
Finished backup at 20-SEP-2013 12:48:09
Starting backup at 20-SEP-2013 12:48:10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATADG/zwc/datafile/system.256.826495029
input datafile file number=00002 name=+DATADG/zwc/datafile/sysaux.257.826495029
input datafile file number=00005 name=+DATADG/zwc/datafile/example.264.826495145
input datafile file number=00003 name=+DATADG/zwc/datafile/undotbs1.258.826495029
input datafile file number=00006 name=+DATADG/zwc/datafile/undotbs2.265.826495425
input datafile file number=00004 name=+DATADG/zwc/datafile/users.259.826495029
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:48:10
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:49:56
piece handle=/u01/app/oracle/bak/20130920_2_1_DAT tag=TAG20130920T124810 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:46
Finished backup at 20-SEP-2013 12:49:56
Starting backup at 20-SEP-2013 12:49:56
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=10 RECID=11 STAMP=826635000
input archived log thread=2 sequence=6 RECID=10 STAMP=826634997
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:50:00
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:50:01
piece handle=/u01/app/oracle/bak/20130920_3_1_ARC tag=TAG20130920T125000 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_1_seq_10.268.826634999 RECID=11 STAMP=826635000
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_2_seq_6.269.826634997 RECID=10 STAMP=826634997
Finished backup at 20-SEP-2013 12:50:02
Starting Control File and SPFILE Autobackup at 20-SEP-2013 12:50:03
piece handle=/u01/app/oracle/bak/c-582474828-20130920-00_CNT comment=NONE
Finished Control File and SPFILE Autobackup at 20-SEP-2013 12:50:10
RMAN> exit
Recovery Manager complete.
[oracle@vzwc1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 12:53:17 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATADG/zwc/spfilezwc.ora
SQL> create pfile='initzwc.ora' from spfile;
File created.
[oracle@vzwc1 dbs]$ cat initzwc.ora
#zwc2.__db_cache_size=553648128
#zwc1.__db_cache_size=536870912
#zwc1.__java_pool_size=16777216
#zwc2.__java_pool_size=16777216
#zwc1.__large_pool_size=33554432
#zwc2.__large_pool_size=33554432
#zwc2.__pga_aggregate_target=285212672
#zwc1.__pga_aggregate_target=318767104
#zwc2.__sga_target=989855744
#zwc1.__sga_target=956301312
#zwc1.__shared_io_pool_size=0
#zwc2.__shared_io_pool_size=0
#zwc1.__shared_pool_size=352321536
#zwc2.__shared_pool_size=369098752
#zwc1.__streams_pool_size=0
#zwc2.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/zwc/adump'
*.audit_trail='db'
#*.cluster_database=true
*.compatible='11.2.0.4.0'
*.control_files='/u01/app/oracle/oradata/zwc/control01.ctl','/u01/app/oracle/oradata/zwc/control02.ctl'
*.db_block_size=8192
#*.db_create_file_dest='+DATADG'
*.db_domain=''
*.db_name='zwc'
#*.db_recovery_file_dest='+FRADG'
#*.db_recovery_file_dest_size=10737418240
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=zwcXDB)'
#zwc2.instance_number=2
#zwc1.instance_number=1
*.log_archive_format='%t_%s_%r.dbf'
#*.memory_target=1262485504
*.open_cursors=300
*.processes=1200
#*.remote_listener='vzwc-cluster-scan:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=1325
#zwc2.thread=2
#zwc1.thread=1
#zwc1.undo_tablespace='UNDOTBS1'
#zwc2.undo_tablespace='UNDOTBS2'
*.undo_tablespace='UNDOTBS1'
[oracle@vzwc1 bak]$ tar -czvf fullbak.tar.gz *
20130920_1_1_ARC
20130920_2_1_DAT
20130920_3_1_ARC
c-582474828-20130920-00_CNT
[oracle@vzwc1 bak]$ ll
total 1437936
-rw-r----- 1 oracle asmadmin 15411200 Sep 20 12:48 20130920_1_1_ARC
-rw-r----- 1 oracle asmadmin 1153646592 Sep 20 12:49 20130920_2_1_DAT
-rw-r----- 1 oracle asmadmin 12288 Sep 20 12:50 20130920_3_1_ARC
-rw-r----- 1 oracle asmadmin 18579456 Sep 20 12:50 c-582474828-20130920-00_CNT
-rw-r--r-- 1 oracle oinstall 283332444 Sep 20 13:00 fullbak.tar.gz
[oracle@vzwc1 bak]$ scp fullbak.tar.gz oracle@192.168.1.11:/u01/app/oracle/bak
The authenticity of host '192.168.1.11 (192.168.1.11)' can't be established.
RSA key fingerprint is 2b:c6:19:09:45:4b:ee:ba:c2:6f:48:da:04:72:de:27.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.1.11' (RSA) to the list of known hosts.
oracle@192.168.1.11's password:
fullbak.tar.gz 100% 270MB 18.0MB/s 00:15
[oracle@vzwc1 bak]$ scp $ORACLE_HOME/dbs/initzwc.ora oracle@192.168.1.11:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
oracle@192.168.1.11's password:
initzwc.ora 100% 1359 1.3KB/s 00:00
[oracle@vzwc1 bak]$
Target
[oracle@rmanrec ~]$ mkdir /u01/app/oracle/arch
[oracle@rmanrec ~]$ mkdir -p /u01/app/oracle/admin/zwc/adump
[oracle@rmanrec ~]$ mkdir -p /u01/app/oracle/oradata/zwc
[oracle@rmanrec ~]$ orapwd file=$ORACLE_HOME/dbs/orapwzwc entries=5 force=y password=oracle
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:10:18 2013
Copyright (c) 1982, 2013, 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 384180224 bytes
Fixed Size 2253424 bytes
Variable Size 327159184 bytes
Database Buffers 50331648 bytes
Redo Buffers 4435968 bytes
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 05:12:08 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (not mounted)
RMAN> restore controlfile from '/u01/app/oracle/bak/c-582474828-20130920-00_CNT';
Starting restore at 20-SEP-2013 05:12:27
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/zwc/control01.ctl
output file name=/u01/app/oracle/oradata/zwc/control02.ctl
Finished restore at 20-SEP-2013 05:12:30
RMAN> mount database;
database mounted
released channel: ORA_DISK_1
RMAN>
RMAN> catalog start with '/u01/app/oracle/bak/';
searching for all files that match the pattern /u01/app/oracle/bak/
List of Files Unknown to the Database
=====================================
File Name: /u01/app/oracle/bak/c-582474828-20130920-00_CNT
File Name: /u01/app/oracle/bak/fullbak.tar.gz
Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/bak/c-582474828-20130920-00_CNT
List of Files Which Where Not Cataloged
=======================================
File Name: /u01/app/oracle/bak/fullbak.tar.gz
RMAN-07517: Reason: The file header is corrupted
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
1 14.70M DISK 00:00:00 20-SEP-2013 12:48:05
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130920T124804
Piece Name: /u01/app/oracle/bak/20130920_1_1_ARC
List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 6 996244 18-SEP-2013 22:04:47 1003685 18-SEP-2013 22:10:40
1 7 1003685 18-SEP-2013 22:10:40 1003702 18-SEP-2013 22:11:22
1 8 1003702 18-SEP-2013 22:11:22 1043761 20-SEP-2013 11:31:09
1 9 1043761 20-SEP-2013 11:31:09 1055347 20-SEP-2013 12:47:56
2 1 999525 18-SEP-2013 22:06:28 999569 18-SEP-2013 22:06:31
2 2 999862 18-SEP-2013 22:07:20 1003682 18-SEP-2013 22:10:39
2 3 1003682 18-SEP-2013 22:10:39 1023714 18-SEP-2013 22:12:21
2 4 1023714 18-SEP-2013 22:12:21 1023717 18-SEP-2013 22:12:22
2 5 1044191 20-SEP-2013 11:32:25 1055351 20-SEP-2013 12:47:56
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
2 Full 1.07G DISK 00:01:40 20-SEP-2013 12:49:50
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130920T124810
Piece Name: /u01/app/oracle/bak/20130920_2_1_DAT
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- -------------------- ----
1 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/system.256.826495029
2 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/sysaux.257.826495029
3 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/undotbs1.258.826495029
4 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/users.259.826495029
5 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/example.264.826495145
6 Full 1055369 20-SEP-2013 12:48:10 +DATADG/zwc/datafile/undotbs2.265.826495425
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
3 11.50K DISK 00:00:00 20-SEP-2013 12:50:00
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130920T125000
Piece Name: /u01/app/oracle/bak/20130920_3_1_ARC
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 10 1055347 20-SEP-2013 12:47:56 1055468 20-SEP-2013 12:49:59
2 6 1055351 20-SEP-2013 12:47:56 1055464 20-SEP-2013 12:49:57
RMAN>
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
1 B A A DISK 20-SEP-2013 12:48:05 1 1 NO TAG20130920T124804
2 B F A DISK 20-SEP-2013 12:49:50 1 1 NO TAG20130920T124810
3 B A A DISK 20-SEP-2013 12:50:00 1 1 NO TAG20130920T125000
RMAN>
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:18:32 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set lines 100 pages 100
SQL> select name from v$datafile
2 union all
3 select name from v$tempfile
4 union all
5 select member from v$logfile
6 union all
7 select name from v$controlfile
8 /
NAME
----------------------------------------------------------------------------------------------------
+DATADG/zwc/datafile/system.256.826495029
+DATADG/zwc/datafile/sysaux.257.826495029
+DATADG/zwc/datafile/undotbs1.258.826495029
+DATADG/zwc/datafile/users.259.826495029
+DATADG/zwc/datafile/example.264.826495145
+DATADG/zwc/datafile/undotbs2.265.826495425
+DATADG/zwc/tempfile/temp.263.826495137
+DATADG/zwc/onlinelog/group_2.262.826495123
+FRADG/zwc/onlinelog/group_2.258.826495125
+DATADG/zwc/onlinelog/group_1.261.826495119
+FRADG/zwc/onlinelog/group_1.257.826495121
+DATADG/zwc/onlinelog/group_3.266.826495573
+FRADG/zwc/onlinelog/group_3.259.826495577
+DATADG/zwc/onlinelog/group_4.267.826495581
+FRADG/zwc/onlinelog/group_4.260.826495585
/u01/app/oracle/oradata/zwc/control01.ctl
/u01/app/oracle/oradata/zwc/control02.ctl
17 rows selected.
SQL> col name for a50
SQL> select file#,name from v$datafile;
FILE# NAME
---------- --------------------------------------------------
1 +DATADG/zwc/datafile/system.256.826495029
2 +DATADG/zwc/datafile/sysaux.257.826495029
3 +DATADG/zwc/datafile/undotbs1.258.826495029
4 +DATADG/zwc/datafile/users.259.826495029
5 +DATADG/zwc/datafile/example.264.826495145
6 +DATADG/zwc/datafile/undotbs2.265.826495425
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 05:21:15 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828, not open)
RMAN> run
2> {
3> set newname for datafile 1 to '/u01/app/oracle/oradata/zwc/system01.dbf';
4> set newname for datafile 2 to '/u01/app/oracle/oradata/zwc/sysaux01.dbf';
5> set newname for datafile 3 to '/u01/app/oracle/oradata/zwc/undotbs1.dbf';
6> set newname for datafile 4 to '/u01/app/oracle/oradata/zwc/users01.dbf';
7> set newname for datafile 5 to '/u01/app/oracle/oradata/zwc/example01.dbf';
8> set newname for datafile 6 to '/u01/app/oracle/oradata/zwc/undotbs2.dbf';
9> set newname for tempfile 1 to '/u01/app/oracle/oradate/zwc/temp01.dbf';
10> restore database;
11> switch datafile all;
12> switch tempfile all;
13> }
executing command: SET NEWNAME
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 restore at 20-SEP-2013 05:26:11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=20 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/zwc/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/zwc/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/zwc/undotbs1.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/zwc/users01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/zwc/example01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/zwc/undotbs2.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/bak/20130920_2_1_DAT
channel ORA_DISK_1: piece handle=/u01/app/oracle/bak/20130920_2_1_DAT tag=TAG20130920T124810
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 20-SEP-2013 05:27:17
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/undotbs1.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/example01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=826608437 file name=/u01/app/oracle/oradata/zwc/undotbs2.dbf
renamed tempfile 1 to /u01/app/oracle/oradate/zwc/temp01.dbf in control file
RMAN>
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:28:31 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> set lines 100 pages 100
SQL> select name from v$datafile
2 union all
3 select name from v$tempfile
4 union all
5 select member from v$logfile
6 union all
7 select name from v$controlfile
8 /
NAME
----------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/zwc/system01.dbf
/u01/app/oracle/oradata/zwc/sysaux01.dbf
/u01/app/oracle/oradata/zwc/undotbs1.dbf
/u01/app/oracle/oradata/zwc/users01.dbf
/u01/app/oracle/oradata/zwc/example01.dbf
/u01/app/oracle/oradata/zwc/undotbs2.dbf
/u01/app/oracle/oradate/zwc/temp01.dbf
+DATADG/zwc/onlinelog/group_2.262.826495123
+FRADG/zwc/onlinelog/group_2.258.826495125
+DATADG/zwc/onlinelog/group_1.261.826495119
+FRADG/zwc/onlinelog/group_1.257.826495121
+DATADG/zwc/onlinelog/group_3.266.826495573
+FRADG/zwc/onlinelog/group_3.259.826495577
+DATADG/zwc/onlinelog/group_4.267.826495581
+FRADG/zwc/onlinelog/group_4.260.826495585
/u01/app/oracle/oradata/zwc/control01.ctl
/u01/app/oracle/oradata/zwc/control02.ctl
17 rows selected.
SQL> alter database rename file '+FRADG/zwc/onlinelog/group_1.257.826495121' to '/u01/app/oracle/oradata/zwc/redo_1_1.log';
Database altered.
SQL> alter database rename file '+DATADG/zwc/onlinelog/group_1.261.826495119' to '/u01/app/oracle/oradata/zwc/redo_1_2.log';
Database altered.
SQL> alter database rename file '+FRADG/zwc/onlinelog/group_2.258.826495125' to '/u01/app/oracle/oradata/zwc/redo_2_1.log';
Database altered.
SQL> alter database rename file '+DATADG/zwc/onlinelog/group_2.262.826495123' to '/u01/app/oracle/oradata/zwc/redo_2_2.log';
Database altered.
SQL> alter database rename file '+FRADG/zwc/onlinelog/group_3.259.826495577' to '/u01/app/oracle/oradata/zwc/redo_3_1.log';
Database altered.
SQL> alter database rename file '+DATADG/zwc/onlinelog/group_3.266.826495573' to '/u01/app/oracle/oradata/zwc/redo_3_2.log';
Database altered.
SQL> alter database rename file '+FRADG/zwc/onlinelog/group_4.260.826495585' to '/u01/app/oracle/oradata/zwc/redo_4_1.log';
Database altered.
SQL> alter database rename file '+DATADG/zwc/onlinelog/group_4.267.826495581' to '/u01/app/oracle/oradata/zwc/redo_4_2.log';
Database altered.
SQL> set lines 100 pages 100
SQL> select name from v$datafile
2 union all
3 select name from v$tempfile
4 union all
5 select member from v$logfile
6 union all
7 select name from v$controlfile
8 /
NAME
----------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/zwc/system01.dbf
/u01/app/oracle/oradata/zwc/sysaux01.dbf
/u01/app/oracle/oradata/zwc/undotbs1.dbf
/u01/app/oracle/oradata/zwc/users01.dbf
/u01/app/oracle/oradata/zwc/example01.dbf
/u01/app/oracle/oradata/zwc/undotbs2.dbf
/u01/app/oracle/oradate/zwc/temp01.dbf
/u01/app/oracle/oradata/zwc/redo_2_2.log
/u01/app/oracle/oradata/zwc/redo_2_1.log
/u01/app/oracle/oradata/zwc/redo_1_2.log
/u01/app/oracle/oradata/zwc/redo_1_1.log
/u01/app/oracle/oradata/zwc/redo_3_2.log
/u01/app/oracle/oradata/zwc/redo_3_1.log
/u01/app/oracle/oradata/zwc/redo_4_2.log
/u01/app/oracle/oradata/zwc/redo_4_1.log
/u01/app/oracle/oradata/zwc/control01.ctl
/u01/app/oracle/oradata/zwc/control02.ctl
17 rows selected.
SQL>
SQL> col member for a50
SQL> select group#,member from v$logfile order by 1
2
SQL> /
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/zwc/redo_1_1.log
1 /u01/app/oracle/oradata/zwc/redo_1_2.log
2 /u01/app/oracle/oradata/zwc/redo_2_1.log
2 /u01/app/oracle/oradata/zwc/redo_2_2.log
3 /u01/app/oracle/oradata/zwc/redo_3_2.log
3 /u01/app/oracle/oradata/zwc/redo_3_1.log
4 /u01/app/oracle/oradata/zwc/redo_4_2.log
4 /u01/app/oracle/oradata/zwc/redo_4_1.log
8 rows selected.
SQL>
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 05:37:19 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828, not open)
RMAN> recover database;
Starting recover at 20-SEP-2013 05:38:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=6
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/bak/20130920_3_1_ARC
channel ORA_DISK_1: piece handle=/u01/app/oracle/bak/20130920_3_1_ARC tag=TAG20130920T125000
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_826495119.dbf thread=1 sequence=10
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_6_826495119.dbf thread=2 sequence=6
unable to find archived log
archived log thread=2 sequence=7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/20/2013 05:38:08
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 7 and starting SCN of 1055464
RMAN> alter database open resetlogs;
database opened
RMAN>
alert_zwc.log
Fri Sep 20 05:38:06 2013
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
Serial Media Recovery started
ORA-279 signalled during: alter database recover if needed
start until cancel using backup controlfile
...
alter database recover logfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_826495119.dbf'
Media Recovery Log /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_826495119.dbf
ORA-279 signalled during: alter database recover logfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_826495119.dbf'...
alter database recover logfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_6_826495119.dbf'
Media Recovery Log /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_6_826495119.dbf
ORA-279 signalled during: alter database recover logfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_6_826495119.dbf'...
alter database recover cancel
Media Recovery Canceled
Completed: alter database recover cancel
Fri Sep 20 05:38:52 2013
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 1055464
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 /u01/app/oracle/oradata/zwc/redo_1_2.log
Clearing online log 1 of thread 1 sequence number 11
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/zwc/redo_1_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 1 complete
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 /u01/app/oracle/oradata/zwc/redo_2_2.log
Clearing online log 2 of thread 1 sequence number 10
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/zwc/redo_2_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 2 complete
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 /u01/app/oracle/oradata/zwc/redo_3_2.log
Clearing online log 3 of thread 2 sequence number 7
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 3 of thread 2
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 3 thread 2: '/u01/app/oracle/oradata/zwc/redo_3_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 3 complete
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Clearing online redo logfile 4 /u01/app/oracle/oradata/zwc/redo_4_2.log
Clearing online log 4 of thread 2 sequence number 6
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_ora_12536.trc:
ORA-00313: open failed for members of log group 4 of thread 2
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_1.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-00312: online log 4 thread 2: '/u01/app/oracle/oradata/zwc/redo_4_2.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Fri Sep 20 05:39:04 2013
Clearing online redo logfile 4 complete
Resetting resetlogs activation ID 582496328 (0x22b83048)
Online log /u01/app/oracle/oradata/zwc/redo_1_2.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_1_1.log: Thread 1 Group 1 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_2_2.log: Thread 1 Group 2 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_2_1.log: Thread 1 Group 2 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_3_2.log: Thread 2 Group 3 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_3_1.log: Thread 2 Group 3 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_4_2.log: Thread 2 Group 4 was previously cleared
Online log /u01/app/oracle/oradata/zwc/redo_4_1.log: Thread 2 Group 4 was previously cleared
Fri Sep 20 05:39:04 2013
Setting recovery target incarnation to 3
Fri Sep 20 05:39:04 2013
Assigning activation ID 582631885 (0x22ba41cd)
LGWR: STARTING ARCH PROCESSES
Fri Sep 20 05:39:04 2013
ARC0 started with pid=21, OS id=12562
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/zwc/redo_1_2.log
Current log# 1 seq# 1 mem# 1: /u01/app/oracle/oradata/zwc/redo_1_1.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Sep 20 05:39:05 2013
SMON: enabling cache recovery
Fri Sep 20 05:39:05 2013
ARC1 started with pid=23, OS id=12566
Fri Sep 20 05:39:05 2013
ARC2 started with pid=24, OS id=12570
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Fri Sep 20 05:39:05 2013
ARC3 started with pid=25, OS id=12574
Redo thread 2 internally disabled at seq 1 (CKPT)
ARC1: Archiving disabled thread 2 sequence 1
Archived Log entry 14 added for thread 2 sequence 1 ID 0x0 dest 1:
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
[12536] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:6990834 end:6991494 diff:660 (6 seconds)
Dictionary check beginning
Fri Sep 20 05:39:07 2013
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_dbw0_12197.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradate/zwc/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_dbw0_12197.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradate/zwc/temp01.dbf'
File 201 not verified due to error ORA-01157
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Cannot re-create tempfile /u01/app/oracle/oradate/zwc/temp01.dbf, the same name file exists
Errors in file /u01/app/oracle/diag/rdbms/zwc/zwc/trace/zwc_dbw0_12197.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradate/zwc/temp01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Database Characterset is ZHS16GBK
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Fri Sep 20 05:39:09 2013
QMNC started with pid=26, OS id=12578
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Fri Sep 20 05:39:16 2013
Completed: alter database open resetlogs
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
SQL> drop tablespace undotbs2 including contents and datafiles;
Tablespace dropped.
listener.ora & tnsnames,ora
[oracle@rmanrec admin]$ cat *.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = zwc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = zwc)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rmanrec)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ZWC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rmanrec)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zwc)
)
)
[oracle@rmanrec ~]$ sqlplus scott/tiger@zwc
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:48:21 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select ename from emp;
ENAME
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
ENAME
----------
JAMES
FORD
MILLER
14 rows selected.
SQL>