init<SID>.ora Location

[former_member199632]

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,

[Former Member · Accepted solution]

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

[former_member204746]

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

[Former Member]

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

[former_member709110]

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