Tuesday, May 18, 2010

Oracle Database 11g RMAN New Features

Advice on abstracts recovery, alongside advancement of the aforementioned file, and basic catalogs for aegis are aloof a few of the new gems accessible from RMAN in Oracle Database 11g. Following are most valueable new features available in oracle database 11g.
Data Recovery Advisor

The Data Recover Advisor is a new tool aimed at reducing a user’s time spent analyzing and formulating a suitable recovery plan for a given failure. In Oracle Database 11g, the new Data Accretion Adviser makes this operation abundant easier. The adviser comes in two flavors: command band approach and as a awning in Oracle Enterprise Manager Database Control. Each acidity has its advantages for a accustomed specific situation. For instance, the above advantage comes in accessible back you demand to automate the identification of such files via carapace scripting and agenda accretion through a account such as cron or at. The closing avenue is accessible for amateur DBAs who ability demand the affirmation of a GUI that guides them through the process. I'll call both here.

Friday, May 7, 2010

Oracle Error Codes - Error Message Number Ranges

Error Message Number Ranges

200 - 220 Control file management errors
250 - 299 Archival and media recovery errors
300 - 379 Redo log file errors
436 - 437 Oracle licensing errors
440 - 459 Background process startup errors
470 - 479 Background process fatal errors
500 - 599* V5-compatibility DECnet driver errors
700 - 709 Row cache errors
900 - 999 Parse errors
1000 - 1099 Program interface errors
1100 - 1199 Database file errors
1400 - 1499 SQL execution errors
1500 - 1699 Execution errors
1700 - 1799 Parse errors (continued)
1800 - 1899 Data function errors
1900 - 1999 Parse errors (continued)
2000 - 2099 Parse errors (continued)
2100 - 2139 Precompiler runtime errors
2140 - 2499 Parse errors (continued)
2500 - 2699* CT operating system errors
2700 - 2899* UNIX two-task errors
3000 - 3199 Two-task interface errors
3500 - 3699* Macintosh operating system errors
3700 - 3999* AOS/VS operating system errors
4000 - 4099 Invalid parameter errors
4100 - 4499* MVS operating system errors
4500 - 4899* CMS operating system errors
5000 - 5899* OEM operating system errors
5900 - 5999* Wang operating system errors
6000 - 6499* SQL*Net errors
6500 - 6599 PL/SQL errors
6600 - 6999* SQL*Net errors (continued)
7000 - 7099* SQL*Connect/DB2 errors
7100 - 7199* SQL*Connect/IMS errors
7200 - 7499* UNIX operating system errors
7500 - 7999* VAX/VMS operating system errors
8000 - 8199 Data layer errors