Question Re: init<SID>.ora Location in Technology Q&A

init.ora Location

former_member199632 — Sat, 25 Sep 2010 04:56:43 GMT

Hello,

In our DB server these files exists in 2 locations

initPRD.ora

initPRD.sap

spfilePRD.ora

location 1: /oracle/PRD/102_64/dbs/

and

location2: /oracle/PRD/sapbackup/PRD/

For the BRBACKUP and SMB backups it getting the initPRD.ora from this location

/oracle/PRD/102_64/dbs/initPRD.ora

So whats the use of files in location /oracle/PRD/sapbackup/PRD/

Is it just a copy?

thanks & regards,

Re: init.ora Location

Former Member — Sat, 25 Sep 2010 06:15:23 GMT

Hi,

Location 1 (/oracle/PRD/102_64/dbs) is default location for you parameter files in Oracle. When you bring up your database unless you specify the location of your parameter file , by default oracle will look for the parameter file in that location.

The file which you are seeing under sapbackup directory is the backup copy of the file under location 1, but again thats the backup copy of the current file only if you have configured you backup with the location 2 as your backup destination ( as you know when you do database backup the parameter file is also backedup).

Otherwise its just a mannual copy done by someone else.

You can find that out by checking the data stamp on the file and your backup log.

Regards,

Neel

Re: init.ora Location

Former Member — Sat, 25 Sep 2010 06:28:38 GMT

Hi,

In oracle, init<SID>.ora is the profile file and spfile.ora is the system profile file. These files are needed by oracle while startup. These files will be usually available in the path $ORACLE_HOME/dbs (where $ORACLE_HOME=/oralce/<SID>/102_64). These files are just like the profile files for SAP (available in the location /usr/sap/<SID>/SYS/profile).

While taking a backup, a copy of these profiles will be taken in the backup stage directory. This happens whenever a backup is scheduled using BRTools. These are just copies and nothing to do with the oracle startup.

Hope this clarifies.

Regards,

Varadharajan M

Re: init.ora Location

Former Member — Sat, 25 Sep 2010 09:07:34 GMT

Hi,

So whats the use of files in location /oracle/PRD/sapbackup/PRD/

Have you ever tried taking "Backup on Disk" either from BRTOOLS or DB13 ?

(You may see relevant log in DB12)

It seems that "/oracle/PRD/sapbackup/PRD/" is created by backup process. It that case profiles will also be backed up.

Otherwise there would be only single location for init<SID>.ora. i.e. $ORACLE_HOME/dbs or $ORACLE_HOME\database.

Regards.

Rajesh Narkhede

Re: init.ora Location

Former Member — Sat, 25 Sep 2010 14:37:29 GMT

spfilePRD.ora = the parameters that Oracle uses

initPRD.ora = the old file that Oracle used in the past, now BRTOOLS uses it to read Oracle parameters. it gets created everytime you start any BRTOOL.

initPRD.sap = file that BRTOOLS uses for its functionnality