Forgot your password?    
+ Reply to Thread
Results 1 to 7 of 7

Thread: Database Recovery Question??

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Lightbulb Database Recovery Question??

    Let's we have a senerio in which the database (running in ARCHIVELOG mode):

    - there are three online redo log groups
    - the current log sequence number is 198
    - the most recent database backup was performed last Friday

    On Monday morning, you find that the users.dbf data file, which belongs to the USERS tablespace, is corrupted. On further investigation, you find that the archived redo log file for the log sequence number 196 does not exist.

    Which recovery method would you recommend to recover the users.dbf data file?
    Regards,
    -Amit

  2. #2
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    17
    I think we should opt for incomlete recovery for this datafile...apply archive upto 195, then open database with resetlogs.

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    DB will not get up after applying archive till 195...it will give error when u try to open it with resetlog options...

    any other suggestion?
    Regards,
    -Amit

  4. #4
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    Yes we should first restore the controlfile, datafile from the last backup and will do incomplete recovery upto seq no 195 using current controlfile command. And its for sure we will loose some data.

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Any Chance for Complete Recovery of Database???
    Regards,
    -Amit

  6. #6
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    There are only two ways you can do complete recovery either provide the scn 196 which is lost or if we had taken full backup of the database when the lost of scn 196 is detected. And both is not the case here, So there is no possibility of complete recovery.

    Regards Masood

  7. #7
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    that's what..i was thinking about this situation.

    Thx Masood!!
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Interview Question related to Database migration
    By mdmasood in forum Database Installation,Upgrades,Migration,Patching and Cloning
    Replies: 0
    Last Post: 06-07-2012, 04:15 PM
  2. Oracle Database Manual Backup and Recovery.
    By ajaychandi in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 01-24-2012, 06:51 PM
  3. Loss of Non-System datafile in a Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 1
    Last Post: 11-01-2011, 03:35 PM
  4. Loss of system datafile in Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-01-2011, 11:54 AM
  5. Loss of all controlfiles of the Database (User Managed Recovery)
    By ajaysingh in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-01-2011, 11:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics