模拟丢失
select member from v$logfile where group#=1;
rm -rf /home/oracle/redo01b.log
转换日志组, 由于每组文件不唯一 不会报错(但报警日志文件会报错);
sqlplus /nolog
conn / as sysdba
alter system switch
查看报警日志文件:
cd /uo1/app/oracle/diag/rdbms/sztech1/sztech1/trace/
tail -f alert_sztech1.log
查看丢失日志文件是否在current状态
select group#,sequence#,status from v$log;
若在
alter system switch;
alter system checkpoint;
删除数据库内相关日志路径信息
alter database drop logfile menber '/home/oracle/redo01b.log';
还原日志文件
alter database add logfile member '/home/oracle/redo01b.log' to group 1;
若开启了归档 且日志文件组不在current状态
alter database clear logfile group 1;
将会自动重新生成
select member from v$logfile where group#=1;
rm -rf /home/oracle/redo01b.log
转换日志组, 由于每组文件不唯一 不会报错(但报警日志文件会报错);
sqlplus /nolog
conn / as sysdba
alter system switch
查看报警日志文件:
cd /uo1/app/oracle/diag/rdbms/sztech1/sztech1/trace/
tail -f alert_sztech1.log
查看丢失日志文件是否在current状态
select group#,sequence#,status from v$log;
若在
alter system switch;
alter system checkpoint;
删除数据库内相关日志路径信息
alter database drop logfile menber '/home/oracle/redo01b.log';
还原日志文件
alter database add logfile member '/home/oracle/redo01b.log' to group 1;
若开启了归档 且日志文件组不在current状态
alter database clear logfile group 1;
将会自动重新生成
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28889722/viewspace-1244230/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28889722/viewspace-1244230/