整库(whole)备份-一致性整库备份

原文地址：http://blog.itpub.net/17013648/viewspace-1151261/

备份的分类：

n  一致性备份（冷备份）

n  非一致性备份（热备份/联机备份）

 

整个库的备份（可以是一致性的，也可以是非一致性的）

表空间的备份（只能是非一致性的）

1.1 一致性整库备份（whole）

>forsys@TESTDB11selectfrom;  -------------------------------------------------------------------------------- u01apporacleoradataTestDB11control01ctl u01apporaclefast_recovery_areaTestDB11control02ctl --2. 确定数据文件sys@TESTDB11selectfrom;  -------------------------------------------------------------------------------- u01apporacleoradataTestDB11system01dbf u01apporacleoradataTestDB11sysaux01dbf u01apporacleoradataTestDB11undotbs01dbf u01apporacleoradataTestDB11users01dbf u01apporacleoradataTestDB11example01dbf u01apporacleoradataTestDB11rotbs01dbf 6rows.  oracle@S1011backupconsistent_whole$ du h u01apporacleoradataTestDB11 2.3/////  oracle@S1011$ mkdir -p pooldisk02/backup01/consistent oracle@S1011$ chown  -R oralce:onstall /pooldisk02 oracle@S1011$ chmod  -R /pooldisk02 /*******    创建备份脚本  head   feedback   verify  = = spool script_dirbackupsqlselect'!cp '||||' &backup_dir'from;select'!cp '||||' &backup_dir'from;spool  --shutdown instance immediate &/. ;  undefine script_dir  head   feedback   verify /*******    创建备份脚本******/  /export/home/oracle/backup_script/backup01.sql >/. !//////.///!//////.///  cp oradataTestDB11system01dbf backupconsistent cp oradataTestDB11sysaux01dbf backupconsistent cp oradataTestDB11undotbs01dbf backupconsistent cp oradataTestDB11users01dbf backupconsistent cp oradataTestDB11example01dbf backupconsistent cp oradataTestDB11newundotbs01dbf backupconsistent .Database dismounted .        ORACLE instance started Total System  Area   bytes Size2230792VariableSize641730040Database Buffers           bytes 2306048Database mounted .