4 Replies Latest reply: Mar 25, 2009 1:43 AM by 678145 RSS

    ORA-00283

    143894
      Hello

      I am using Oracle XE on Linux. I want to create a backup server in case my production server is down the backup server has the most recent backup available.

      To do this I taken a Cold backup of the Production DB and copied the files at the same location at my Backup server. Backup DB started fine.

      From onwards I don't want to down my Production server and therefore I taken the backup of production controlfile by using
         ALTER DATABASE BACKUP CONTROLFILE ........
      Then I copied all the archivelogs from production to the Backup server. On the backup server I connected SQL Plus and wrote:
      SQL> startup mount;
      ORACLE instance started.
      
      Total System Global Area  536870912 bytes
      Fixed Size                  1259932 bytes
      Variable Size             427820644 bytes
      Database Buffers          104857600 bytes
      Redo Buffers                2932736 bytes
      Database mounted.                        
      SQL> recover database using backup controlfile;
      ORA-00279: change 27442002 generated at 03/23/2009 10:05:52 needed for thread 1
      ORA-00289: suggestion :                                                        
      /home/omer/flash_recovery_area/XE/archivelog/2009_03_24/o1_mf_1_3167_%u_.arc   
      ORA-00280: change 27442002 for thread 1 is in sequence #3167                   
      
      
      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
      
      ORA-00283: recovery session canceled due to errors
      ORA-00354: corrupt redo log block header
      ORA-00353: log corruption near block 43565 change 3028861204237 time 03/23/2009
      10:05:52
      ORA-00334: archived log:
      '/home/oracle/flash_recovery_area/XE/archivelog/2009_03_22/o1_mf_1_3167_4wf77s3d_.
      arc'
      
      
      ORA-01112: media recovery not started
      Kindly help me in doing this.

      Habib
        • 1. Re: ORA-00283
          678145
          H a b i b wrote:
          SQL> recover database using backup controlfile;
          ORA-00279: change 27442002 generated at 03/23/2009 10:05:52 needed for thread 1
          ORA-00289: suggestion :
          /home/omer/flash_recovery_area/XE/archivelog/2009_03_24/o1_mf_1_3167_%u_.arc
          ORA-00280: change 27442002 for thread 1 is in sequence #3167


          Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

          ORA-00283: recovery session canceled due to errors
          ORA-00354: corrupt redo log block header
          ORA-00353: log corruption near block 43565 change 3028861204237 time 03/23/2009
          10:05:52
          ORA-00334: archived log:
          '/home/oracle/flash_recovery_area/XE/archivelog/2009_03_22/o1_mf_1_3167_4wf77s3d_.
          arc'
          You have corrupted archive log. Maybe during copying not all file copied. Copy once more this particular file from production server and try again to recover.
          • 2. Re: ORA-00283
            143894
            Hello Laura

            Thanks for the prompt response. I already tried to copy again the files from the production. In fact I also matched the md5 checksum of both the copies. They are the same.

            Since both the machines are at different physical locations and there is a low bandwidth between them I have to compress the files. I first try to create a tar.gz file and in the second attempt i created a zip file. Results are the same.

            Any further help will be appreciated.

            Habib
            • 3. Re: ORA-00283
              Srini Chavali-Oracle
              >
              To do this I taken a Cold backup of the Production DB and copied the files ...
              >

              A true cold backup will not cause this error to occur. Can you pl verify that the database was really shutdown when you did the cold backup and that all files (datafiles, redo, control) were copied correctly without any errors ?

              HTH
              Srini
              • 4. Re: ORA-00283
                678145
                Then it can be that file is corrupted. You can't then use this file for recovery, it is damaged.
                Do you have some other backup of this file?

                Error: ORA 353
                Text: log corruption near block <num> change <str >time <str>
                Cause: Some type of redo log file corruption has been discovered.
                This message describes the location of the corruption.
                Other messages will accompany this message and describe the type of
                corruption.
                Action: Perform recovery with a good version of the redo log file or perform
                incomplete recovery up to the indicated change or time.
                For more information about recovery and incomplete recovery, see the
                index entries on "recovery, incomplete" and on "redo log files" in
                <Oracle7 Server Concepts>.