| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Top (<=10) Issues faced by Oracle DBAs Deploying in a SAN/NAS
Re: Top (<=10) Issues faced by Oracle DBAs Deploying in a SAN/NASI would still rank undo & redologs together with regular data because they're crucial for survivability and consistency of information...
Tanel.
1..
a.. If there is a policy to place all "corporate data" on the shared storage (NAS), then surely redo, RBS/UNDO etc should not be considered "corporate data"
b.. Often, the "lk<DBNAME>" mount lock file in the "$ORACLE_HOME/dbs" directory should be placed on direct-attach HDD or SAN, else ORA-27086 can happen
a.. Oracle documentation mentions resolution of ORA-27806 by running unlocking commands on NetApps console, but the best solution is prevention...
2.. Not placing file-systems like user home directories, ORACLE_HOME, admin/log/trc, APPL_TOP, etc on the NAS and placing heavily-accessed datafiles on direct-attach HDD or SAN
a.. Why not place low-demand file-systems on the lower-performance storage and high-demand file-systems on higher-performance storage?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Sep 28 2003 - 21:44:40 CDT
 |
 |