您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

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

2024/4/7 14:40:07发布13次查看
恢复归档日志:select * from v$log_history t where t.thread#=
恢复归档日志: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;}

该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product