ORACLE DBA

Oracle Data Guard Interview Questions & Answers What are the types of Oracle Data Guard? Oracle Data Guard classified in to two types based on way of creation and method used for Redo Apply. They are as follows. Physical standby (Redo Apply technology) Logical standby (SQL Apply Technology) What are the advantages in using Oracle Data Guard? Following are the different benefits in using Oracle Data Guard feature in your environment. High Availability. Data Protection. Off loading Backup operation to standby database. Automatic Gap detection and Resolution in standby database. Automatic Role Transition using Data Guard Broker. What are the different services available in Oracle Data Guard? Following are the different Services available in Oracle Data Guard of Oracle database. Redo Transport Services. Log Apply Services. Role Transitions. What are the different Protection modes available in Oracle Data Guard? Following are the different protect

1. Which types of backups you can take in Oracle?    3 types  of backup  Hot,  Cold, partial and incremental 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? Cold backup ( shutdown immediate , startup mount  and backup database and after startup  a database) 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? No, database must be offline. 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode? No, only with archivelog 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? SQL>shutdown immediate;  SQL>startup mount;    SQL> alter database archivelog; SQL> alter database open; 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database? RMAN>startup  explicite; 7. Where should you place Archive logfiles, in the same disk where DB is or another disk? Other disk 8. Can you t