ORACLE备份&恢复案例

核心提示： 联机日志：SQL> select * from v$logfile;GROUP# STATUS MEMBER-- --- 1 STALE D:ORACLEORADATATESTREDO01.LOG2 D:ORACLEORADATATESTREDO02.LOG3 STALE D:ORA

联机日志：

SQL> select * from v$logfile;
GROUP# STATUS MEMBER
---------- ------- --------------------------------------------------------------------------------
1 STALE D:ORACLEORADATATESTREDO01.LOG
2 D:ORACLEORADATATESTREDO02.LOG
3 STALE D:ORACLEORADATATESTREDO03.LOG

2.2 数据库备份脚本

冷备份脚本

rem script:coldbak.sql
rem creater:chenjiping
rem date:5.8.2003
rem desc:offline full backup database
--connect database
connect internal/password;
--shutdown database
shutdown immediate;
--Copy Data file
!xcopy d:oracleoradatatest*.dbf d:database/H/R;
--Copy Control file
!xcopy d:oracleoradatatest*.ctl d:database/H/R;
--Copy Log file
!xcopy d:oracleoradatatest*.log d:database/H/R;
--startup database
startup;

说明：

1、以上脚本在数据库关闭状态下备份数据库所有的数据文件，联机日志，控制文件（在一个目录下），如果成功备份，所有文件是一致的。

2、没有备份参数文件，参数文件可以另外备份，没有必要每次都备份，只需要在改变设置后备份一次。

3、如果以上命令没有成功依次执行，那么备份将是无效的，如连接数据库不成功，那么肯定关闭数据库也不成功，那么备份则无效

4、冷备份建议下人工干预下执行。

数据库OS热全备份脚本

rem script:hotbak.sql
rem creater:chenjiping
rem date:5.8.2003
rem desc:backup all database datafile in archive
--connect database
connect internal/password;
--archive
alter system archive log current;
--start
alter tablespace system begin backup;
!xcopy d:oracleoradatatestsystem01.dbf d:databak/H/R;
alter tablespace system end backup;
alter tablespace rbs begin backup;
!xcopy d:oracleoradatatestrbs01.dbf d:databak/H/R;
alter tablespace rbs end backup;
alter tablespace users begin backup;
!xcopy d:oracleoradatatestusers01.dbf d:databak/H/R;
alter tablespace users end backup;
alter tablespace tools begin backup;
!xcopy d:oracleoradatatesttools01.dbf d:databak/H/R;
alter tablespace tools end backup;
alter tablespace indx begin backup;
!xcopy d:oracleoradatatestindx01.dbf d:databak/H/R;
alter tablespace indx end backup;
--end
--bak control file
--binary
alter database backup controlfile to 'd:databakcontrolbinbak.000';
--ascii
alter database backup controlfile to trace;
alter system archive log current;