oracle_dba_code_examples201012.pdf

实用的Oracle DBA 常用的实际操作文档 Document Parts Part 1 Oracle DBA Fundamentals _______________________ 36 Part 2 Oracle Database Net Services ___________________ 238 Part 3 Oracle Database Backup and Recovery ____________ 247 Part 4 Oracle Database Security _______________________ 311 Part 5 Oracle Database Performance Tuning _____________ 340 Part 6 Oracle Automatic Storage Management (ASM) ______ 396 Part 7 Oracle Real Application Cluster __________________ 410 Part 8 Oracle RAC One Node __________________________ 529 Part 9 Oracle Warehousing ___________________________ 551 Part 10 Oracle Database Utilities _______________________ 556 Part 11 Miscellaneous Oracle Database Topics _____________ 582 Part 12 PL/SQL Samples ______________________________ 596 Part 13 Appendixes__________________________________ 674 38页的部份文档 Optimal Flexible Architecture  The OFA is a set of recommendations from Oracle Corporation aimed at simplifying management of complex software and databases often running under multiple versions of software.  OFA Guidelines o Arrange at least four mount points that have names like /u01, /u02, /u03, and so on. o If the Oracle software owner is "oracle", make /u01/app/oracle your ORACLE_BASE # mkdir -p /u01/app/oracle # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/app/oracle o Make Oracle_HOME $ORACLE_BASE/product/version/{db|client|companion}_[n]. Examples: /u01/app/oracle/product/11.1.0/db_1 /u01/app/oracle/product/11.1.0/client_1 /u01/app/oracle/product/10.1.0.2.0/db_1 o Install Flash Recovery Area in $ORACLE_BASE/flash_recovery_area in a mount point different from db files. o Administrative Files are to be created in ORACLE_BASE/admin/dbname o Store Oracle DB files in the mounted points. # mkdir /mount_point/oradata # chown oracle:oinstall /mount_point/oradata # chmod 775 /mount_point/oradata /u01/oradata/prod1/control01.ctl /u05/oradata/prod1/control02.ctl /u02/oradata/prod1/redo01.log /u04/oradata/prod1/redo02.log data file has this format: /u20/oradata/prod/system01.dbf