Re: Restore SPFILE failed

On Oct 18, 5:28 pm, Jerome Vitalis
<vitalismanN05..._at_gmail.com.invalid> wrote:
> On Thu, 18 Oct 2007 20:39:15 +0000, jackzhunj wrote:
> > RMAN> restore spfile to '/tmp/test' from autobackup;
>
> > Starting restore at 18-OCT-07
> > allocated channel: ORA_DISK_1
> > channel ORA_DISK_1: sid=36 devtype=DISK
>
> > autobackup search outside recovery area not attempted because DBID was
> > not set
>
> You haven't set the DBID this time. Could you try again with the DBID set?
>
> But it does not seem to be the real cause of the problem. Please post the
> result of "show all;" after opening the database.

restart the db after restore the spfile:

RMAN> show all;

using target database control file instead of recovery catalog RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 8 G; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/apps/oracle/product/10.2/dbs/ snapcf_testdb.f'; # default Received on Fri Oct 19 2007 - 08:41:49 CDT