RMAN Interview Questions from Geekinterview – Free download as Word Doc . doc), PDF File .pdf), Text Oracle 11g RAC Interview Question and Answers. 18 Jul ORACLE DATABASE RMAN INTERVIEW QUESTIONS AND ANSWERS LIKE What are the advantages of RMAN?Validation of the backup Parallelism What are the new features of Oracle 11g RMAN? We have some new. 19 Nov rman interview and scenario based questions and answer and also rman(backup and What are new features in Oracle 11g RMAN?

Author: Faulkree Kar
Country: Switzerland
Language: English (Spanish)
Genre: Automotive
Published (Last): 15 November 2016
Pages: 415
PDF File Size: 9.30 Mb
ePub File Size: 15.40 Mb
ISBN: 341-9-65825-116-1
Downloads: 81602
Price: Free* [*Free Regsitration Required]
Uploader: Fegor

It will start comparing block SCN with the last level 0 backup. By using catalog command. Starting backup at FEB current log archived allocated channel: April 21, Reply.

Oracle Database RMAN Interview Questions – Expert Oracle

Create data file and recover datafile. What happens when you restore a file containing fractured block? A data file can be associated with only one database. Oracle Database 10g Enterprise Edition Release Preferred when cardinality is high.

Similarly online logs are equally important and loosing them can also cause database to crash, incomplete recovery and possible data loss. Transaction guard improvements of Fast Application Notification. How do you identify the block corruption in RMAN database?


By continuing to use this website, you agree to their use. A split brain situation happens when all the links of the private interconnect fail to respond to each other but instances are still up and running.

What is difference between Restoring and Recovery of database? Global partitioned indexes can only be partitioned using range partitioning. Ib is the difference between full backup and level 0 backup? Using change tracking file in 10g. Information about persistent configuration settings.

Important RMAN Interview Questions and Answers

Logging of changed blocks is performed by the CTRW process which is also responsible for writing data to the block change tracking file. Consider you have sufficient backup for this example such anssers daily incremental backup for all targets database on Sat-Thurs day and Weekly full backup on Friday.

Complete recovery of database is of primary importance to you than the database interruption. Was this answer useful? Can we use same target database as catalog?

This is highly recommended. It greatly simplifies the dba jobs by managing the production database’s backing up, restoring, and recovering database files.

Block size is specified in init. But one day around 3. What you can do now? Extremely helpful information particularly the remaining part: The refresh will go faster, and no undo will be generated. A local index is an index on a partitioned table which is partitioned in the exact same manner as the underlying partitioned table. The only option is connect to thetarget database and give list backup this will give you the backup information with date and timing.


In unused block compression, RMAN can skip data blocks that have never been used. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links. It could be a table or index partition. A global cache service request is made in Oracle when a user attempts to access a buffer cache to read or modify a data block and the block is not in the local cache.

In 11g RMAN checks for both free and used extents. A Consistent backup is one in which the files being backed up contain all changes upto the same system change number SCN. What is an Oracle index? One data block corresponds to a specific number of bytes of physical database space on disk.