init<SID>.ora Location

[#1]

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]

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