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

Thread: RMAN (or) ARCHIVED LOG QUESTION?

  1. #1
    Join Date
    Aug 2000
    Posts
    236
    DBA's

    I have database which was created in no archivelog mode and subsequently changed to ARCHIVE LOG MODE.

    As a result I do not have SCN's 1 - 450. I installed RMAN and backed up the whole database and all my archive logs.

    Now when I validate the entire backup - no problems.
    But when I validate the archive logs get an error saying some targets not found.

    Now my question is - How do i remove entries from the control file for thoes redo SCN's which I either dont need or which are not available in the archive log?
    And how do I resync my catalog?

    Thanks,
    Nizar

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    AFAIK you can't selectivelly remove some redolog entries from your controlfile. All you can do is to remove all redo entries and start counting redo sequences from the begining by:

    ALTER DATABASE OPEN RESETLOGS;

    Of course, full backups before and immediatelly after this operation would be highly recomended...

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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