piece 1
piece handle=bk_10_1_753725520 tag=HOT_DB_BK_LEVEL0
channel ch00: restore complete, elapsed time: 00:01:05
Finished restore at 19-JUN-11
Starting recover at 19-JUN-11
starting media recovery
channel ch00: starting archive log restore to default destination
channel ch00: restoring archive log
archive log thread=1 sequence=12
channel ch00: reading from backup piece al_14_1_753725861
channel ch00: restored backup piece 1
piece handle=al_14_1_753725861 tag=TAG20110613T161737
channel ch00: restore complete, elapsed time: 00:01:06
channel ch00: starting archive log restore to default destination
channel ch00: restoring archive log
archive log thread=1 sequence=11
channel ch00: reading from backup piece al_13_1_753725861
channel ch00: restored backup piece 1
piece handle=al_13_1_753725861 tag=TAG20110613T161737
channel ch00: restore complete, elapsed time: 00:01:05
archive log filename=/u07/test/arch/1_11_753371123.dbf thread=1 sequence=11
archive log filename=/u07/test/arch/1_12_753371123.dbf thread=1 sequence=12
archive log filename=/u07/test/arch/1_13_753371123.dbf thread=1 sequence=13
media recovery complete, elapsed time: 00:00:05
Finished recover at 19-JUN-11
released channel: ch00
RMAN> exit
Recovery Manager complete.
oracle@sg2as059:/u01/app/oracle> sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jun 19 00:07:11 2011
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
SQL>
SQL> exit
【Trouble shooting】
一、恢复时，如果用parms来传递环境变量时会报错sbtinfo2，解决方法是用send，而不是parms：
RMAN> run
2> {
allocate channel t1 type 'SBT_TAPE'
parms="ENV=(NB_ORA_SERV= sg2ts001)";
restore spfile from 'bk_12_1_753725761';
release channel ch00;
}3> 4> 5> 6> 7>
allocated channel: t1
channel t1: sid=36 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
Starting restore at 16-JUN-11
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/16/2011 17:47:30
ORA-27191: sbtinfo2 returned error
Additional information: 2
RMAN>
二、恢复spfile时，如果用from autobackup，会挂死，NBU找磁带会非常慢。该rman的等待事件是sbtinfo2。解决方法是指明from某个备份集文件，这就要到备份的log中去找了。
RMAN> run
2> {
allocate channel t1 type 'SBT_TAPE';
restore spfile from autobackup;
release channel t1;
}3> 4> 5> 6>
allocated channel: t1
channel t1: sid=36 devtype=SBT_TAPE
channel t1: VERITAS NetBackup for Oracle - Release 6.0 (2006031019)
Starting restore at 14-JUN-11
channel t1: looking for autobackup on day: 20110614
^C
user interrupt received
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command a