BACKUP AND RECOVERY Oracle Interview Questions [36 Questions]

  1. Authentication Methods for DBAsWhat are the steps to creating a password authentication file?
  2. Corrupted Archieve LogsThere are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
  3. Configure CommandWhat is configure command? When do you use this?
  4. Recovery CatalogWhat is recovery catalog? Why do you need this?
  5. RMAN BackupDetail script of backup using RMAN in both mode catalog and nocatalog
  6. You must first Login or Register to view all 36 questions from this category.

    Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.