1 2 Previous Next 18 Replies Latest reply: Apr 3, 2012 1:22 AM by AvRossem RSS

    Restoring Database causes ORA-19612

    AvRossem
      Hello All,

      I have two oracle databases. 1 production, (PROD) and one for testing (TEST)
      (both servers: windows 2008 R2 server 64bit, oracle 11.2.0.1.0 64 bits)

      On production I am using a rman script for creating a backup:

      RUN
      {
      allocate channel backup_disk1 type disk format 'G:\RMANBackup\/%U';
      BACKUP database plus Archivelog;
      BACKUP CURRENT CONTROLFILE FORMAT 'g:\rmanbackup\Controlfile_CISORA1_%u%s%p';
      Backup Spfile to destination 'g:\rmanbackup\';
      Release channel backup_disk1;
      DELETE FORCE NOPROMPT OBSOLETE;
      }

      After this backup i have 3 files in the 'g:\rmanbackup\' directory.

      G5N5IBGA_1_1 (82 GB)
      G6N5IEFV_1_1 (6 mb)
      CFC-1057493243-20120310-00 (13MB)

      I copied these files to the TEST-server. I Also copy all archivelogs to that server also.
      All directories on source and targetserver are the same.
      On the 'TEST' server I restore the controlfile and then perform a restore database. That gives an error:

      channel ORA_DISK_1: ORA-19870: error while restoring backup piece G:\RMANBACKUP\
      G5N5IBGA_1_1
      ORA-19612: datafile 7 not restored due to missing or corrupt data
      failover to previous backup



      Please advise.

      Regards,
      Andre van Rossem
        • 1. Re: Restoring Database causes ORA-19612
          Kamran Agayev A.
          Check the explanation of the error you get:
          Description:     ORA-19612: datafile string not restored due to string
          Cause:     Cause: The indicated file could not be restored, because all of its data blocks were not found in the backup piece.
          Action:     Action: The restore conversation remains active, and the current piece must be re-processed. If the failure cannot be resolved by re-processing the current piece, then the restore conversation must be cancelled.
          http://oes.azot.az/ORA-19612.html

          This means that it's not available at the backup piece and wasn't backed up. Make sure you've backed up the mentioned file and it's available in the backup piece
          • 2. Re: Restoring Database causes ORA-19612
            AvRossem
            Thanks for the quick response. I do not understand WHY this backuppiece is not available in the backup set.
            I used: BACKUP database plus Archivelog; so ALL nescesarry files must be in the backup?!
            • 3. Re: Restoring Database causes ORA-19612
              Kamran Agayev A.
              user2823881 wrote:
              Thanks for the quick response. I do not understand WHY this backuppiece is not available in the backup set.
              I used: BACKUP database plus Archivelog; so ALL nescesarry files must be in the backup?!
              Could you please post the output of the following command?
              RMAN> list backup of datafile 7;
              • 4. Re: Restoring Database causes ORA-19612
                AvRossem
                On the Production Database:

                RMAN> list backup of datafile 7;


                List of Backup Sets
                ===================

                BS Key Type LV Size Device Type Elapsed Time Completion Time
                ------- ---- -- ---------- ----------- ------------ ---------------
                453 Full 78.70G DISK 00:50:55 11-MAR-12
                BP Key: 471 Status: AVAILABLE Compressed: NO Tag: TAG20120311T230017

                Piece Name: G:\RMANBACKUP\GBN5KVS2_1_1
                List of Datafiles in backup set 453
                File LV Type Ckp SCN Ckp Time Name
                ---- -- ---- ---------- --------- ----
                7 Full 2938941969 11-MAR-12 D:\ORACLEDATA\CIS2.DBF

                RMAN>
                • 5. Re: Restoring Database causes ORA-19612
                  Kamran Agayev A.
                  You mentioned that after backup following files were created:

                  G5N5IBGA_1_1 (82 GB)
                  G6N5IEFV_1_1 (6 mb)
                  CFC-1057493243-20120310-00 (13MB)

                  But the datafile 7 resides at the different backup piece:
                  Piece Name: G:\RMANBACKUP\GBN5KVS2_1_1
                  • 6. Re: Restoring Database causes ORA-19612
                    Shivananda Rao
                    ORA-19612: datafile 7 not restored due to missing or corrupt data
                    failover to previous backup
                    The file on the backup piece might be corrupted.

                    Try validating the backup set on the Source database and later transfer it to the auxiliary server and try to restore.
                    • 7. Re: Restoring Database causes ORA-19612
                      AvRossem
                      That's because the fact that the backup on production is created every day.
                      • 8. Re: Restoring Database causes ORA-19612
                        Kamran Agayev A.
                        user2823881 wrote:
                        That's because the fact that the backup on production is created every day.
                        Please post the output of the following command:
                        rman> restore datafile 7;
                        • 9. Re: Restoring Database causes ORA-19612
                          AvRossem
                          RMAN> restore datafile 7;

                          Starting restore at 12-MAR-12
                          using channel ORA_DISK_1

                          channel ORA_DISK_1: starting datafile backup set restore
                          channel ORA_DISK_1: specifying datafile(s) to restore from backup set
                          channel ORA_DISK_1: restoring datafile 00007 to D:\ORACLEDATA\CIS2.DBF
                          channel ORA_DISK_1: reading from backup piece G:\RMANBACKUP\G5N5IBGA_1_1
                          channel ORA_DISK_1: ORA-19870: error while restoring backup piece G:\RMANBACKUP\G5N5IBGA_1_1
                          ORA-19612: datafile 7 not restored due to missing or corrupt data

                          failover to previous backup

                          creating datafile file number=7 name=D:\ORACLEDATA\CIS2.DBF
                          Finished restore at 12-MAR-12

                          RMAN>

                          after this i tried:

                          RMAN> Recover Dataabse;

                          giving:
                          .......
                          archived log for thread 1 with sequence 51412 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51412_7OKN1LG0_.ARC
                          archived log for thread 1 with sequence 51413 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51413_7OKQKRQW_.ARC
                          archived log for thread 1 with sequence 51414 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51414_7OM9285H_.ARC
                          archived log for thread 1 with sequence 51415 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51415_7OMZ2LPK_.ARC
                          archived log for thread 1 with sequence 51416 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51416_7ON23R18_.ARC
                          archived log for thread 1 with sequence 51417 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_10\O1_MF_1_51417_7ONZC2WD_.ARC
                          archived log for thread 1 with sequence 51418 is already on disk as file C:\ORACLE\RECOVERY_AREA\CISORA1\ARCHIVELOG\2012_03_09\O1_MF_1_51418_7OO2BBVR_.ARC
                          Oracle Error:
                          ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
                          ORA-01194: file 1 needs more recovery to be consistent
                          ORA-01110: data file 1: 'D:\ORACLEDATA\CISORA1\SYSTEM01.DBF'

                          RMAN-00571: ===========================================================
                          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                          RMAN-00571: ===========================================================
                          RMAN-03002: failure of recover command at 03/12/2012 01:35:28
                          RMAN-06053: unable to perform media recovery because of missing log
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51419 and starting SCN of 2938534416 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51409 and starting SCN of 2937998525 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51406 and starting SCN of 2937738067 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51403 and starting SCN of 2937440017 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51400 and starting SCN of 2937180252 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51398 and starting SCN of 2936975106 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51397 and starting SCN of 2936767977 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51282 and starting SCN of 2927254768 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51281 and starting SCN of 2927247993 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51280 and starting SCN of 2927144802 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51279 and starting SCN of 2927135430 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51278 and starting SCN of 2927105359 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51277 and starting SCN of 2926967351 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51276 and starting SCN of 2926847236 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51275 and starting SCN of 2926840653 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51274 and starting SCN of 2926749230 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51273 and starting SCN of 2926649458 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51272 and starting SCN of 2926493880 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51271 and starting SCN of 2926468593 found to restore
                          RMAN-06025: no backup of archived log for thread 1 with sequence 51270 and starting SCN of 2926427643 found to restore
                          RMAN-00567: Recovery Manager could not print some error messages


                          RMAN> alter database open resetlogs;

                          RMAN-00571: ===========================================================
                          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                          RMAN-00571: ===========================================================
                          RMAN-03002: failure of alter db command at 03/12/2012 01:35:44
                          ORA-01194: file 1 needs more recovery to be consistent
                          ORA-01110: data file 1: 'D:\ORACLEDATA\CISORA1\SYSTEM01.DBF'

                          RMAN>
                          • 10. Re: Restoring Database causes ORA-19612
                            Talip Hakan Ozturk
                            Please post the output of following query:


                            SELECT pkey AS bs, fname AS backup_file_name, bd.file# AS file_number
                            FROM v$backup_files bf, v$backup_datafile bd
                            WHERE bf.bs_count = bd.set_count AND LOWER (bf.fname) LIKE '%g5n5ibga_1_1%'



                            Talip Hakan Ozturk
                            http://taliphakanozturken.wordpress.com/
                            • 11. Re: Restoring Database causes ORA-19612
                              AvRossem
                              on PRODUCTION-database:

                              Connected to:
                              Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
                              With the Partitioning, OLAP, Data Mining and Real Application Testing options

                              SQL> SELECT pkey AS bs, fname AS backup_file_name, bd.file# AS file_number FROM
                              v$backup_files bf, v$backup_datafile bd WHERE bf.bs_count = bd.set_count AND LOW
                              ER (bf.fname) LIKE '%g5n5ibga_1_1%';

                              no rows selected

                              SQL>
                              • 12. Re: Restoring Database causes ORA-19612
                                AvRossem
                                Somebody else who can help me?
                                • 13. Re: Restoring Database causes ORA-19612
                                  kuljeet singh -
                                  Datafile 7 reside on following backup piece which was created on 11 march 12.
                                  you can't restore the dbf file if this backup piece is not available.
                                  try to take another backup and restore it.

                                  BP Key: 471 Status: AVAILABLE Compressed: NO Tag: TAG20120311T230017
                                  Piece Name: G:\RMANBACKUP\*GBN5KVS2_1_1*
                                  • 14. Re: Restoring Database causes ORA-19612
                                    AvRossem
                                    Thanks for your reply.

                                    How I can i tell RMAN that RMAN always backups ALL pieces in one rman run?
                                    I want a daily rman backup with ALL backuppieces in it. I thought this was done using the 'BACKUP database plus Archivelog;' command, but that's not true..

                                    thanks for your help Kamran :-)
                                    1 2 Previous Next