Home » RDBMS Server » Backup & Recovery » RMAN-06172: no autobackup found or specified handle is not a valid copy or piece (Oracle 9i Release 2 64Bit - Production on SPARC 5.8)
icon8.gif  RMAN-06172: no autobackup found or specified handle is not a valid copy or piece [message #494522] Tue, 15 February 2011 08:04 Go to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member




I have a cataloged RMAN Backup from 2009 that I need to restore but I cannot seem to restore the particular control file from the tape using the NetBackup Media Manager (SBT_TAPE). The backup commands include the current controlfile.






morojwa:KFXTRG:/u01/app/oracle/admin/common_ksh/rmanscripts
rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: KFXPR (DBID=3575520995)

RMAN> connect catalog rman/rman@RMANDB

connected to recovery catalog database

RMAN> allocate channel for maintenance type SBT_TAPE;

allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: sid=20 devtype=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: VERITAS NetBackup for Oracle - Release 5.1 (2004043016)

RMAN> send 'NB_ORA_SERV=morojwa-mgmt, NB_ORA_CLIENT=billing-bu';

sent command to channel: ORA_MAINT_SBT_TAPE_1

RMAN> list backup of controlfile completed between '27-JUN-2009' and '29-JUN-2009';


List of Backup Sets
===================

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2834953 Incr 0 19M SBT_TAPE 01:14:37 27-JUN-09
BP Key: 2834957 Status: EXPIRED Tag: HOT_DB_BK_LEVEL0
Piece Name: bk_15947_1_690617002
Controlfile Included: Ckp SCN: 12058128470 Ckp time: 27-JUN-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2835128 Full 19M SBT_TAPE 00:00:28 27-JUN-09
BP Key: 2835129 Status: EXPIRED Tag: TAG20090627T071950
Piece Name: cntrl_15954_1_690621590
Controlfile Included: Ckp SCN: 12058130077 Ckp time: 27-JUN-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2835135 Incr 0 19M SBT_TAPE 01:15:15 28-JUN-09
BP Key: 2835139 Status: EXPIRED Tag: HOT_DB_BK_LEVEL0
Piece Name: bk_15960_1_690732757
Controlfile Included: Ckp SCN: 12058225284 Ckp time: 28-JUN-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2835285 Full 19M SBT_TAPE 00:00:28 28-JUN-09
BP Key: 2835286 Status: EXPIRED Tag: TAG20090628T152926
Piece Name: cntrl_15965_1_690737366
Controlfile Included: Ckp SCN: 12058246266 Ckp time: 28-JUN-09

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2835294 Incr 0 19M SBT_TAPE 00:24:07 28-JUN-09
BP Key: 2835310 Status: EXPIRED Tag: TAG20090628T212126
Piece Name: bk_uj3kiockt_s15971_p1_t690762397
Controlfile Included: Ckp SCN: 12058276604 Ckp time: 28-JUN-09

RMAN>

RMAN> restore controlfile to '/tmp/testcontrol' from 'cntrl_15965_1_690737366' ;

Starting restore at 15-FEB-11

using channel ORA_SBT_TAPE_1
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/15/2011 15:59:33
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

RMAN>



Unless I am missing something here. The correct tape has been loaded into the library and mouted read-only. Anybody ?
Re: RMAN-06172: no autobackup found or specified handle is not a valid copy or piece [message #494524 is a reply to message #494522] Tue, 15 February 2011 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The status is EXPIRED, this means the backup is no more there.

Regards
Michel
Re: RMAN-06172: no autobackup found or specified handle is not a valid copy or piece [message #494528 is a reply to message #494524] Tue, 15 February 2011 09:18 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

The data is still on tape is there no way I can restore it with or without the catalog database ?
Re: RMAN-06172: no autobackup found or specified handle is not a valid copy or piece [message #494530 is a reply to message #494528] Tue, 15 February 2011 09:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try crosschecking the backupset.
If RMAN really finds the file, the status should be changed to AVAILABLE in output of 'list backup'.
Previous Topic: how to apply archive on consistent backup ...
Next Topic: Block Corruption in Expdp
Goto Forum:
  


Current Time: Fri Mar 29 03:43:13 CDT 2024