Database Software

Hi,

I backuped my database (10.2.0.3) using RMAN on tape via Netbackup agent (6.5). I used controlfile as RMAN repository, no RMAN catalog!
Here's my backup's script:


RUN {
allocate channel ch01 type 'SBT_TAPE';
send 'NB_ORA_POLICY=ORACLE_HISTO,NB_ORA_SERV=backupserver';
BACKUP AS COMPRESSED BACKUPSET DATABASE TAG 'bck_test';
RELEASE CHANNEL ch01;
}

Controlfile autobackup is ON !

I checked that there are good backups of controlfile:

RMAN> list backup of controlfile;

using target database control file instead of recovery catalog

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

BS Key Type LV Size Device Type Elapsed Time Completion Time

2 Full 512.00K SBT_TAPE 00:00:42 19.08.09
BP Key: 2 Status: AVAILABLE Compressed: YES Tag: BCK_TEST_NETBACKUP
Handle: bk_test_full_4_1_695317728 Media: /oraclehisto/pre-idbhistoglz
Control File Included: Ckp SCN: 595742 Ckp time: 19.08.09

BS Key Type LV Size Device Type Elapsed Time Completion Time

4 Full 512.00K SBT_TAPE 00:00:42 20.08.09
BP Key: 4 Status: AVAILABLE Compressed: YES Tag: BCK_TEST_NETBACKUP
Handle: 06kn5gib_1_1 Media: /oraclehisto/pre-idbhistoglz_1250758709_C1
Control File Included: Ckp SCN: 597186 Ckp time: 20.08.09

BS Key Type LV Size Device Type Elapsed Time Completion Time

5 Full 7.00M SBT_TAPE 00:00:41 20.08.09
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090820T105907
Handle: 07kn5gjs_1_1 Media: /oraclehisto/pre-idbhistoglz_1250758755_C1
Control File Included: Ckp SCN: 597210 Ckp time: 20.08.09
-----

Next, I simulated a lost of all controlfiles. (I deleted the controlfiles)
I tried to restore controlfile from Netbackup but it didn't work:

rman target /
set dbid 1993382391;
startup nomount;
run {
allocate channel c1 type 'SBT_TAPE';
send 'NB_ORA_POLICY=ORACLE_HISTO,NB_ORA_SERV=backupserver';
restore controlfile from autobackup maxdays=2;
}
2> 3> 4> 5> 6>
allocated channel: c1
channel c1: sid=75 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

sent command to channel: c1

Starting restore at 20.08.09

channel c1: looking for autobackup on day: 20090820
channel c1: looking for autobackup on day: 20090819
channel c1: no autobackup in 2 days found
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/20/2009 11:28:50
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


My question: is it possible to restore controlfile from netbackup when using controlfile as RMAN repository ???
If yes, could someone helps me ?

Thanks in advance,

Yann