Database System check before holidays and database check before holidays

Database System check before holidays and database check before holidays

This article is the original article, reproduced please indicate the source: http://blog.csdn.net/msdnchina/article/details/43761361

1. If the Operating System Log reports an error or an error, report it to the customer immediately. 2. whether the OS file system is full during the holidays (combined with inspection documents to estimate the file system usage) linux: df-h and df-I aix: df-g hpux: bdf and bdf-I solaris: df-k windows: My computer can see it. 3. whether the archive path is full during the Spring Festival (which must be determined based on the last inspection document). There are two types of archive paths: one is stored in the file system, the other is stored in a disk group such as + FRA. 4. whether the ASM disk is full during the Spring Festival (you need to judge based on the last inspection document) 5. the installation directory of oracle software (db software, cluster software):/u01 and/u02. This can also be seen in article 1. 6. Check whether the database backup is running normally. If it is abnormal, it should be resolved immediately. In fact, there are two types of database backup. One is to back up the rman script we have written to the file system, another method is to use dedicated backup software for backup (generally back up to the virtual tape library). This kind of dedicated backup software includes: a: commvault, and the Chinese name is Kang Fu B: symantec veritas NetBackup (NBU), c: HP's HPDP (Data Protector), d: Oracle's OSB (Oracle Secure Backup) e: EMC's networker and Data Domain, f: IBM's TSM (Tivoli Storage Manager) has problems with the backup of the rman script we have written to the file system. We need to check the problem. If there is a problem with the backup by using dedicated backup software, we need to distinguish who supplies the backup software, for example, what we supply, in addition, we have the responsibility to eliminate errors during the warranty period. If other suppliers supply the goods, we should not take over the troubleshooting of this error. 7. check whether the tablespace usage of the database is normal: Use the inspection script to check whether the tablespace usage exceeds 90%. analyze the specific situation: If the tablespace usage is expected to continue during the Spring Festival, please notify the customer about this and add the data file. Note that Oracle's datafile should be divided into lv in the and volume group in advance if it is the hacmp of AIX or the mcsg volume group Type lv of the HP-UX (also known as rlv mode or bare device mode, change permissions and other work-this work is not the work of our engineers, please ask the customer to solve the problem. 8. whether dataguard synchronization is normal in the slave Database: select process, STATUS, THREAD #, SEQUENCE #, BLOCK #, BLOCKS, DELAY_MINS FROMV $ MANAGED_STANDBY; which sequence is being applied, then, you can check the sequence on the master end, and you can see the synchronization of dg in a one-to-one ratio. 9. Whether goldengate synchronization is Normal Source: ggsci> info all destination: ggsci> info all check whether the above status is running