【正文】 timizer_index_caching 10 日常操作規(guī)范 第 17頁 割接申請(qǐng) 割接流程表，割接確認(rèn)單請(qǐng)查看附錄一。s more efficient to use system memory for Oracle SGA instead of file system buffer cache dbc_min_pct Min dynamic Buffer Cache size in percent of system memory (see dbc_max_pct) default=5 remended: between 2 and 5 日常操作規(guī)范 第 19頁 fs_async see appendix 2 and appendix 6 KSI_ALLOC_MAX (NPROC * 8) Defines the system wide limit of queued signal that can be allocated. max_async_ports Maximum number of asyncdsk ports that can be open at one time. If an error happens with this, it will not shown in the Oracle file or in trace files. default: 50 remended: max. no of shadow processes + no of parallel querie slaves max_thread_proc Max no. of threads allowed in each process default: 64 remended: = Oracle = 64 = Oracle = 256 maxfiles Soft File Limit per Process, soft limit for number of files a process is allowed to have open simultaneously. Processes can increase their soft limit until they reach the hard limit maxfiles_lim. default=60. remended=1024 maxfiles_lim Hard File Limit per Process, default=1024. remended=1024 (default). maxdsiz Refers to the maximum data segment size for 32bit systems. Setting this value too low may cause the processes to run out of memory. Max Data Segment Size (Bytes) default: 67108864 remended: = Oracle = 128 MB = Oracle 9i = 1073741824 bytes 日常操作規(guī)范 第 20頁 maxdsiz_64bit Refers to the maximum data segment size for 64bit systems. Setting this value too low may cause the processes to run out of memory. Max Data Segment Size (Bytes) default: 1073741824 remended: = Oracle = 1073741824 bytes = Oracle 9i = 2147483648 bytes MAXSSIZ Defines the maximum stack segment size in bytes for 32bit systems. Remended: = Oracle 9i = 134217728 bytes MAXSSIZ_64BIT Defines the maximum stack segment size in bytes for 64bit systems. Remended: = Oracle 9i = 1073741824 bytes maxtsiz Max Text Segment size (Bytes) Remended: 128MB max_fcp_reqs Maximum Number of Concurrent Fiber Channel Requests Per Adapter remended: 512 maxswapchunks maximum number of swap chunks where SWCHUNK is the swap chunk size (1 KB blocks). Default: 2048 remended: = Oracle 8i = 4096 = Oracle 9i = 16384 maxusers Value of MAXUSERS macro, limits the Ssstem resource allocation (not the actual number of users). Influences nproc, ninode, nfile. default=32. remended: 日常操作規(guī)范 第 21頁 set to number of concurrent Oracle DB users + 64 maxuprc Max Number of simultaneous user processes (per userid!). default=75 Because all database processes often run with the Oracle userid, it39。 根據(jù)數(shù)據(jù)量和歸檔日志產(chǎn)生的頻率可考慮不同模式的的備份機(jī)制。一般會(huì)定義一個(gè)全備的日期，然后定期備份歸檔日志。具體備份可以備份到磁盤上也可以備份到磁帶上，一般現(xiàn)在是備份到磁帶上。 CONFIGURE CONTROLFILE AUTOBACKUP ON。 change archivelog all validate。 RUN { ALLOCATE CHANNEL ch00 TYPE 39。 ALLOCATE CHANNEL ch01 TYPE 39。 ALLOCATE CHANNEL ch02 TYPE 39。 ALLOCATE CHANNEL ch03 TYPE 39。 ALLOCATE CHANNEL ch04 TYPE 39。 ALLOCATE CHANNEL ch05 TYPE 39。 ALLOCATE CHANNEL ch06 TYPE 39。 ALLOCATE CHANNEL ch07 TYPE 39。 ALLOCATE CHANNEL ch08 TYPE 39。 ALLOCATE CHANNEL ch09 TYPE 39。 BACKUP incremental level 0 SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 7 remended format FORMAT 39。 DATABASE。alter system archive log current39。 RELEASE CHANNEL ch01。 RELEASE CHANNEL ch03。 日常操作規(guī)范 第 30頁 RELEASE CHANNEL ch05。 RELEASE CHANNEL ch07。 RELEASE CHANNEL ch09。 change archivelog all validate。 RUN { ALLOCATE CHANNEL ch00 TYPE 39。 ALLOCATE CHANNEL ch01 TYPE 39。 ALLOCATE CHANNEL ch02 TYPE 39。 ALLOCATE CHANNEL ch03 TYPE 39。 ALLOCATE CHANNEL ch04 TYPE 39。 ALLOCATE CHANNEL ch05 TYPE 39。 ALLOCATE CHANNEL ch06 TYPE 39。 ALLOCATE CHANNEL ch07 TYPE 39。 ALLOCATE CHANNEL ch08 TYPE 39。 ALLOCATE CHANNEL ch09 TYPE 39。 BACKUP incremental level 1 SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 7 remended format FORMAT 39。 DATABASE。alter system archive log current39。 RELEASE CHANNEL ch01。 RELEASE CHANNEL ch03。 RELEASE CHANNEL ch05。 RELEASE CHANNEL ch07。 RELEASE CHANNEL ch09。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。al_%s_%p_%t39。 RELEASE CHANNEL ch00。 RELEASE CHANNEL ch02。 recover database。 recover datafile 8。/arch1/baklog/39。sbt_tape39。 allocate channel t2 type 39。 parms=ENV=(NB_ORA_CLIENT=JXSALDB1_svc)。sbt_tape39。 allocate channel t4 type 39。 parms=ENV=(NB_ORA_CLIENT=JXSALDB1_svc)。sbt_tape39。 restore archivelog from logseq 135219 until logseq 135220。 release channel t2。 release channel t4。 }