ITPub博客

首页 > 数据库 > Oracle > legato recover arch

legato recover arch

原创 Oracle 作者:shihfa 时间:2016-04-18 08:46:42 0 删除 编辑
账务数据库
恢复第一节点 的126204-126208 归档日志,恢复第二节点93039-93043的归档日志
zwdb1$[/oracle]rman target /                                                                                                                                                                                   

Recovery Manager: Release 10.2.0.5.0 - Production on Sun Apr 17 15:58:06 2016

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ZWDB (DBID=3216324126)

RMAN> run {
2> allocate channel t1 type 'SBT_TAPE';
3> send 'NSR_ENV=(NSR_SERVER=legato-server-ibm3650,NSR_DATA_VOLUME_POOL=zwdbvtl)';
4> restore archivelog from logseq 126204  until logseq 126208 thread 1;
5> release channel t1;
6> }

using target database control file instead of recovery catalog
allocated channel: t1
channel t1: sid=4725 instance=zwdb1 devtype=SBT_TAPE
channel t1: NMDA Oracle v1.1.0

sent command to channel: t1

Starting restore at 20160417155832

channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=126206
channel t1: restoring archive log
archive log thread=1 sequence=126207
channel t1: restoring archive log
archive log thread=1 sequence=126208
channel t1: reading from backup piece zwdb_arch_62690_1
channel t1: restored backup piece 1
piece handle=zwdb_arch_62690_1 tag=TAG20160417T054531
channel t1: restore complete, elapsed time: 00:02:06
channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=126204
channel t1: restoring archive log
archive log thread=1 sequence=126205
channel t1: reading from backup piece zwdb_arch_62697_1
channel t1: restored backup piece 1
piece handle=zwdb_arch_62697_1 tag=TAG20160417T054531
channel t1: restore complete, elapsed time: 00:02:16
Finished restore at 20160417160303

released channel: t1

RMAN> run {
2> allocate channel t1 type 'SBT_TAPE';
3> send 'NSR_ENV=(NSR_SERVER=legato-server-ibm3650,NSR_DATA_VOLUME_POOL=zwdbvtl)';
4> restore archivelog from logseq 93039  until logseq 93043 thread 2;
5> release channel t1;
6> }

allocated channel: t1
channel t1: sid=4725 instance=zwdb1 devtype=SBT_TAPE
channel t1: NMDA Oracle v1.1.0

sent command to channel: t1

Starting restore at 20160417160444

channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=2 sequence=93039
channel t1: restoring archive log
archive log thread=2 sequence=93040
channel t1: restoring archive log
archive log thread=2 sequence=93041
channel t1: reading from backup piece zwdb_arch_62694_1
channel t1: restored backup piece 1
piece handle=zwdb_arch_62694_1 tag=TAG20160417T054531
channel t1: restore complete, elapsed time: 00:04:16
channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=2 sequence=93042
channel t1: restoring archive log
archive log thread=2 sequence=93043
channel t1: reading from backup piece zwdb_arch_62695_1
channel t1: restored backup piece 1
piece handle=zwdb_arch_62695_1 tag=TAG20160417T054531
channel t1: restore complete, elapsed time: 00:02:16
Finished restore at 20160417161126

released channel: t1


##
备份软件用的legato
记住磁带要放在正常状态的driver上 服务模式的不行哦

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26179376/viewspace-2083101/,如需转载,请注明出处,否则将追究法律责任。

上一篇: HPUX VG
下一篇: DSG error ORA-01438
请登录后发表评论 登录
全部评论

注册时间:2013-11-05

  • 博文量
    62
  • 访问量
    57120