Database system check before the feast

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

1. The operating system log has no error, there is an error, immediately feedback to the customer. 2. os file system must not be full, for more than 90% of the file system, must be processed on the spot: Linux:df–h and Df-i aix:df-g hpux:bdf and bdf-i solaris:df-k windows : I can see it on my computer. 3. Whether the archive path will explode during the Spring Festival (in conjunction with the last inspection document), there are two types of archive paths: one is stored in the file system and the other is stored in a disk group such as +fra. 4. ASM Disk Group will explode during the spring Festival (need to combine the last inspection document to judge) 5. The directory where Oracle software (DB software, cluster software) is installed:/u01 and/u02, and so on. This can also be seen in the first article 6.      Database backup operation is normal, if not normal, to resolve immediately.    In fact, there are two forms of database backup, one is that we write the Rman script back to the file system, the other is the use of specialized backup software for backup (usually backed up to the virtual library), such specialized backup software is: A:commvault, Chinese name is Cang B: Symantec Veritas NetBackup (NBU), C:HP Company's HPDP (Data Protector), d:oracle of OSB (Oracle Secure Backup) E:EMC Company's NE   Tworker and Data Domain, F:IBM Company's TSM (Tivoli Storage Manager) has a problem with the backup of our own Rman script backup to file system, and we need to check the problem.   For "Backup with dedicated backup software" This backup has a problem, we need to distinguish who the backup software is for the goods, such as our goods, and also in the warranty period, then we have the responsibility to eliminate the error.  If other suppliers are ready for the goods, we should not take over the wrong exclusion.   7. The table space usage of the database is normal: With the inspection script can be checked out, for the use of more than 90% of the table space, the specific situation needs to be analyzed: if the table space usage is expected to explode during the Spring Festival, please inform the customer this thing, and then do the data file Add. Note that Oracle's datafile is an AIX hacmp or HP-UX MCSG Volume Group modeLV (commonly known as RLV mode, or bare device mode), need to advance in the concurrent volume group to divide the LV, change the authority and other work-this work is not our engineer's work, please let the customer find the relevant engineer to solve. 8.dataguard synchronization is normally performed in the Standby library: SELECT PROCESS, Status,thread#,sequence#,block#,blocks, Delay_mins Fromv$managed_standby; See which sequence is being applied, and then go to the main side to see which sequence is currently, a comparison will know the DG synchronization situation. 9. Goldengate synchronization is normal source:ggsci> info all destination:ggsci> info all see if the status is running

Database system check before the feast