DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RMAN - RECOVERY - ORA-1152

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Hi

    I try to recover after restoring/replicating all control files from a RMAN backup. This is successful.

    Then I do ALTER DATABASE MOUNT;

    Then when I do ALTER DATABASE OPEN RESETLOGS; ...
    get ORA-1152...

    The db version is 8.0.3.

    Any ideas ??

    Thanks & Regards.


  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    ORA-01152 file string was not restored from a sufficiently old backup

    Cause: An incomplete recovery session was started, but an insufficient number of redo logs were applied to make the database consistent. This file is still in the future of the last redo log applied. The most likely cause of this message is forgetting to restore the file from backup before doing incomplete recovery.

    Action: Apply additional redo log files until the database is consistent or restore the datafiles from an older backup and repeat recovery.


Posting Permissions

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


Click Here to Expand Forum to Full Width