【正文】 release channel t5。 release channel t3。 release channel t1。 parms=ENV=(NB_ORA_CLIENT=JXSALDB1_svc)。 allocate channel t5 type 39。sbt_tape39。 parms=ENV=(NB_ORA_CLIENT=JXSALDB1_svc)。 allocate channel t3 type 39。sbt_tape39。 parms=ENV=(NB_ORA_CLIENT=JXSALDB1_svc)。 allocate channel t1 type 39。 2) 恢復(fù)歸檔日志 run{ set archivelog destination to 39。 1) 恢復(fù)某個(gè)數(shù)據(jù)文件 restore datafile 8。 恢復(fù)方式 這里只討論數(shù)據(jù)庫本身的恢復(fù)機(jī)制 恢復(fù)數(shù)據(jù)庫 restore database。 RELEASE CHANNEL ch01。 ARCHIVELOG ALL DELETE INPUT 。 BACKUP filesperset 20 FORMAT 39。 ALLOCATE CHANNEL ch02 TYPE 39。 日常操作規(guī)范 第 31頁 ALLOCATE CHANNEL ch01 TYPE 39。 3) 歸檔日志的備份腳本 ALLOCATE CHANNEL ch00 TYPE 39。 RELEASE CHANNEL ch08。 RELEASE CHANNEL ch06。 RELEASE CHANNEL ch04。 RELEASE CHANNEL ch02。 RELEASE CHANNEL ch00。 sql 39。bk_%s_%p_%t39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。 release channel。 2) 數(shù)據(jù)庫增量備份的腳本 allocate channel for maintenance type disk。 RELEASE CHANNEL ch08。 RELEASE CHANNEL ch06。 RELEASE CHANNEL ch04。 RELEASE CHANNEL ch02。 RELEASE CHANNEL ch00。 sql 39。bk_%s_%p_%t39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。SBT_TAPE39。 release channel。 1) 數(shù)據(jù)庫全備份的腳本 allocate channel for maintenance type disk。 在備份過程中，確定要使用 catalog保存?zhèn)浞菪畔?，同時(shí)配置自動(dòng)備份控制文件。或進(jìn)行數(shù)據(jù)庫的增量備份，然后定期備份每天的歸檔日志。針對(duì)本通信行業(yè)一般數(shù)據(jù)庫容量都以 T為單位。s remended: = Oracle = maxusers * 5 = Oracle 9i = ((NPROC*9)/10) Maxvgs Max. number of volume groups: Default: 10 Remended: increase to the number of volume groups you would like to have on the system (maximum 256) MSGMAP Defines the maximum number of message map entries. Remended: = Oracle 9i = (MSGTQL + 2) MSGMNI Defines the number of message queue identifiers. Remended: = Oracle 9i = (NPROC) MSGSEG Defines the number of segments available for messages. Remended: = Oracle 9i = (NPROC * 4) (at least 32767) MSGTQL Defines the number of message headers. Remended: = Oracle 9i = (NPROC) NCALLOUT Defines the maximum number of pending timeouts. Remended: = Oracle 9i = (NPROC + 16) 日常操作規(guī)范 第 22頁 NCSIZE Defines the Directory Name Lookup Cache (DNLC) space needed for inodes. Remended: = Oracle 9i = ((8 * NPROC + 2048) + VX_NCSIZE) VX_NCSIZE is by default 1024. nfile Max Number of simultaneously Open files systemwide at any given time. Total number of slots it the file descriptor table, default=16*(nproc+16+maxusers)/10+32+ 2*(npty+nstrpty) remended: = Oracle = to use default. = Oracle 9i = (15 * NPROC + 2048) nflocks Max Number of File Locks available systemwide, (check with glance if you are getting close to the value you have set) default=200 or 200+10*(num_clients) remended: = Oracle = at least 200 + sum off all db_files for all instances of Oracle = Oracle 9i = (nproc) (at least 4096) NINODE Defines the maximum number of open inodes. Remended: = Oracle 9i = (8 * NPROC + 2048) NKTHREAD Defines the maximum number of kernel threads supported by the system. Remended: = Oracle 9i = (((NPROC * 7) / 4) + 16) nproc Max Number of Processes that can exist simultaneously in the system, 日常操作規(guī)范 第 23頁 default=(20+8*MAXUSERS), influences ninode, nfile. remended: = Oracle = to use default = Oracle 9i = 4096 npty Number of ptys (pseudo ttys), default=60. remended: if you are using rlogin/tel connections from clients to server then increase npty up to the number of client users, otherwise use default. Note: ptys are not used when using Oracle SQL*Net num_tachyon_adapters HPUX only Number of Tachyonbased Fiber Channel Adapters in the System Remended: minimum 5, set to real number of Fiber Channel Adapters HPUX 11i – no support for tachyon adapters, the new is tachlite, which do not use this kernel parameter. o_sync_is_o_dsync Enable/Disable translation of O_SYNC to O_DSYNC in open()/ftl() calls, default=0. remended: Oracle = o_sync_is_o_dsync=1 or use Oracle Patch for Bug 310042. = = use default for o_sync_is_o_dsync=0 (patch 310042 not needed). SEMMAP Defines the maximum number of semaphore map entries. Remended: = Oracle 9i = (SEMMNI + 2) 日常操作規(guī)范 第 24頁 semmni Number of Semaphore Identifiers, specifies the maximum number of sets of semaphores that can exist simultaneously on the system, default=64. remended: = Oracle8i = use default or at least 10 per Oracle database = Oracle9i = 4096 semmns Max Number of Semaphores, defines the systemwide maximum n