Oracle DBA interview questions answers - Part 5
81. What is extent management?
Answer :
Answer :
Auto and Manual.
82. What will happen when we open the database in resetlogs ?
Answer :
Use RESETLOGS after incomplete recovery (when the entire redo stream wasn't applied). RESETLOGS will initialize the logs, reset your log sequence number, and start a new "incarnation" of the database.
Use RESETLOGS after incomplete recovery (when the entire redo stream wasn't applied). RESETLOGS will initialize the logs, reset your log sequence number, and start a new "incarnation" of the database.
83. As DBA, can you offline system tablespace?
Answer :
No, we can’t off-line system and undo tablespaces.
No, we can’t off-line system and undo tablespaces.
84. What is the use of set dbid?
Answer :
While connecting to recovery manager, where db_name is not unique, better to set dbid.
We must set dbid value, while recovering backup of spfile.
85. How to restore spfile without backup?
Take spfile or pfile backup from standby and restore it.
Use alert log to get non-default init parameters.
Use RMAN auto or manual spfile backups.
While connecting to recovery manager, where db_name is not unique, better to set dbid.
We must set dbid value, while recovering backup of spfile.
85. How to restore spfile without backup?
Take spfile or pfile backup from standby and restore it.
Use alert log to get non-default init parameters.
Use RMAN auto or manual spfile backups.
86. What will happen when a node crashes?
Answer :
* 1. One or more RAC instances fail.
* 3. Node failure is detected by any one of the remaining instances.
* 4. Global Resource Directory(GRD) is reconfigured and distributed among surviving nodes.
* 5. The instance which first detected the failed instance, reads the failed instances redo logs to determine the logs which are needed to be recovered. The above task is done by the SMON process of the instance that detected failure.
* 6. Until this time database activity is frozen, The SMON issues recovery requests for all the blocks that are needed for recovery. Once all the blocks are available, the other blocks which are not needed for recovery are available for normal processing.
* 7. Oracle performs roll forward operation against the blocks that were modified by the failed instance but were not written to disk using redo log recorded transactions.
* 8. Once redo logs are applied, uncommitted transactions are rolled back using undo tablespace.
* 9. Database on the RAC in now fully available.
* 1. One or more RAC instances fail.
* 3. Node failure is detected by any one of the remaining instances.
* 4. Global Resource Directory(GRD) is reconfigured and distributed among surviving nodes.
* 5. The instance which first detected the failed instance, reads the failed instances redo logs to determine the logs which are needed to be recovered. The above task is done by the SMON process of the instance that detected failure.
* 6. Until this time database activity is frozen, The SMON issues recovery requests for all the blocks that are needed for recovery. Once all the blocks are available, the other blocks which are not needed for recovery are available for normal processing.
* 7. Oracle performs roll forward operation against the blocks that were modified by the failed instance but were not written to disk using redo log recorded transactions.
* 8. Once redo logs are applied, uncommitted transactions are rolled back using undo tablespace.
* 9. Database on the RAC in now fully available.
87. What ACID properties ?
Answer :
88. What is CAP Theorem ?
Answer :
89. What is normalization and in which normal form do you want to keep your database ?
Answer :
90.
Related Oracle Articles: Datawarehouse Interview Questions Oracle DBA Interview Questions – Part 4
No comments:
Post a Comment