[root@oracle01 ~]# su - oracle
[oracle@oracle01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production
on Tue Jul 3 22:32:36 2018
Copyright (c) 1982, 2011, Oracle. All
rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition
Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining
and Real Application Testing options
SYS@VDEDU> archive log list;
Database log mode No Archive
Mode
Automatic archival Disabled
Archive destination
USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 15
Current log sequence 16
SYS@VDEDU> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@VDEDU> quit
Disconnected from Oracle Database 11g
Enterprise Edition Release 11.2.0.3.0 -
64bit Production
With the Partitioning, OLAP, Data Mining
and Real Application Testing options
[oracle@oracle01 ~]$ cd /u01/app/oracle/
oradata/VDEDU/
[oracle@oracle01 VDEDU]$
[oracle@oracle01 VDEDU]$ pwd
/u01/app/oracle/oradata/VDEDU
[oracle@oracle01 VDEDU]$ ls
control01.ctl redo01_III.log
redo03.log redo04_a.log
redo0_III.log redo13.log
system01.dbf
example01.dbf redo02.log
redo032_III.log redo04_b.log redo1.log
redo2.log temp01.dbf
redo01.log redo02_II.log
redo03_II.log redo05_a.log
redo11.log redo3.log
undotbs01.dbf
redo01_II.log redo02_III.log
redo03_III.log redo05_b.log
redo12.log sysaux01.dbf users01.dbf
[oracle@oracle01 VDEDU]$ tar -zcvf
fengjiedb_VDEDU.tar.gz *
control01.ctl
example01.dbf
redo01.log
redo01_II.log
redo01_III.log
redo02.log
redo02_II.log
redo02_III.log
redo03.log
redo032_III.log
redo03_II.log
redo03_III.log
redo04_a.log
redo04_b.log
redo05_a.log
redo05_b.log
redo0_III.log
redo1.log
redo11.log
redo12.log
redo13.log
redo2.log
redo3.log
sysaux01.dbf
system01.dbf
temp01.dbf
undotbs01.dbf
users01.dbf
[oracle@oracle01 VDEDU]$ cd
$ORACLE_HOME/dbs
[oracle@oracle01 dbs]$ ls
hc_VDEDU.dat init.ora lkVDEDU
orapwVDEDU spfileVDEDU.ora
[oracle@oracle01 dbs]$ strings
spfileVDEDU.ora
VDEDU.__db_cache_size=1409286144
VDEDU.__java_pool_size=16777216
VDEDU.__large_pool_size=16777216
VDEDU.__oracle_base='/u01/app/
oracle'#ORACLE_BASE set from environment
VDEDU.__pga_aggregate_target=637534208
VDEDU.__sga_target=1895825408
VDEDU.__shared_io_pool_size=0
VDEDU.__shared_pool_size=419430400
VDEDU.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/
admin/VDEDU/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/
oradata/VDEDU/cont
rol01.ctl','/u01/app/oracle/
fast_recovery_area/VDEDU/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='VDEDU'
*.db_recovery_file_dest='/u01/app/
oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=VDEDUXDB)'
*.open_cursors=300
*.pga_aggregate_target=627048448
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1881145344
*.undo_tablespace='UNDOTBS1'
[oracle@oracle01 dbs]$ scp
spfileVDEDU.ora 192.168.1.58:~
The authenticity of host '192.168.1.58
(192.168.1.58)' can't be established.
RSA key fingerprint is a3:ae:94:8b:2d:
67:bb:4a:04:8e:6f:a0:7b:e4:fe:c2.
Are you sure you want to continue
connecting (yes/no)? yes
Warning: Permanently added
'192.168.1.58' (RSA) to the list of
known hosts.
reverse mapping checking getaddrinfo for
bogon [192.168.1.58] failed - POSSIBLE
BREAK-IN ATTEMPT!
oracle@192.168.1.58's password:
spfileVDEDU.ora
100% 2560 2.5KB/s 00:00
[oracle@oracle01 dbs]$ cd
[oracle@oracle01 ~]$ ls
1.168.192.rev Desktop Documents
Downloads Music Pictures Public
Templates Videos hailiang.org.zone
[oracle@oracle01 ~]$ cd /u01/app/oracle/
oradata/VDEDU/
[oracle@oracle01 VDEDU]$ ls
control01.ctl redo01_III.log
redo032_III.log redo05_a.log
redo12.log system01.dbf
example01.dbf redo02.log
redo03_II.log redo05_b.log
redo13.log temp01.dbf
fengjiedb_VDEDU.tar.gz redo02_II.log
redo03_III.log redo0_III.log
redo2.log undotbs01.dbf
redo01.log redo02_III.log
redo04_a.log redo1.log
redo3.log users01.dbf
redo01_II.log redo03.log
redo04_b.log redo11.log
sysaux01.dbf
[oracle@oracle01 VDEDU]$ scp
fengjiedb_VDEDU.tar.gz 192.168.1.58:~
reverse mapping checking getaddrinfo for
bogon [192.168.1.58] failed - POSSIBLE
BREAK-IN ATTEMPT!
oracle@192.168.1.58's password:
fengjiedb_VDEDU.tar.gz
100% 345MB 424.1KB/s 13:53
[oracle@oracle01 VDEDU]$ ssh
192.168.1.58
reverse mapping checking getaddrinfo for
bogon [192.168.1.58] failed - POSSIBLE
BREAK-IN ATTEMPT!
oracle@192.168.1.58's password:
Last login: Fri Jun 29 15:46:06 2018
from 192.168.1.68
[oracle@linux ~]$
[oracle@linux ~]$
[oracle@linux ~]$
[oracle@linux ~]$ ifconfig
bridge0 Link encap:Ethernet HWaddr
F6:5A:A4:2F:A5:6C
inet6 addr:
fe80::f45a:a4ff:fe2f:a56c/64 Scope:Link
UP BROADCAST RUNNING MULTICAST
MTU:1500 Metric:1
RX packets:0 errors:0 dropped:
0 overruns:0 frame:0
TX packets:13 errors:0
dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:0 (0.0 b) TX bytes:
2358 (2.3 KiB)
eth1 Link encap:Ethernet HWaddr
00:0C:29:0A:F9:15
inet addr:192.168.80.146
Bcast:192.168.80.255 Mask:255.255.255.0
inet6 addr: fe80::20c:
29ff:fe0a:f915/64 Scope:Link
UP BROADCAST RUNNING MULTICAST
MTU:1500 Metric:1
RX packets:746 errors:0
dropped:0 overruns:0 frame:0
TX packets:666 errors:0
dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:122361 (119.4 KiB)
TX bytes:101492 (99.1 KiB)
eth2 Link encap:Ethernet HWaddr
00:0C:29:0A:F9:1F
inet addr:192.168.1.58 Bcast:
192.168.1.255 Mask:255.255.255.0
inet6 addr: fe80::20c:
29ff:fe0a:f91f/64 Scope:Link
UP BROADCAST RUNNING MULTICAST
MTU:1500 Metric:1
RX packets:402184 errors:0
dropped:0 overruns:0 frame:0
TX packets:61268 errors:0
dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:399645279 (381.1 MiB)
TX bytes:5249905 (5.0 MiB)
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:
255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:65536
Metric:1
RX packets:382233 errors:0
dropped:0 overruns:0 frame:0
TX packets:382233 errors:0
dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:77739991 (74.1 MiB)
TX bytes:77739991 (74.1 MiB)
[oracle@linux ~]$ ls
1..hhh Desktop Music Templates
addm01.txt fengjiedb_VDEDU.tar.gz
spfileVDEDU.ora
1.sal Documents Pictures
VDEDU_02t4k73b awr_01.html
p13390677_112040_Linux-x86-64_1of7.zip
text.sql
1.txt Downloads Public Videos
database p13390677_112040_Linuxx86-64_2of7.zip tzt
[oracle@linux ~]$ cp spfileVDEDU.ora
$ORACLE_HOME/dbs/
[oracle@linux ~]$ mkdir -p /u01/app/
oracle/oradata/VDEDU
[oracle@linux ~]$ mv
fengjiedb_VDEDU.tar.gz /u01/app/oracle/
oradata/VDEDU
[oracle@linux ~]$ cd /u01/app/oracle/
oradata/VDEDU
[oracle@linux VDEDU]$ tar -zxvf
control01.ctl redo01.log
sysaux01.dbf undotbs01.dbf
example01.dbf redo02.log
system01.dbf users01.dbf
fengjiedb_VDEDU.tar.gz redo03.log
temp01.dbf
[oracle@linux VDEDU]$ tar -zxvf
control01.ctl redo01.log
sysaux01.dbf undotbs01.dbf
example01.dbf redo02.log
system01.dbf users01.dbf
fengjiedb_VDEDU.tar.gz redo03.log
temp01.dbf
[oracle@linux VDEDU]$ cd ..
[oracle@linux oradata]$ ls
VDEDU testdb vdedu
[oracle@linux oradata]$ cd VDEDU
[oracle@linux VDEDU]$ ls
control01.ctl fengjiedb_VDEDU.tar.gz
redo02.log sysaux01.dbf temp01.dbf
users01.dbf
example01.dbf redo01.log
redo03.log system01.dbf undotbs01.dbf
[oracle@linux VDEDU]$ rm control01.ctl
[oracle@linux VDEDU]$ ll
total 2514028
-rw-r-----. 1 oracle oinstall 363077632
May 30 14:47 example01.dbf
-rw-r--r-- 1 oracle oinstall 361792011
Jul 3 16:31 fengjiedb_VDEDU.tar.gz
-rw-r-----. 1 oracle oinstall 52429312
May 30 09:39 redo01.log
-rw-r-----. 1 oracle oinstall 52429312
May 30 09:39 redo02.log
-rw-r-----. 1 oracle oinstall 52429312
May 30 09:39 redo03.log
-rw-r-----. 1 oracle oinstall 765468672
May 30 14:47 sysaux01.dbf
-rw-r-----. 1 oracle oinstall 807411712
May 30 14:47 system01.dbf
-rw-r-----. 1 oracle oinstall 30416896
May 30 09:39 temp01.dbf
-rw-r-----. 1 oracle oinstall 104865792
May 30 14:47 undotbs01.dbf
-rw-r-----. 1 oracle oinstall 9183232
May 30 14:47 users01.dbf
[oracle@linux VDEDU]$ rm -rf redo*
[oracle@linux VDEDU]$ rm -rf *.dbf
[oracle@linux VDEDU]$ ls
fengjiedb_VDEDU.tar.gz
[oracle@linux VDEDU]$ ls
fengjiedb_VDEDU.tar.gz
[oracle@linux VDEDU]$ tar -zxvf
fengjiedb_VDEDU.tar.gz
control01.ctl
tar: control01.ctl: time stamp
2018-07-03 22:33:18 is 21496.7191918 s
in the future
example01.dbf
tar: example01.dbf: time stamp
2018-07-03 22:33:18 is 21492.35496826 s
in the future
redo01.log
tar: redo01.log: time stamp 2018-07-03
17:23:01 is 2866.531015879 s in the
future
redo01_II.log
tar: redo01_II.log: time stamp
2018-07-03 17:23:01 is 2855.432731105 s
in the future
redo01_III.log
redo02.log
redo02_II.log
redo02_III.log
redo03.log
redo032_III.log
redo03_II.log
redo03_III.log
redo04_a.log
tar: redo04_a.log: time stamp 2018-07-03
17:26:07 is 3024.070369069 s in the
future
redo04_b.log
tar: redo04_b.log: time stamp 2018-07-03
17:26:07 is 3019.481967258 s in the
future
redo05_a.log
tar: redo05_a.log: time stamp 2018-07-03
17:26:18 is 3025.859787252 s in the
future
redo05_b.log
tar: redo05_b.log: time stamp 2018-07-03
17:26:18 is 3025.481284972 s in the
future
redo0_III.log
redo1.log
tar: redo1.log: time stamp 2018-07-03
17:37:42 is 3708.37442985 s in the
future
redo11.log
tar: redo11.log: time stamp 2018-07-03
17:27:38 is 3099.920076112 s in the
future
redo12.log
tar: redo12.log: time stamp 2018-07-03
17:35:20 is 3552.591403777 s in the
future
redo13.log
tar: redo13.log: time stamp 2018-07-03
17:25:24 is 2946.096180757 s in the
future
redo2.log
tar: redo2.log: time stamp 2018-07-03
22:33:18 is 21417.900193225 s in the
future
redo3.log
tar: redo3.log: time stamp 2018-07-03
17:35:06 is 3521.730079294 s in the
future
sysaux01.dbf
tar: sysaux01.dbf: time stamp 2018-07-03
22:33:18 is 21363.091168283 s in the
future
system01.dbf
tar: system01.dbf: time stamp 2018-07-03
22:33:18 is 21327.527604683 s in the
future
temp01.dbf
tar: temp01.dbf: time stamp 2018-07-03
22:27:46 is 20994.172946383 s in the
future
undotbs01.dbf
tar: undotbs01.dbf: time stamp
2018-07-03 22:33:18 is 21308.367793008 s
in the future
users01.dbf
tar: users01.dbf: time stamp 2018-07-03
22:33:18 is 21308.332196435 s in the
future
[oracle@linux VDEDU]$ ls
control01.ctl redo01_III.log
redo032_III.log redo05_a.log
redo12.log system01.dbf
example01.dbf redo02.log
redo03_II.log redo05_b.log
redo13.log temp01.dbf
fengjiedb_VDEDU.tar.gz redo02_II.log
redo03_III.log redo0_III.log
redo2.log undotbs01.dbf
redo01.log redo02_III.log
redo04_a.log redo1.log
redo3.log users01.dbf
redo01_II.log redo03.log
redo04_b.log redo11.log
sysaux01.dbf
[oracle@linux VDEDU]$ cd $ORACLE_HOME/
dbs
[oracle@linux dbs]$ strings
spfileVDEDU.ora
VDEDU.__db_cache_size=1409286144
VDEDU.__java_pool_size=16777216
VDEDU.__large_pool_size=16777216
VDEDU.__oracle_base='/u01/app/
oracle'#ORACLE_BASE set from environment
VDEDU.__pga_aggregate_target=637534208
VDEDU.__sga_target=1895825408
VDEDU.__shared_io_pool_size=0
VDEDU.__shared_pool_size=419430400
VDEDU.__streams_pool_size=16777216
*.audit_file_dest='/u01/app/oracle/
admin/VDEDU/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/
oradata/VDEDU/cont
rol01.ctl','/u01/app/oracle/
fast_recovery_area/VDEDU/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='VDEDU'
*.db_recovery_file_dest='/u01/app/
oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP)
(SERVICE=VDEDUXDB)'
*.open_cursors=300
*.pga_aggregate_target=627048448
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1881145344
*.undo_tablespace='UNDOTBS1'
[oracle@linux dbs]$ export
ORACLE_SID=VDEDU
[oracle@linux dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production
on Tue Jul 3 16:42:30 2018
Copyright (c) 1982, 2013, Oracle. All
rights reserved.
Connected to an idle instance.
SYS@VDEDU> create pfile from spfile;
File created.
SYS@VDEDU> quit
Disconnected
[oracle@linux dbs]$ vi initVDEDU.ora
[oracle@linux dbs]$ mkdir -p /u01/app/
oracle/admin/VDEDU/adump
[oracle@linux dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production
on Tue Jul 3 16:43:28 2018
Copyright (c) 1982, 2013, Oracle. All
rights reserved.
Connected to an idle instance.
SYS@VDEDU> create spfile from pfile;
File created.
SYS@VDEDU> startup
ORACLE instance started.
Total System Global Area 1887350784
bytes
Fixed Size 2254344 bytes
Variable Size 503319032 bytes
Database Buffers 1375731712 bytes
Redo Buffers 6045696 bytes
Database mounted.
ORA-01092: ORACLE instance terminated.
Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with
UPGRADE option
Process ID: 73083
Session ID: 1 Serial number: 5
SYS@VDEDU>
SYS@VDEDU> shutdown abort
ORA-24324: service handle not
initialized
ORA-01041: internal error. hostdef
extension doesn't exist
SYS@VDEDU> quit
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@linux dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production
on Tue Jul 3 16:45:36 2018
Copyright (c) 1982, 2013, Oracle. All
rights reserved.
Connected to an idle instance.
SYS@VDEDU> startup upgrade;
ORACLE instance started.
Total System Global Area 1887350784
bytes
Fixed Size 2254344 bytes
Variable Size 503319032 bytes
Database Buffers 1375731712 bytes
Redo Buffers 6045696 bytes
Database mounted.
Database opened.
SYS@VDEDU> @?/rdbms/admin/catupgrd.sql