oracle 操作实例(一)----redolog 损坏恢复
发布时间:2020-12-12 13:18:50 所属栏目:百科 来源:网络整理
导读:一,实验前的准备 数据库全备 vim full .shexport ORACLE_BASE =/ u01 / app / oracleexport ORACLE_HOME = $ORACLE_BASE / product / 11.2 / db_1export ORACLE_SID = procexport NLS_LANG = AMERICAN_AMERICA.ZHS16GBKexport PATH = $ORACLE_HOME / bin:$PA
一,实验前的准备数据库全备 vim full.sh export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/11.2/db_1 export ORACLE_SID=proc export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export PATH=$ORACLE_HOME/bin:$PATH rman target / log /u01/backup/rman_full.log append<<EOF run {allocate channel c1 type disk; allocate channel c2 type disk; backup database filesperset 4 format ‘/u01/backup/full_%d_%T_%s_%p‘; sql ‘alter system archive log current‘; sql ‘alter system archive log current‘; sql ‘alter system archive log current‘; backup archivelog all format ‘/u01/backup/arch_%d_%T_%s_%p‘ delete input; backup current controlfile format ‘/u01/backup/ctl_%d_%T_%s_%p‘; crosscheck backup; crosscheck archivelog all; delete noprompt obsolete; delete noprompt expired backup; delete noprompt expired archivelog all; } EOF 查看日志组的状态 size_MB,members,archived,status,first_change#,to_char(FIRST_TIME,‘yyyy-mm-dd hh24:mi:ss‘) first_time from v$log; 日志文件位置 SELECT group#,member FROM v$logfile; 记录下来: 开始破坏 第一步,关闭数据库 第二步,删除或者移动一个rodo日志. 二,恢复启动数据库报错
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |