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