1 2 Previous Next 15 Replies Latest reply: Jul 19, 2010 11:30 AM by my_oracle RSS

    Recover redo.log

    my_oracle
      Hi,

      some silly scenario with RMAN
      remove redo.log1 from o/s Level
      so using Rman Full back is it Possible to recover the Database

      Needs Legends suggestion


      Thank you
        • 1. Re: Recover redo.log
          rajeysh
          1.shutdown db
          2.move redo log files
          3.startup db
          SQL> startup
          ORACLE instance started.
          
          Total System Global Area 135338868 bytes
          Fixed Size 453492 bytes
          Variable Size 109051904 bytes
          Database Buffers 25165824 bytes
          Redo Buffers 667648 bytes
          Database mounted.
          ORA-00313: open failed for members of log group 1 of thread 1
          ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\DB3\REDO01.LOG'
          
          4. select first_change# from v$log ;
          FIRST_CHANGE#
          -------------
          396376
          5.rman connect target /
          6.RMAN> restore database until scn 396375;
          7.RMAN> recover database until scn 396375;
          8. SQL> alter database open resetlogs;
          one suggestion, mark the thread as answered if you get satisfied replies for your question.
          Handle:      journey
          Status Level:      Newbie (25)
          Registered:      Jun 18, 2009
          Total Posts:      218
          Total Questions:      57 (50 unresolved)
          • 2. Re: Recover redo.log
            my_oracle
            rajesh

            i did steps like this and recover
            rm *.log
            Bounce database
            ORA-00313: open failed for members of log group 1 of thread 1
            ORA-00312: online log 1 thread 1: 'dbvol/test/data\redo01.log'
            
            Rman>restore database;
            RMAN>recover database;
            RMAN-11003:failure during parse execution
            ORA-recovery session canceled due to errors 
            unable to obtain file status
            RMAN>exit
            sqlplus / as sysdba
            startup mount
            sql>alter database open;
            Must use open resetlogs to open database
            alter database open resetlogs;
            database altered 
            i have doubt that Rman recover database was errror out and after that i check on o/s physical redo.log was not Available
            then after i use openresetlogs its done and present on o/s level so cani say this recovery is not done by RMAN !!!!!!!!!!!

            Edited by: journey on Jul 19, 2010 3:40 AM
            • 3. Re: Recover redo.log
              my_oracle
              Rajesh,
              i followed the steps u suggested 
              1.shutdown db
              2.move redo log files
              3.startup db
              SQL> startup
              ORACLE instance started.
               
              Total System Global Area 135338868 bytes
              Fixed Size 453492 bytes
              Variable Size 109051904 bytes
              Database Buffers 25165824 bytes
              Redo Buffers 667648 bytes
              Database mounted.
              ORA-00313: open failed for members of log group 1 of thread 1
              ORA-00312: online log 1 thread 1: 'C:\ORACLE\ORADATA\DB3\REDO01.LOG'
               
              4. select first_change# from v$log ;
              FIRST_CHANGE#
              -------------
              396376
              5.rman connect target / 
              6.RMAN> restore database until scn 396375;
              
              startup mount
              alter database open
              ORA-01190: control file or data file 1 is from before the last RESETLOGS 
              ORA-01110: data file 1 : '/dbvol/demo/system01.dbf'
              the database not recover as per ur steps 
              • 4. Re: Recover redo.log
                rajeysh
                The loss of all members of an online redo log group causes Oracle software to terminate the instance. If only some members of a log file group cannot be written, they will not be used until they become accessible. The views V$LOGFILE and V$LOG contain more information about the current status of log file members.

                To add a new member to a redo log group, issue the following statement:

                SQL> ALTER DATABASE ADD LOGFILE MEMBER 'log_file_name' REUSE TO GROUP n

                You can issue this statement even when the database is open, without affecting database availability.

                If all members of an inactive group that has been archived are lost, the group can be dropped and re-created.

                show the output of the

                select * from v$log and select * from v$logfile;
                • 5. Re: Recover redo.log
                  rajeysh
                  # Clear A Log File If It Has Become Corrupt:
                  ALTER DATABASE CLEAR LOGFILE GROUP group_number;
                  # This statement overcomes two situations where dropping redo logs is not possible: If there are only two log groups and if the corrupt redo log file belongs to the current group:
                  ALTER DATABASE CLEAR LOGFILE GROUP 4;
                  # Clear A Log File If It Has Become Corrupt And Avoid Archiving:
                  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP group_number;
                  # Use this version of clearing a log file if the corrupt log file has not been archived:
                  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

                  refer oracle documentation for more information. managing redolog files chapter .
                  recover online redolog file from backup and recovery basics documentation.
                  • 6. Re: Recover redo.log
                    my_oracle
                    select *From v$logfile
                    
                    GROUP#  TYPE    MEMBER
                    3           ONLINE  /redo01.log
                    2           ONLINE /redo02.log
                    1           ONLINE /redo03.log
                    this querry showing redo1a.log is ONLINE status i mv this redo1.log as per you steps
                    • 7. Re: Recover redo.log
                      rajeysh
                      you did rman recovery so after recovery it show online, thats it. also check status from v$log view. it will show the status as unused for redoa1.log.

                      Edited by: rajeysh on Jul 19, 2010 5:23 PM
                      • 8. Re: Recover redo.log
                        my_oracle
                        select *from v$log;

                        group status
                        1 cuurent
                        2 INACTIVE
                        3 INACTIVE

                        GROUP 1 IS SHOWING CURRENT WHY WHEN THERE IS NO redo01.log on O/S level as i said before
                        • 9. Re: Recover redo.log
                          rajeysh
                          refer the link and test yourself.
                          http://www.orafusion.com/art_rman2.htm#rec_logs

                          after restore did you issue the recover command or not?
                          • 10. Re: Recover redo.log
                            my_oracle
                            the link u refer is simply copy redo from multiplex location but i dont have redo at amulti location
                            My advice to you don't suggest anything in Air if you don't know you first test by yourself then follow the Threads so Chill !!!!
                            • 11. Re: Recover redo.log
                              rajeysh
                              refer the oracle online documentation:Recovering After the Loss of Online Redo Log Files: Scenarios
                              http://youngcow.net/doc/oracle10g/backup.102/b14191/recoscen008.htm

                              hope, this will helps you.

                              Edited by: rajeysh on Jul 19, 2010 6:06 PM
                              • 12. Re: Recover redo.log
                                my_oracle
                                Dear Rajesh

                                steps in Case2 i tried already but i try my self this and get the database up

                                alter database recover automatic;
                                alter database recover automatic using backup controlfile until cancel;
                                alter database open;
                                ORA-01156 recovery in progress may need access to files

                                alter database open resetlogs;
                                database altered

                                this way i completed the recovery successfully

                                Hope it will be helpful to other also

                                thank you
                                • 13. Re: Recover redo.log
                                  my_oracle
                                  refer the oracle online documentation:Recovering After the Loss of Online Redo Log Files: Scenarios
                                  http://youngcow.net/doc/oracle10g/backup.102/b14191/recoscen008.htm
                                  
                                  hope, this will helps you.
                                  Thank you i completed my Recovery successful
                                  • 14. Re: Recover redo.log
                                    resistanceIsFruitful
                                    My advice to you don't suggest anything in Air if you don't know you first test by yourself then follow the Threads so Chill !!!!

                                    Thanks for being so appreciative and grateful Journey. Rajeysh here is a selfless volunteer who has absolutely no obligations to help you. If you need dedicated support, contact MOS .

                                    Which part of northern india are you from, you C*^nt?
                                    Melal immathiri kunnatharam ivide paranjal ninte chella adichu njan pottikkum poorimone !
                                    1 2 Previous Next