Oracle集群数据库中恢复归档日志

恢复归档日志：select * from v$log_history t where t.THREAD#="1"
order by t.FIRST_TIME desc
实例1：恢复一个归档日志：
run{
allocate channel "dev_0" type "sbt_tape"
parms "SBT_LIBRARY=/opt/omni/lib/libob2Oracle8_64bit.so,
ENV=（OB2BARTYPE=Oracle8,OB2APPNAME=test,OB2BARLIST=db01）";
restore archivelog sequence 2102;
release channel dev1;}恢复多个归档日志：
run{
allocate channel "dev_0" type "sbt_tape"
parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,
ENV=（OB2BARTYPE=Oracle8,OB2APPNAME=test,OB2BARLIST=db01）";
restore archivelog sequence between 2104 and 2135;
release channel dev1;}实例2：恢复一个归档日志：select * from v$log_history t where t.THREAD#="2"
order by t.FIRST_TIME desc
run{
allocate channel "dev_0" type "sbt_tape"
parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,
ENV=（OB2BARTYPE=Oracle8,OB2APPNAME=test,OB2BARLIST=db01）";
restore archivelog sequence 2230 thread 2;
release channel dev1;}恢复多个归档日志：
run{
allocate channel "dev_0" type "sbt_tape"
parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,
ENV=（OB2BARTYPE=Oracle8,OB2APPNAME=test,OB2BARLIST=db01）";
restore archivelog sequence between 2231 and 2281 thread 2;
release channel dev1;}AIX系统的非计算内存最大值设置过大导致Oracle数据库有些不能连接上ORA-14452:问题处理相关资讯 Oracle数据库 Oracle入门教程 oracle数据库教程

Oracle数据库全球化（03月01日）
Oracle数据库日期过滤方法性能比较（02/02/2015 13:20:26）
Oracle数据库安装中端口被占用问题（10/29/2014 07:42:24）

在CentOS 6.6上搭建C++运行环境并（10/10/2015 19:44:40）
Oracle数据库无法使用localhost和（11/14/2014 16:39:10）
使用SQLT来构建Oracle测试用例（08/28/2014 06:17:41）

本文评论查看全部评论（0）