1.關閉資料庫
SYS@PROD>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
2.退出
SYS@PROD>exit
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.
3.對資料庫進行冷備
[oracle@edbjr2p1 ~]$ cd $ORACLE_BASE/oradata/PROD
[oracle@edbjr2p1 PROD]$ tar -cvf PROD.tar *
disk1/
disk1/USER_01.dbf
disk1/redo04_a.log
disk1/EXAMPLE.dbf
disk1/temp01.dbf
disk1/undotbs01.dbf
disk1/OLTP_01.dbf
disk1/redo01a.log
disk1/TOOLS_01.dbf
disk1/redo05_a.log
disk1/control01.ctl
disk1/TEMP1_01.dbf
disk1/INDX_01.dbf
disk1/redo03b.log
disk1/redo02b.log
disk1/sysaux01.dbf
disk2/
disk2/redo02_b.log
disk2/redo01_b.log
disk2/redo05_b.log
disk2/redo03_b.log
disk2/control02.ctl
disk2/redo04_b.log
disk2/TEMP2_01.dbf
disk3/
disk3/control03.ctl
disk4/
disk5/
system01.dbf