on 05-16-2007 11:20 PM
Hi experts,
Can you guys please guide me regarding this
Changed the control file location 1 of the control file out of 3 to archive log files location.
Placing the control file to the archive log location is that a Sap Standard? If yes please Provide any SAP document suggesting above
Regards
Ricky
Hello,
SAP has a "standard" location of the control files.
But this files are "critical" for the DB, therefore you should move them to new locations to protect them better.
the 3 control files <b>must </b>be in 3 different disks, no filesystem or drives, but physical disks.
If you lose one disk you still have two valid control files.
The mirrorlog <b>must </b>be in different physical disk than the origlog. If you lose one you still have the other.
You should keep this things in lind when you plan your database installation or manage one already installed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ricky,
It is recommended that place the control files on different physical disks.
The reading/writing of the control files doesn't cause very much performance.
For example, if you already split the online redologs, archivelogs and datafiles in different physical disks, you can distribute the control files like this:
control_files='/oracle/SID/origlogA/cntrl/cntrlSID.dbf','/oracle/SID/sapdata1/cntrl/cntrlSID.dbf','/oracle/SID/saparch/cntrl/cntrlSID.dbf'
It's just a example, you can use it as a reference.
If you want some document, goto service.sap.com/instguides and find the guide for your products, in section 'Preparation and planning', you can find the information about controlfiles distribution.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Georgine
That what confusing, below parameter which indicates the control file locations are pointing to archive log location.
control files='oracle/SID/origlogA/cntrl/cntrlSID.dbf',
oracle/SID/sapdata1/cntrl/cntrlSID.dbf',
oracle/SID/saparch/cntrl/cntrlSID.dbf'
Here oracle/SID/saparch -
is the archive log location for the database.
Note: Can understand placing the control file at the redo log file location because there are part of the database but the archive logs are not part of the database and we need them only if we need to recover the database and usually we delete them (archive logs) after taking the backup from that location.
Regards
Ricky
Hi Ricky,
Sorry for the late reply, I haven't been online for a time period.
About the parameter, it's just an example, you can put it anywhere as you wish, and make sure they are on different physical disks. As I mentioned before, the control files will not cost high I/O, so you can put it even in dir of redo log.
The location is not fixed, just forget the example...
About the upgrade guide, you can goto service.sap.com/instguides -> Other documentation -> Database Upgrades -> Oracle, there are many detailed upgrade guides. Hope they are useful for you.
Regards
no, this is not standard, you should put mirrlog, origlog and archive logs on different disks for performance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.