Databases Reference
In-Depth Information
Using a Recovery Catalog
If you're using a recovery catalog, then restoring the spfile is fairly straightforward. This example connects to the
recovery catalog and then restores the spfile (you'll have to modify the catalog connection string to match the
user/pass and recovery catalog for your environment):
$ rman target / catalog rcat/rcat@rcat
RMAN> startup nomount;
If there is no valid spfile or init.ora file in the default location, then a few errors will be thrown:
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file...
starting Oracle instance without parameter file for retrieval of spfile
Now restore the spfile:
RMAN> restore spfile;
RMAN> startup force; # startup using restored spfile
If you receive an error such as this when running the restore command:
RMAN-20001: target database not found in recovery catalog
Then first set the DBID (see Recipe 10-3 for details on determining your DBID):
RMAN set dbid 3414586809;
Not Using a Recovery Catalog, RMAN Auto Backup in Default Location
For this scenario you need to know your database identifier before you can proceed. See Recipe 10-3 for details about
determining your DBID.
This recipe assumes that you have configured your auto backups of the spfile to go to the default location.
The default location depends on your operating system. For Linux/Unix, the default location is ORACLE_HOME/dbs.
On Windows systems, it's usually ORACLE_HOME\database.
$ rman target /
RMAN> startup force nomount; # start instance for retrieval of spfile
RMAN> set dbid 3414586809;
RMAN> restore spfile from autobackup;
RMAN> startup force; # startup using restored spfile
You should now see your instance start normally:
database opened
When the auto backup is located in the default location, you can use the parameters
maxseq
and
maxdays
to alter
the default behavior of RMAN. These parameters also apply to control file restores from the default location. See
Recipe 10-4 for examples on how to use
maxseq
and
maxdays
.
