RE: Restoring with RMAN in nocatalog mode: spfile needed?

  • From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
  • To: <painterman@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Oct 2008 09:08:45 -0500

The spfile may be needed by the application if the restore is being done
through some type of GUI in the application.  For normal RMAN
backup/restore, the spfile is not a critical component and it's absence
would not stop you from restoring.  Having said that, including the
spfile in the backup is trivial and doesn't take up much space.

- Chris

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Pintor
Sent: Monday, October 06, 2008 8:55 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Restoring with RMAN in nocatalog mode: spfile needed?

Hi list,

-- Oracle
-- Solaris 8
-- Commvault 7.0

I have an Oracle database being backed up through an external
application (Commvault). This application uses an RMAN script to back up
the database to tape.
Commvault is also backing up some filesystems from the server, and
ORACLE_HOME is included.

One of the guys from the Commvault support has advised us to include the
spfile in our RMAN backup, claiming that as we're in nocatalog mode, the
spfile is absolutely needed if we want to restore the database.

I create a pfile from spfile every night and keep it in some directory
in my ORACLE_HOME, so it's already backed up during the filesystem

My question is, do I really need to include the spfile in the RMAN
backup or can I just restore normally and recreate it later from my last

Thanks a lot.


Other related posts: