Oracle-L: RE: auto backup and spfile restore

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Sat, 25 Jan 2003 22:48:56 -0800
Message-ID: <F001.0053A9DE.20030125224856@fatcity.com>

auto backup and spfile restoreGlad you got your problem fixed. The SPFILE's can be a source of frustration sometimes!

RF
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Chris Stephens
  Sent: Saturday, January 25, 2003 9:24 AM   To: Multiple recipients of list ORACLE-L   Subject: RE: auto backup and spfile restore

  Well, I found the problem.
  There was still a pfile in the default location.   The only entry in that pfile was 'spfile=...'   Since that spfile had been deleted, the file not found error message was returned.
  When I delete the pfile, the recovery worked as documented....

RMAN> connect target /

connected to target database (not started)

RMAN> set DBID=1370501721

executing command: SET DBID

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/9.2/dbs/initr'

trying to start the Oracle instance without parameter files ...

Oracle instance started

Total System Global Area 160918624 bytes

Fixed Size 736352 bytes

Variable Size 109051904 bytes

Database Buffers 50331648 bytes

Redo Buffers 798720 bytes

RMAN> restore spfile from autobackup

2> ;

Starting restore at 25-JAN-03

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=9 devtype=DISK

channel ORA_DISK_1: looking for autobackup on day: 20030125

channel ORA_DISK_1: looking for autobackup on day: 20030124

channel ORA_DISK_1: autobackup found: c-1370501721-20030124-06

channel ORA_DISK_1: SPFILE restore from autobackup complete

Finished restore at 25-JAN-03

RMAN> shutdown abort

Oracle instance shut down

RMAN> startup

connected to target database (not started)

Oracle instance started

database mounted

database opened

Total System Global Area 320301720 bytes

Fixed Size 735896 bytes

Variable Size 285212672 bytes

Database Buffers 33554432 bytes

Redo Buffers 798720 bytes

RMAN> thank you for the response Robert.

chris

-----Original Message-----
From: Robert Freeman [mailto:robertgfreeman_at_yahoo.com] Sent: Friday, January 24, 2003 10:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: auto backup and spfile restore

My guess is that there is a path defined in your init.ora that isn't correct. Check your alert log for more information.

      -----Original Message-----
      From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Chris
Stephens
      Sent: Friday, January 24, 2003 1:54 PM
      To: Multiple recipients of list ORACLE-L
      Subject: auto backup and spfile restore


       List,

      We are in the process of testing every recovery scenario we can think

of using rman. We don't use a catalog and controlfile autobackup is on which implies the spfile is automatically backed up.

      So one of the scenarios was to delete the spfile and pfile.
      To recover I thought we would be able to....

      (database already shutdown)
      rman
      rman>set DBID=1370501721  ---i tried switch this with the command
immediate following
      rman>connect target /
      rman>startup force nomount;  ---from what I read in the documentation
this should force oracle to use a 'dummy' spfile.
      rman>restore spfile from autobackup;

      i realize there are several other ways to handle this situation but
why can't i start the database in this way?
      the error i get is:

      RMAN> startup force nomount;

      RMAN-00571:
===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
      RMAN-00571:
===========================================================
      RMAN-03002: failure of startup command at 01/24/2003 13:37:39
      RMAN-04014: startup failed: ORA-27037: unable to obtain file status
      HP-UX Error: 2: No such file or directory
      Additional information: 3



      what gives?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Robert Freeman
INET: robertgfreeman_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Jan 26 2003 - 00:48:56 CST