Explore Oracle RMAN_07 parameter file loss recovery

OracleThere are two types of database parameter files:Pfile (Initialize the parameter file)And the other isSpfile (Server initialization parameter file); ActuallySpfileYesPfileA new parameter file derived from the Application9iFor later versions9iNot supported in previous versions, only supportedPfileAndPfileYesOracleCommand to back up, onlySpfileBackup is supported.

 PassRMANTo restore the parameter file, only applicable9iLater

1,PassRmanBackup parameter file:

RMAN> backupspfile;

 

Starting backupat 05-JUL-12

Using channelORA_DISK_1

ChannelORA_DISK_1: starting full datafile backupset

ChannelORA_DISK_1: specifying datafile (s) in backupset

Including currentSPFILE in backupset

ChannelORA_DISK_1: starting piece 1 at 05-JUL-12

ChannelORA_DISK_1: finished piece 1 at 05-JUL-12

Piecehandle =/DBBak/bak_WWL_07_05_03nfbi5c_1_1 tag = TAG20120705T175348 comment = NONE

ChannelORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backupat 05-JUL-12

 

Starting ControlFile and SPFILE Autobackup at 05-JUL-12

Piecehandle =/DBSoft/product/10.2.0/db_1/dbs/c-5520179-20120705-01 comment = NONE

Finished ControlFile and SPFILE Autobackup at 05-JUL-12

 

RMAN>

 

2,After the backup, we can see the following backup information:

BS Key Type LV Size Device Type Elapsed Time Completion Time

-------------------------------------------------------------

3 Full 80.00 k disk 00:00:01 05-JUL-12

BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120705T175348

Piece Name:/DBBak/bak_WWL_07_05_03nfbi5c_1_1

SPFILE Included: Modification time: 05-JUL-12

 

3,Loss of simulated parameter files:

SQL> showparameter spfile;

 

NAME TYPE VALUE

-----------------------------------------------------------------------------

Spfile string/DBSoft/product/10.2.0/db_1/db

S/spfileWWL. ora

SQL>

 

Delete the parameter file:

[Oracle @ wwldb ~] $ Rm/DBSoft/product/10.2.0/db_1/dbs/spfileWWL. ora

[Oracle @ wwldb ~] $ Ls/DBSoft/product/10.2.0/db_1/dbs/spfileWWL. ora

Ls:/DBSoft/product/10.2.0/db_1/dbs/spfileWWL. ora: No such file ordirectory

 

[Oracle @ wwldb dbs] $ ll

Total 7240

Drwxr-xr-x 2 oracle oinstall4096 Jul 5 bak

-Rw ---- 1 oracle oinstall1544 May 16 hc_WWL.dat

-Rw ---- 1 oracle oinstall24 May 23 :52 lkDUMMY

-Rw ---- 1 oracle oinstall24 May 16 16:47 lkWWL

-Rw-r ----- 1 oracle oinstall1536 May 21 orapwWWL

Drwxr-xr-x 2 oracle oinstall4096 Jul 5 pfilebak

-Rw-r ----- 1 oracle oinstall 7389184 Jul5 snapcf_WWL.f

[Oracle @ wwldb dbs] $

We can see thatPfileAndSpfileIf none of them exist, the database cannot be started. In this case, the database must be recovered.SpfileOr manually writePfileTo start the database.

1 2 Next Page