RMAN 9i and controlfile autobackups

I've been using rman and legato single server version to do backups to tape.

The problem I've been having is restoring the controlfile from autobackup.

I use

configure controlfile autobackup format for device type sbt to '%F';

... to configure the format. That seems to work, 1 but have also tried

configure controlfile autobackup format for device type 'SBT_TAPE' to '%F';

I have a test instance I've been using to test my backups. What I've tried is to shutdown the instance using shutdown immediate, the statup nomount (using the spfile) or starup nomount pfile=c:\init.ora,

Then in RMAN

connect target system/manager_at_dev

set dbid 999999
run
{
alllocate channel t1 type sbt;
restore controlfile from autobackup;
}

It allocates the channell (or seems to) and gets to

channel t1: looking for autobackup on day: 20030327

... and hangs there. If I look in legato networker, I can see that
its not reading the tape or asking for other volumnes.

However if i ctrl-c the go backup into rman:

rman target=system/manager_at_dev rman/rman_at_rmn
... and then run:

run
{
allocate channel t1 type sbt;
restore controlfile;
}

...that works, and I can restore and recover the instance with no problems. And from looking in networker, it appears to be using the latest controlfile autobackup to do the restore.

I've tried a few variations on the procedure, including using startup force nomount
in rman after connecting to the target, and making sure the init.ora uses at least 10m for the large pool, but with no luck.

Any help / input / ideas would be greatly appreciated. Received on Thu Mar 27 2003 - 20:59:54 CST