8 Replies Latest reply: Nov 20, 2012 3:22 AM by vk82 RSS

    Restore Issue

    494959
      Hi,
      DB is 10.2.0.4.0 OS AIX

      I have taken the full database backup on 09nov.Now I wanted to restore.
      I have given the below command.to check the backout plan.

      restore database until time "to_date('9-NOV-2012 11:00:00','dd-mon-rrrr hh24:mi:ss')";
      recover database until time "to_date('9-NOV-2012 11:00:00','dd-mon-rrrr hh24:mi:ss')";

      error encounterred is:
      RMAN> recover database until time "to_date('9-NOV-2012 11:00:00','dd-mon-rrrr hh24:mi:ss')";

      Starting recover at 15-NOV-12
      using target database control file instead of recovery catalog
      allocated channel: ORA_SBT_TAPE_1
      channel ORA_SBT_TAPE_1: sid=587 devtype=SBT_TAPE
      channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.5.2.0
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=583 devtype=DISK

      starting media recovery

      Oracle Error:
      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
      ORA-01190: control file or data file 1 is from before the last RESETLOGS
      ORA-01110: data file 1: '/oracle/ASD/data1/system_1/system.data1'

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of recover command at 11/15/2012 09:17:21
      RMAN-06053: unable to perform media recovery because of missing log
      RMAN-06025: no backup of log thread 1 seq 186143 lowscn 5870286990828 found to restore
      RMAN-06025: no backup of log thread 1 seq 186142 lowscn 5870286983456 found to restore

      I was trying to restore the datafile 1.Nothing happening.
      Now I am trying to restore the DB from recent backup with help of "restore database'.

      I could not able to see the any events in v$session_longops.Nothing progressing...

      can you please suggest.

      Thanks
        • 1. Re: Restore Issue
          973259
          Hi Tippu,


          So I understand you have a full backup of 09'th Nov. May I Know exactly what are you trying to do.

          * are trying to restore the full backup only
          * or trying to recover till some specific time?

          If you are restoring the full backup only, then restore database alone would do. If not, then we need to look your exact requirements.

          Many Thanks,
          RaaM's.
          • 2. Re: Restore Issue
            494959
            I am trying to restore full backup only.
            • 3. Re: Restore Issue
              973259
              Ok, So use the below -

              rman target /
              rman> list backup (Make sure the database backup is valid and available)
              rman >run
              {
              restore database;
              alter database open;
              }
              • 4. Re: Restore Issue
                494959
                Hi ram,

                Restore database is happeneing, but nothing showing in v$session_longops view. yesterday I did restore.Today I tried to receover database. Given the above problem,
                So today I have started again the restore activity.
                • 5. Re: Restore Issue
                  973259
                  Ok. If you are restoring the database and was successful, then what is the issue here. What is the necessity to recover the database?

                  Also, it looks bit strange why the restore is not appearing in the v$session_longops. It should display in the view.

                  Is the database open now after the restoration?
                  • 6. Re: Restore Issue
                    494959
                    restore database was done.
                    When recover database happening , issue is below.

                    starting media recovery

                    Oracle Error:
                    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
                    ORA-01190: control file or data file 1 is from before the last RESETLOGS
                    ORA-01110: data file 1: '/oracle/PBW/sapdata1/system_1/system.data1'

                    RMAN-00571: ===========================================================
                    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                    RMAN-00571: ===========================================================
                    RMAN-03002: failure of recover command at 11/15/2012 09:17:21
                    RMAN-06053: unable to perform media recovery because of missing log
                    RMAN-06025: no backup of log thread 1 seq 186143 lowscn 5870286990828 found to restore
                    RMAN-06025: no backup of log thread 1 seq 186142 lowscn 5870286983456 found to restore
                    • 7. Re: Restore Issue
                      494959
                      Hi,

                      The issue is, first i have take the backup of database and then control file.
                      I am doing time in recovery from the backup.

                      I have to restore on the particular time.

                      Now I am set until time to eg"10:00".
                      I need restore the control file to 'location'

                      after this restore database
                      recover database.

                      Can you please let me know the above steps are OK.?

                      Thanks,
                      • 8. Re: Restore Issue
                        vk82
                        You need to restore & recover database until archive log sequence 18614 & 186142

                        $ sqlplus "/ as sysdba"
                        SQL> shutdown abort;
                        SQL> startup mount;
                        $ rman target
                        RMAN> restore database until sequence 186143;
                        RMAN> restore database until sequence 186142;
                        RMAN> recover database until sequence 186143;
                        RMAN> recover database until sequence 186142;
                        SQL> alter database open resetlogs;

                        Hope this will help you