备份和恢复笔记.docVIP

备份前的准备 启动数据库到mount 修改archive模式（alter database archivelog; ） 启动到open 打开raman 连接数据库（connect target /） 然后进行备份 2、 全备份（backup database） 0级分量备份（backup incremental level 0 database） 3、 Archivelog的备份（backup database plus archivelog delete input;） 表空间的备份（backup tablespace 表空间） 控制文件的备份（backup current controlfile/backup database include current controlfile） 4、 批命令备份 （callocate channel cha1 type disk; backup format “路径” tag 标签名称 database; release channel cha1; ） 5、 自动备份 run { allocate channel c1 type disk; backup incremental level 1 format /u01/rmanbak/inc0_%u_%T tag monday_inc1 database; release channel c1 ~ [root@db-oracle ~]# crontab -e -u Oracle 45 23 * * 0 rman target/ msglog=bakl0.log cmdfile=bakl0 45 23 * * 1 rman target/ msglog=bakl2.log cmdfile=bakl2 45 23 * * 2 rman target/ msglog=bakl2.log cmdfile=bakl2 45 23 * * 3 rman target/ msglog=bakl1.log cmdfile=bakl1 45 23 * * 4 rman target/ msglog=bakl2.log cmdfile=bakl2 45 23 * * 5 rman target/ msglog=bakl2.log cmdfile=bakl2 45 23 * * 6 rman target/ msglog=bakl2.log cmdfile=bakl2 再启动service crond restart就可以了 6、 备份控制文件 Dbid= 1273224634 示例： startup failed: ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file /u01/app/Oracle/product/10.2.0/db_1/dbs/initorcl.ora starting Oracle instance without parameter file for retrival of spfile Oracle instance started Total System Global Area 159383552 bytes Fixed Size 1218268 bytes Variable Size bytes Database Buffers 100663296 bytes Redo Buffers 2973696 bytes RMAN set dbid 1273224634 executing command: SET DBID RMAN restore spfile from /u01/app/Oracle/flash_recovery_area/ORCL/autoback RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ===========================================================