DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: The right recovery?

  1. #1
    Join Date
    Jan 2005
    Posts
    36

    The right recovery?

    I have made a restore of my database - and would just hear if it is the right way.

    I created a database with the same name and SID. Afterwards I restored the controlfile from the production database.

    After this I did make a "restore database" where I used the latest backupset - and all datafiles where restored

    After this I did make a "alter database open resetlogs" - and the database where open.

    But what I am not clearly understand is the "resetlogs" - what does "resetlogs" do ?
    - But the database should now be in the latest version, as I used the backup piece from yesterday .. right ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    were you using rman?


    reset logs is used if you dont have the current online redo logs, so you haven't done a full recovery

  3. #3
    Join Date
    Jan 2005
    Posts
    36
    Oh yes .. It is rman

    I know without redologs I can not "go back" in time, but if I have restored datafiles, than the database is up-to-date as I have used yesterday backup piece ?

  4. #4
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    when u restore if u have not restored the redo log files, the SCN number of the datafiles and the current redo log file is different , by saying resetlogs u r rescynchronzing ur database to time zero...do a complete backup after opening using resetlogs, as all ur previous backups bcomes invalid.

  5. #5
    Join Date
    Jan 2005
    Posts
    36
    Is it a good idea to make backup of redolog files by operating system along with the rman script every day - or how is it able to secure you have the latest redolog files?

  6. #6
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    RMAN by default archives ur current online redologs and backup those archive logs (if included in the script), thats y its not taking the redolog file backup.

  7. #7
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    RESETLOGS is used to tell Oracle that the data that currently resides in the online redo logs is no longer required for recovery. Like has been suggested before, it should become part of your recovery procedures to do a full backup as soon as reocvery is complete (using resetlogs).

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by Sally
    Is it a good idea to make backup of redolog files by operating system along with the rman script every day - or how is it able to secure you have the latest redolog files?
    The archivelogs are Oracle's way of "backing up" the online redo logs, the frequency is determined by the log switching - it's up to you to make sure thay get stored somewhere intelligent . . . . like on machine in a different building.

    It doesn't make sense to backup the online redo logs, since any backup you have is immediately out of date!
    - If you lose them, then the archivelogs determine the point to which you can recover (followed by an OPEN RESETLOGS).
    - If you don't lose them, then you can recover completely (RESETLOGS is not required).

  9. #9
    Join Date
    Jan 2005
    Posts
    36
    Yes - this is what I not understand. I have enabled archive logging and in my rman script I have within "backup database archivelog all;"

    But how do I tell rman to use these archived archivelogs, as I have placed them in the same backup folder as on the server. Everytime I run the rman script two pieces are being made. 1 with datafiles and 1 with archivelogs

    ?

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    rman knows.

    When you issue recover database if know where they should be and what to do with them

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