tianzhig 发表于 2018-9-12 09:21:05

oracle 11g下冷备数据库

  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.对数据库进行冷备
  $ cd $ORACLE_BASE/oradata/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

页: [1]
查看完整版本: oracle 11g下冷备数据库