生产环境恢复脚本

[oraprod@db01 archivelog ]$ rman target / nocatalog

Recovery Manager: Release 11.1.0.7.0 - Production on Sat Nov 3 16:35:49 2012

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

connected to target database: PROD (DBID=109431336)
using target database control file instead of recovery catalog

RMAN> @res_arc.rcvyzz1103

RMAN> run
2> {
3> allocate channel c1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> restore archivelog from logseq 5019 until logseq 5023 thread 1;
5> release channel c1;
6> }
allocated channel: c1
channel c1: SID=2670 instance=PROD1 device type=SBT_TAPE
channel c1: Data Protection for Oracle: version 5.4.1.0

Starting restore at 03-NOV-12

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=5019
channel c1: restoring archived log
archived log thread=1 sequence=5020
channel c1: restoring archived log
archived log thread=1 sequence=5021
channel c1: restoring archived log
archived log thread=1 sequence=5022
channel c1: reading from backup piece /arch_23996_1/
channel c1: piece handle=/arch_23996_1/ tag=TAG20121103T032506
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:05
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=5023
channel c1: reading from backup piece /arch_23999_1/
channel c1: piece handle=/arch_23999_1/ tag=TAG20121103T032506
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:07
Finished restore at 03-NOV-12

released channel: c1

RMAN> **end-of-file**

RMAN>