Sanjay Forum

CONTROLFILES What Is a Control File? Every Oracle database has a control file. A control file is a small binary file that records the physical structure of the database and includes: * The database name * Names and locations of associated datafiles and online redo log files * The timestamp of the database creation * The current log sequence number * Checkpoint information The control file must be available for writing by the Oracle database server whenever the database is open. Without the control file, the database cannot be mounted and recovery is difficult. The control file of an Oracle database is created at the same time as the database. By default, at least one copy of the control file is created during database creation. On some operating systems the default is to create multiple copies. You should create two or more copies of the control file during database creation. You might also need to create control files later, if you lose control files or want to change particular setti...

Redo Log File Management What Is the Online Redo Log? The most crucial structure for recovery operations is the online redo log, which consists of two or more preallocated files that store all changes made to the database as they occur. Every instance of an Oracle database has an associated online redo log to protect the database in case of an instance failure. Redo Threads Each database instance has its own online redo log groups. These online redo log groups, multiplexed or not, are called an instance's thread of online redo. In typical configurations, only one database instance accesses an Oracle database, so only one thread is present. When running Oracle Real Application Clusters, however, two or more instances concurrently access a single database and each instance has its own thread. This chapter describes how to configure and manage the online redo log when the Oracle9i Real Application Clusters feature is not used. Hence, the thread number can be assumed to be 1 in all dis...

RMAN-OVERVIEW Recovery manager is a platform independent utility for coordinating your backup and restoration procedures across multiple servers. In my opinion it's value is limited if you only have on or two instances, but it comes into it's own where large numbers of instances on multiple platforms are used. The reporting features alone mean that you should never find yourself in a position where your data is in danger due to failed backups. The functionality of RMAN is too diverse to be covered in this article so I shall focus on the basic backup and recovery functionality. Create Recovery Catalog First create a user to hold the recovery catalog: CONNECT sys/password@w2k1 AS SYSDBA -- Create tablepsace to hold repository CREATE TABLESPACE "RMAN" DATAFILE 'C:\ORACLE\ORADATA\W2K1\RMAN01.DBF' SIZE 6208K REUSE AUTOEXTEND ON NEXT 64K MAXSIZE 32767M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; -- Create rman schema owner CREATE USER rman IDENTIFIED BY r...

APPS DBA INTERVIEW QUESTIONS 1.Mr.xxxx can u pls introduce u r self. Ans: Just tell them abt u r educational background, year of passing,native place, family member detials(if u r comfortable), u r strengths etc. 2. Can u pls tell us abt u r last organization, about u r project, customer. Ans: My last organization is xxxxxxx. Ltd., project name is yyyyyyyyyyy and customer name is zzzzzzzzzzzz. Customer business details(if u know). We have some 'n' instances in that we have n/4 production instances. 3. What is u r team size? Ans:Specify a number depends on number of instances u r handling in u r project 4.What are the projects going on , in u r project? Ans: Say there are some implementation and conversion projects are going on, but I don't know the entire details as our development team is handling that, we just supporting in Apps DBA point of view whenever it is required. 5. What are u r regular activities? Ans: Patching, patch analysis, monitoring, trouble shooting, resol...