1 2 Previous Next 19 Replies Latest reply: Feb 11, 2013 6:32 AM by DB RSS

    i got the above error while i restore the standby database using RMAN backu

    DB
      Dear All,
      RMAN> crosscheck archivelog all;
      
      using target database controlfile instead of recovery catalog
      allocated channel: ORA_DISK_1
      channel ORA_DISK_1: sid=14 devtype=DISK
      specification does not match any archive log in the recovery catalog
      i got the above error while i restore the standby database using RMAN backup from production.
      Help need.i take the backup without catalog database.

      regards,
      DB
        • 1. Re: i got the above error while i restore the standby database using RMAN backu
          asahide
          Hi,

          Could you put V$ARCHIVED_LOG ?
          And control_file_record_keep_time (init.ora).

          Regards,
          • 2. Re: i got the above error while i restore the standby database using RMAN backu
            Mihael
            i got the above error while i restore the standby database using RMAN backup from production.
            Help need.i take the backup without catalog database.
            this is not error, this only shows that there are no archivelogs registered in controlfile
            How you created standby database ? On what host you run this command ?
            • 3. Re: i got the above error while i restore the standby database using RMAN back
              DB
              1.RMAN DB backup and controlfile backup taken from production.
              2.both copy from production to DR.
              3.soft link created to that backup path.
              4.deleted all standby DBS folder datafiles,controlfile
              5.new standby controlfile was placed on DBS folder.
              6.MOUNTed the standby DB.
              7.Now RMAN target /
              8.RMAN>list backup summary;

              RMAN>LIST backup summary;
              3475    B  F  X DISK        03-FEB-13       1       1       TAG20130203T200017
              3476    B  F  X DISK        03-FEB-13       1       1       TAG20130203T214222
              3477    B  F  X DISK        03-FEB-13       1       1       TAG20130203T214229
              3478    B  F  X DISK        06-FEB-13       1       1       06FEB13_FULL_xxxxx_DB
              3479    B  F  A DISK        09-FEB-13       1       1       09FEB13_FULL_xxxxx_DB
              3480    B  F  X DISK        09-FEB-13       1       1       TAG20130209T200021
              3481    B  F  A DISK        09-FEB-13       1       1       TAG20130209T212205
              3482    B  F  A DISK        09-FEB-13       1       1       TAG20130209T212212
              RMAN>restore database from tag '09FEB13_FULL_xxxxx_DB';
              RMAN-00571: ===========================================================
              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
              RMAN-00571: ===========================================================
              RMAN-03002: failure of restore command at 02/10/2013 14:05:05
              ORA-19505: failed to identify file "/oradatabkp/rman/xxxx_full_db_09feb13"
              ORA-27037: unable to obtain file status
              HP-UX Error: 2: No such file or directory
              Additional information: 3
              notice:db_name=*****
              version=9i
              os=hp_ux
              Please help me.

              Regards,
              DB.
              • 4. Re: i got the above error while i restore the standby database using RMAN back
                Mihael
                DB wrote:
                1.RMAN DB backup and controlfile backup taken from production.
                2.both copy from production to DR.
                3.soft link created to that backup path.
                4.deleted all standby DBS folder datafiles,controlfile
                5.new standby controlfile was placed on DBS folder.
                6.MOUNTed the standby DB.
                7.Now RMAN target /
                8.RMAN>list backup summary;

                RMAN>LIST backup summary;
                print here output of :

                rman> list backup;

                ls -l /oradatabkp
                ls -l /oradatabkp/rman
                • 5. Re: i got the above error while i restore the standby database using RMAN back
                  DB
                  rman> list backup;
                  it shows lengthier but i showed only the corresponding

                  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                  ------- ---- -- ---------- ----------- ------------ ---------------
                  3479    Full    17G        DISK        01:29:42     09-FEB-13
                          BP Key: 3479   Status: AVAILABLE   Tag: 09FEB13_FULL_ESMSRV1_DB
                          Piece Name: /oradatabkp/rman/esmsrv1_full_db_09feb13
                    SPFILE Included: Modification time: 08-FEB-13
                    List of Datafiles in backup set 3479
                    File LV Type Ckp SCN    Ckp Time  Name
                    ---- -- ---- ---------- --------- ----
                    1       Full 1759250260 09-FEB-13 /esmsrv1/dbs/system01.dbf
                    2       Full 1759250260 09-FEB-13 /esmsrv1/dbs/undotbs01.dbf
                    3       Full 1759250260 09-FEB-13 /esmsrv1/dbs/cwmlite01.dbf
                    4       Full 1759250260 09-FEB-13 /esmsrv1/dbs/drsys01.dbf
                    5       Full 1759250260 09-FEB-13 /esmsrv1/dbs/example01.dbf
                    6       Full 1759250260 09-FEB-13 /esmsrv1/dbs/indx01.dbf
                    7       Full 1759250260 09-FEB-13 /esmsrv1/dbs/odm01.dbf
                    8       Full 1759250260 09-FEB-13 /esmsrv1/dbs/tools01.dbf
                    9       Full 1759250260 09-FEB-13 /esmsrv1/dbs/users01.dbf
                    10      Full 1759250260 09-FEB-13 /esmsrv1/dbs/xdb01.dbf
                    11      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_default_seg_001.dbf
                    12      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_property_ind_seg_001.dbf
                    13      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_property_seg_001.dbf
                    14      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_upload_ind_seg_001.dbf
                    15      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_upload_seg_001.dbf
                    16      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_rate_ind_seg_001.dbf
                    17      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_rate_seg_001.dbf
                    18      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_summary_ind_seg_001.dbf
                    19      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_summary_seg_001.dbf
                    20      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_overflow_seg_001.dbf
                    21      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_overflow_seg_002.dbf
                    22      Full 1759250260 09-FEB-13 /esmsrv1/dbs/dpipe_summary_seg_002.dbf
                    23      Full 1759250260 09-FEB-13 /esmsrv1/dbs/perfstat_001.dbf
                    39      Full 1759250260 09-FEB-13 /esmsrv1/dbs/oem_repository.dbf
                  
                  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                  ------- ---- -- ---------- ----------- ------------ ---------------
                  3480    Full    17G        DISK        01:21:30     09-FEB-13
                          BP Key: 3480   Status: EXPIRED   Tag: TAG20130209T200021
                          Piece Name: /oradatabkp/rman/esmsrv1/esmsrv1_full_Feb09
                    SPFILE Included: Modification time: 08-FEB-13
                    List of Datafiles in backup set 3480
                    File LV Type Ckp SCN    Ckp Time  Name
                    ---- -- ---- ---------- --------- ----
                    1       Full 1759422265 09-FEB-13 /esmsrv1/dbs/system01.dbf
                    2       Full 1759422265 09-FEB-13 /esmsrv1/dbs/undotbs01.dbf
                    3       Full 1759422265 09-FEB-13 /esmsrv1/dbs/cwmlite01.dbf
                    4       Full 1759422265 09-FEB-13 /esmsrv1/dbs/drsys01.dbf
                    5       Full 1759422265 09-FEB-13 /esmsrv1/dbs/example01.dbf
                    6       Full 1759422265 09-FEB-13 /esmsrv1/dbs/indx01.dbf
                    7       Full 1759422265 09-FEB-13 /esmsrv1/dbs/odm01.dbf
                    8       Full 1759422265 09-FEB-13 /esmsrv1/dbs/tools01.dbf
                    9       Full 1759422265 09-FEB-13 /esmsrv1/dbs/users01.dbf
                    10      Full 1759422265 09-FEB-13 /esmsrv1/dbs/xdb01.dbf
                    11      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_default_seg_001.dbf
                    12      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_property_ind_seg_001.dbf
                    13      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_property_seg_001.dbf
                    14      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_upload_ind_seg_001.dbf
                    15      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_upload_seg_001.dbf
                    16      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_rate_ind_seg_001.dbf
                    17      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_rate_seg_001.dbf
                    18      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_summary_ind_seg_001.dbf
                    19      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_summary_seg_001.dbf
                    20      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_overflow_seg_001.dbf
                    21      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_overflow_seg_002.dbf
                    22      Full 1759422265 09-FEB-13 /esmsrv1/dbs/dpipe_summary_seg_002.dbf
                    23      Full 1759422265 09-FEB-13 /esmsrv1/dbs/perfstat_001.dbf
                    39      Full 1759422265 09-FEB-13 /esmsrv1/dbs/oem_repository.dbf
                  
                  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                  ------- ---- -- ---------- ----------- ------------ ---------------
                  3481    Full    4M         DISK        00:00:03     09-FEB-13
                          BP Key: 3481   Status: AVAILABLE   Tag: TAG20130209T212205
                          Piece Name: /oradatabkp/rman/esmsrv1/esmsrv1_controlfile_copy_Feb09
                    Controlfile Included: Ckp SCN: 1759462488   Ckp time: 09-FEB-13
                  
                  BS Key  Type LV Size       Device Type Elapsed Time Completion Time
                  ------- ---- -- ---------- ----------- ------------ ---------------
                  3482    Full    0          DISK        00:00:01     09-FEB-13
                          BP Key: 3482   Status: AVAILABLE   Tag: TAG20130209T212212
                          Piece Name: /oradatabkp/rman/esmsrv1/esmsrv1_spfile_copy_Feb09
                    SPFILE Included: Modification time: 08-FEB-13
                  ls -l /oradatabkp
                  root@drsrv1#ls -l /oradatabkp
                  total 1108672
                  drwxr-xr-x   2 ovsd       dba             96 Sep 27  2009 alert_bkp
                  -rw-r--r--   1 oracle     dba            195 Mar 15  2007 create.sql
                  drwxr-xr-x   2 oracle     dba           8192 Aug  7  2009 ctrl_bkp
                  -rw-r--r--   1 root       sys        565114880 Apr 24  2007 drsrv1.tar
                  drwxrwxrwx   2 root       sys             96 Jun 17  2011 drsrv2-ignitebkp
                  drwxr-xr-x   4 root       sys             96 Apr 24  2007 esmsrv1
                  -rw-r-----   1 root       sys        1613824 Feb 22  2007 esmsrv1stby.ctl
                  -rw-r--r--   1 esmsrv1    dba           5120 Dec 31  2009 esmtables.dmp
                  -rw-r--r--   1 esmsrv1    dba            538 Dec 31  2009 esmtables.log
                  drwxrwxrwx   4 root       sys           8192 Mar 10  2009 export
                  drwxr-xr-x   8 root       sys           8192 Apr 24  2007 finalbackup
                  -rw-r--r--   1 oracle     dba           3820 Sep  5  2008 invalid.sql
                  -rw-r--r--   1 esmsrv1    dba         303104 Dec 31  2009 kirdevports.dmp
                  -rw-r--r--   1 esmsrv1    dba            591 Dec 31  2009 kirdevports.log
                  drwxr-xr-x   2 root       root            96 Feb 12  2007 lost+found
                  -rw-r--r--   1 oracle     dba          24954 Aug  9  2009 ovcontrol-090909.ctl
                  drwxr-xr-x  22 root       sys           8192 Apr 24  2007 ovpi
                  drwxr-xr-x   2 oracle     dba           8192 Aug  7  2009 pfile_bkp
                  drwxrw-rw-   4 oracle     dba           8192 Feb 10 15:25 rman
                  drwxr-xr-x  28 root       sys           8192 Feb  1 17:15 schedbkp
                  drwxr-xr-x   2 oracle     dba           8192 Jul 11  2011 sdnnm
                  -rw-r--r--   1 esmsrv1    dba           2196 Dec 31  2009 srirdevports.log
                  drwxr-xr-x   2 oracle     dba             96 Mar 13  2009 statsreport
                  -rw-r--r--   1 oracle     dba            966 Mar 15  2007 tbs.sql
                  drwxr-xr-x   5 oracle     dba             96 Mar 16  2007 testov
                  drwxr-xr-x   2 root       sys         442368 Mar 11  2009 trendadm_files
                  
                  
                  root@drsrv1#ls -l /oradatabkp/rman
                  total 37244448
                  drwxr-xr-x   2 oracle     dba           8192 Feb 10 15:25 esmsrv1
                  -rw-r-----   1 oracle     dba        19068198912 Feb  9 14:21 esmsrv1_full_db_09feb13
                  drwxrw-rw-   2 oracle     dba           8192 Feb  9 21:36 openview
                  -rw-r--r--   1 oracle     dba         920442 Feb  9 21:37 rmanbkp-all.log
                  • 6. Re: i got the above error while i restore the standby database using RMAN back
                    Mihael
                    use "crosscheck backup" to find that your backup is available for rman
                    • 7. Re: i got the above error while i restore the standby database using RMAN back
                      DB
                      now it tells as EXPIRED
                      backup piece handle=/oradatabkp/rman/esmsrv1_full_db_09feb13 recid=3479 stamp=806935889
                      crosschecked backup piece: found to be 'EXPIRED'
                      backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_full_Feb09 recid=3480 stamp=806961659
                      crosschecked backup piece: found to be 'EXPIRED'
                      backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_controlfile_copy_Feb09 recid=3481 stamp=806966529
                      crosschecked backup piece: found to be 'EXPIRED'
                      backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_spfile_copy_Feb09 recid=3482 stamp=806966533
                      Crosschecked 160 objects
                      same EXPIRED on
                      List backup summary;
                      • 8. Re: i got the above error while i restore the standby database using RMAN back
                        Mihael
                        backup piece handle=/oradatabkp/rman/esmsrv1_full_db_09feb13 recid=3479 stamp=806935889
                        crosschecked backup piece: found to be 'EXPIRED'
                        backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_full_Feb09 recid=3480 stamp=806961659
                        crosschecked backup piece: found to be 'EXPIRED'
                        backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_controlfile_copy_Feb09 recid=3481 stamp=806966529
                        crosschecked backup piece: found to be 'EXPIRED'
                        backup piece handle=/oradatabkp/rman/esmsrv1/esmsrv1_spfile_copy_Feb09 recid=3482 stamp=806966533
                        Crosschecked 160 objects
                        So, rman can't find any backup. Check file names and paths.
                        • 9. Re: i got the above error while i restore the standby database using RMAN back
                          970966
                          Hi DB,

                          Can you try steps on below ;

                          - rman target /
                          - catalog start with '/oradatabkp/';
                          - sqlplus / as sysdba
                          - select * from v$backup_files; (Check backup files)
                          • 10. Re: i got the above error while i restore the standby database using RMAN back
                            Mihael
                            - rman target /
                            - catalog start with '/oradatabkp/';
                            He is using Oracle 9i.
                            • 12. Re: i got the above error while i restore the standby database using RMAN back
                              DB
                              -now i got new controlfile backup from production
                              -in that it seems available(backup)
                              3478    B  F  X DISK        06-FEB-13       1       1       06FEB13_FULL_ESMSRV1_DB
                              3479    B  F  A DISK        09-FEB-13       1       1       09FEB13_FULL_ESMSRV1_DB
                              3480    B  F  X DISK        09-FEB-13       1       1       TAG20130209T200021
                              3481    B  F  A DISK        09-FEB-13       1       1       TAG20130209T212205
                              3482    B  F  A DISK        09-FEB-13       1       1       TAG20130209T212212
                              again same error occur:
                              RMAN> restore database from tag '09FEB13_FULL_ESMSRV1_DB';
                              
                              Starting restore at 10-FEB-13
                              
                              allocated channel: ORA_DISK_1
                              channel ORA_DISK_1: sid=14 devtype=DISK
                              channel ORA_DISK_1: starting datafile backupset restore
                              channel ORA_DISK_1: specifying datafile(s) to restore from backup set
                              restoring datafile 00001 to /esmsrv1/dbs/system01.dbf
                              restoring datafile 00002 to /esmsrv1/dbs/undotbs01.dbf
                              restoring datafile 00003 to /esmsrv1/dbs/cwmlite01.dbf
                              restoring datafile 00004 to /esmsrv1/dbs/drsys01.dbf
                              restoring datafile 00005 to /esmsrv1/dbs/example01.dbf
                              restoring datafile 00006 to /esmsrv1/dbs/indx01.dbf
                              restoring datafile 00007 to /esmsrv1/dbs/odm01.dbf
                              restoring datafile 00008 to /esmsrv1/dbs/tools01.dbf
                              restoring datafile 00009 to /esmsrv1/dbs/users01.dbf
                              restoring datafile 00010 to /esmsrv1/dbs/xdb01.dbf
                              restoring datafile 00011 to /esmsrv1/dbs/dpipe_default_seg_001.dbf
                              restoring datafile 00012 to /esmsrv1/dbs/dpipe_property_ind_seg_001.dbf
                              restoring datafile 00013 to /esmsrv1/dbs/dpipe_property_seg_001.dbf
                              restoring datafile 00014 to /esmsrv1/dbs/dpipe_upload_ind_seg_001.dbf
                              restoring datafile 00015 to /esmsrv1/dbs/dpipe_upload_seg_001.dbf
                              restoring datafile 00016 to /esmsrv1/dbs/dpipe_rate_ind_seg_001.dbf
                              restoring datafile 00017 to /esmsrv1/dbs/dpipe_rate_seg_001.dbf
                              restoring datafile 00018 to /esmsrv1/dbs/dpipe_summary_ind_seg_001.dbf
                              restoring datafile 00019 to /esmsrv1/dbs/dpipe_summary_seg_001.dbf
                              restoring datafile 00020 to /esmsrv1/dbs/dpipe_overflow_seg_001.dbf
                              restoring datafile 00021 to /esmsrv1/dbs/dpipe_overflow_seg_002.dbf
                              restoring datafile 00022 to /esmsrv1/dbs/dpipe_summary_seg_002.dbf
                              restoring datafile 00023 to /esmsrv1/dbs/perfstat_001.dbf
                              restoring datafile 00039 to /esmsrv1/dbs/oem_repository.dbf
                              RMAN-00571: ===========================================================
                              RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                              RMAN-00571: ===========================================================
                              RMAN-03002: failure of restore command at 02/10/2013 19:14:23
                              ORA-19505: failed to identify file "/oradatabkp/rman/esmsrv1_full_db_09feb13"
                              ORA-27037: unable to obtain file status
                              HP-UX Error: 2: No such file or directory
                              Additional information: 3
                              • 13. Re: i got the above error while i restore the standby database using RMAN back
                                Mihael
                                ls -l /oradatabkp/rman/esmsrv1_full_db_09feb13
                                file /oradatabkp/rman/esmsrv1_full_db_09feb13
                                • 14. Re: i got the above error while i restore the standby database using RMAN back
                                  DB
                                  root@drsrv1#ls -l /oradatabkp/rman/esmsrv1_full_db_09feb13
                                  -rw-r-----   1 oracle     dba        19068198912 Feb  9 14:21 /oradatabkp/rman/esmsrv1_full_db_09feb13
                                  1 2 Previous Next