-
编辑 删除
rman备份&恢复
1、rman全库备份 2、rman全库恢复[@more@]1、rman全库备份RMAN> run{2>3> allocate channel c1 type disk;4>5> backup format 'c:rmanbakfull%u_%s_%p' database6>7> include current controlfile;8>9> sql 'alter system archive log current';10>11> release channel c1;12>13> }释放的通道: ORA_DISK_1分配的通道: c1通道 c1: sid=156 devtype=DISK启动 backup 于 20-10月-07通道 c1: 启动全部数据文件备份集通道 c1: 正在指定备份集中的数据文件输入数据文件 fno=00001 name=D:ORACLEPRODUCT1
-
编辑 删除
windows下oracle热备份
要实现在线热备必须将数据库置与归档模式下，当数据库置于归档模式后通过手动拷贝或windows命令xcopy将%oracle_home%oradata(SID)下所有contorlfile、datafile、redolog备份到指定备份目录。[@more@]脚本实现热备份：rem script:hotbak.sqlrem creater:fengzhurem date:12.12.2007rem desc:backup all database datafile in archive--connect databaseconnect sys/admin@orcl as sysdba;--Del Data file$del E:fzbak*.dbf;--Del Control file$del E:fzbak*.ctl;--Del Log file$del E:fzbak*.log;--archivealter system archive log curren
-
编辑 删除
windows下oracle冷备份
1、手动冷备份将数据库正常shutdown后再将%oracle_home%oradata(SID)下全部的contorlfile、datafile、redolog拷贝到备份目录。[@more@]2、脚本实现冷备份编写冷备份脚本如下：rem script:coldbak.sqlrem creater:fengzhurem date:12.10.2007rem desc:offline full backup database --connect databaseconnect sys/admin@orcl as sysdba;--shutdown databaseshutdown immediate;--Copy Data file--在linux下xcopy前的$符号改改为!$xcopy D:oracleproduct10.2.0oradataorcl*.dbf E:fzbak; --Copy Control file$xcopy D:oracleproduct10.2.0o
