legato recover arch

账务数据库

恢复第一节点 的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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26179376/viewspace-2083101/