Date: Jun 2009
Product & Version: NVBU 8.x
OS Version: Any
Module & Version: Oracle APM 5.x
Application version: Oracle Any
Symptoms:
When using a CLI restore of an autobackup controlfile to a new server with no catalog the restore fails after searching 7 days of history:
RMAN> restore controlfile from autobackup;
NetVault --- MMS SBT sbtinit method.
NetVault --- SBT sbtinit2
allocated channel: c1
channel c1: sid=156 devtype=SBT_TAPE
channel c1: NetVault Oracle APM v.6.0.17
Starting restore at 24-JUN-09
channel c1: looking for autobackup on day: 20090624
channel c1: looking for autobackup on day: 20090623
channel c1: looking for autobackup on day: 20090622
channel c1: looking for autobackup on day: 20090621
channel c1: looking for autobackup on day: 20090620
channel c1: looking for autobackup on day: 20090619
channel c1: looking for autobackup on day: 20090618
channel c1: no autobackup in 7 days found
NetVault --- SBT sbtend
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/24/2009 17:42:53
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
1) check that the Oracle APM is configured to have the "CLI/Autobackup Restore taken from Netvault:Backup Client" field set to the Netvault name of original (source) client, and that the two server fields are also populated correctly.
2) check that the original backup did have autobackup controlfile configured.
3) check that there was an autobackup within the last 7 days, if the last autobackup was older then this then use the MAXDAYS parameter to increase the search window:
RMAN> restore controlfile from autobackup MAXDAYS=20;
4) if all the above are correct, edit the netvault/config/nvoracleapm.cfg file on the target client and add the following stanza:
[Oracle:DefaultBackupSourceClient]
Tab Name = Oracle APM
Tab Name Id = 109500677
Type = String
Width = 60
Label = CLI/Autobackup Restore Backup taken from NetVault: Backup Client:
Label Id = 0
Value =<source client name>
The "Value= " field should be set to the same value as the configuration parameter "CLI/Autobackup Restore taken from Netvault:Backup Client", i.e. the Netvault name of the original (source) client.
5) if all else fails the controlfile can be restored using the manual procedure described in solution 1930 "Oracle RMAN restore autobackup controlfile"
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center