How to Backup SPFILE


  1. using SQLPLUS (1)

    SQL> create pfile=’/u01/app/oracle/backups/pools/pfiles/pfilesqlplus20140226.ora’ from spfile;

    File created.

  2. using SQLPLUS (2)

    SQL> create pfile=’/u01/app/oracle/backups/pools/pfiles/pfilememory20140226.ora’ from memory;

    File created.

  3. using ASMCMD

    ASMCMD> cp +DATA/ITCAPPS2/spfileitcapps2.ora /u01/app/oracle/backups/pools/pfiles/pfileasmcmd20140226.ora
    copying +DATA/ITCAPPS2/spfileitcapps2.ora -> /u01/app/oracle/backups/pools/pfiles/pfileasmcmd20140226.ora

  4. using RMAN

    RMAN> backup spfile to destination=’/u01/app/oracle/backups/pools/pfiles/rman’;

    Starting backup at 26-FEB-14
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: SID=1385 device type=DISK
    channel ORA_DISK_1: starting full datafile backup set
    channel ORA_DISK_1: specifying datafile(s) in backup set
    including current SPFILE in backup set
    channel ORA_DISK_1: starting piece 1 at 26-FEB-14
    channel ORA_DISK_1: finished piece 1 at 26-FEB-14
    piece handle=/u01/app/oracle/backups/pools/pfiles/rman/ITCAPPS2/backupset/2014_02_26/o1_mf_nnsnf_TAG20140226T153522_9jv9tbqw_.bkp tag=TAG20140226T153522 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
    Finished backup at 26-FEB-14


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: