Date - Sept-2010
Affected Product & Version - NetVault: Backup al versions
Affected Module & Version - Oracle APM 6.0.19
OS Version - any
Application Information - Oracle 10g and 11g
Description:
The spfile should most of the time be a static file.
It is not really often modified unless new parameters or configurations are manually applied.
So you can essentially copy and move this file anywhere you want.
You can do that in several ways:
1- Restoring spfile to same server via GUI by renaming:
- select spfile in restore window
- right click the file and select > Rename
- check 'Rename to'
- input the path you want this file to be restored to:
e.g. /u01/app/oracle/product/11.2.0/dbhome_1/dbs/test_spfile_restore
- submit the job as nothing else is needed
2- Restoring spfile via GUI to another netvault client:
- install the oracle apm on the other machine you want to restore the spfile to (even if this machine doesn't an Oracle db)
- From the netvault server select the spfile in restore window
- right click the file and select > Rename
- check 'Rename to'
- input the path and name of the spfile you want to restore on the other client
e.g. /test/spfile_restore_from_boxA
- select the target netvault client in the Target tab
- submit the job
3- Using the File System plugin on the Oracle server:
- simply perform a file system backup of:
e.g: /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfilebcko.ora
- you can then restore the file on any netvault client using the file system plugin and selecting the target client in the Target tab
4- Using SQLPLUS and Linux SCP command:
- You can use sqlplus to create a pfile from the current spfile:
SQL> create SPFILE from PFILE='/init.TXT';
- in this example /init.txt is created as a copy of the current spfile and can be copied to another machine using linux scp command:
scp /init.txt <other_machine_IP>:/<target_path>
