hot backup and restore
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: hot backup and restore

  1. #1
    Join Date
    Mar 2001
    Posts
    2
    Hi all

    I followed the below steps to create hot backup database, but when I restore I got the problem.

    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.

    And then I try to open with resetlogs and noresetlogs, I got another error

    ORA-01195: online backup of file 1 needs more recovery to be consistent
    ORA-01110: data file 1 : '/db02/oracle/oradata/system01.dbf'


    Please help me to solve this problem. I tried so many different ways but it still doesn't work.

    Thanks




    alter tablespace system begin backup;
    !cp to backup directory
    alter tablespace system end backup;

    REM ****** backup user tablespace

    alter tablespace user begin backup;
    !cp to backup directory
    alter tablespace user end backup;

    REM ****** backup rollback tablespace
    alter tablespace rollback begin backup;
    !cp to backup directory
    alter tablespace rollback end backup;

    REM ****** backup temp tablespace
    alter tablespace temp begin backup;
    !cp to backup directory
    alter tablespace temp end backup;




    REM ****** Perform controlfile backup

    Alter database backup controlfile to filename reuse;
    Alter database backup controlfile to filename reuse;
    alter database backup controlfile to trace;
    copy file to backup directory

    REM ****** Backup online redo-logs

    Alter system archive log all;

    copy redo log files into backup directory


  2. #2
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    During recovery did you specify UNTIL CANCEL? Otherwise ORACLE will assume compelte recovery and keep asking you for logs.

    Use "recover database until cancel using backup controlfile" and reply CANCEL when you have reached the required log. Then open database with RESETLOGS.

    BAliga

  3. #3
    Join Date
    Mar 2001
    Posts
    2
    mbaliga

    I followed your way, but it has the same error.

    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

    ORA-01195: online backup of file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'system01.dbf'

    Is there anything need to be done first?

    THanks

  4. #4
    Join Date
    Feb 2001
    Posts
    40
    I have come across the same problem but i dont remember the solution that i did. But i too would like to hear the solution for that.
    karthi,
    MDC Systems inc
    Farmington Hills,MI

  5. #5
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    You get these messages if you originally start with "recover database" command and later switch to "recover database until cancel".

    Check the V$datafile view and make sure all the datafiles are at the same change number. If you find that all have the same change no, then recreate the controlfile and open the database with resetlogs.

    Baliga




  6. #6
    Join Date
    Nov 2000
    Posts
    157
    Hi Ns

    I too faced the same problem yesterday.And i executed the same steps as u did.Just the same steps.But like u i too didn't succeeded

    Then in my backup control file i placed the NORESETLOGS Option in create controlfile command and i ran this controlfile.Because, if u put noresetlogs it will make ur control file current.and you can open your database simply like that.If you solved this problem by now it's cool.If not,and still you end up with any problems reg. this let me know.

    Thanks
    Ravi
    ravi

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    nsuser,

    How have you perform your restore/recovery? Are you sure you restored all the files from the same backup? Have you also restored your controlfile from your backup (not very good idea if you have usable current controlfile, but must be done under certain circumstances...)? It seems to me that (at least) your system01.dbf datafile is from a backup taken later than your backup controlfile or smth simmilar... Please provide all of your steps when performing restore and recover.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Nov 2000
    Posts
    89
    I am very weary of Oracle Restores !

    The best thing that I can recommend is that you spend a few days doing all kinds of restores on a test machine. I learned an awful lot and destroyed the database 6-8 times before I started to see the logic of the whole thing. The resetlogs can be a bit dangerous because it starts a new era of the db.

    I would never "learn" how to restore on a live production db. Once you F***ed up it may be hard to come back without a cold backup from before you started playing with the restores.


  9. #9
    Join Date
    Nov 2000
    Posts
    212
    rogerF: I am going to do the same. Nevertheless, could you share what logic you've started to see? What kind of tests you did?

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