Oracle的备份与恢复

完全备份\n\nbackup database;\n\n设置RMAN自动备份控制文件\n\nconfigure controlfile autobackup on;\n\n查看备份\n\nlist backup;\n\n模拟故障\n\ncd $ORACEL_HOME/dbsrm -rf *\n\ncd $ORACLE_BASE/oradata/xe/rm -rf *\n\n恢复参数文件\n\nstartup nomount pfile='$ORACLE_BASE/admin/\n\n数据库实例\n\n/pfile/init.ora';\n\nDBID需同原始库相同set dbid=数据库DBIDrestore spfile from autobackup;\n\n恢复控制文件\n\nrestore controlfile from autobackup;\n\n恢复数据文件\n\nrestore database;\n\n还原数据库\n\nrecover database;\n\n打开数据库resetlogs：复位日志序列号，并生成新的数据库副本。\n\nalter database open resetlogs;\n\n重建密码文件\n\norapwd file=$ORACLE_HOME/dbs/orapwdxe password=oracle entries=5;\n\n联机重做日志文件\n\nselect member form v$logfile;