RMAN: Backing Up the spfile

RMAN: Backing Up Oracle spfile
Андрей Волков

Андрей Волков

Системное, сетевое администрирование +DBA. И немного программист!))  Профиль автора.

If you have enabled the autobackup of the control file feature, the spfile will be backed up automatically (along with the control file) anytime a BACKUP or COPY command is issued. If you need to back up the spfile manually, use the following command:

RMAN> backup spfile;

The location of the file that contains the backup of the spfile is dependent on what you have configured for the autobackup of the control file (see the previous section for an example). By default, if you don’t use an FRA, and you haven’t explicitly configured a location via a channel, then for Linux/Unix servers, the backup goes to the ORACLE_HOME/dbs directory.

Image Note  RMAN can only back up the spfile if the instance was started using a spfile.

Вас заинтересует / Intresting for you:

RMAN: Using Online or Offline ...
RMAN: Using Online or Offline ... 1698 views Андрей Волков Sat, 29 Feb 2020, 10:01:33
RMAN: Specifying the Backup Us...
RMAN: Specifying the Backup Us... 2527 views Андрей Волков Sat, 29 Feb 2020, 10:14:03
RMAN: Checking for Corruption ...
RMAN: Checking for Corruption ... 27105 views Андрей Волков Thu, 30 Sep 2021, 11:57:27
RMAN: Backing UP Oracle Databa...
RMAN: Backing UP Oracle Databa... 983 views Андрей Волков Wed, 29 Sep 2021, 18:27:51
Comments (1)
This comment was minimized by the moderator on the site

Yes, making an spfile backup is very easy using the RMAN utility!

apv
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Suggested Locations