10 Replies Latest reply: Nov 22, 2012 12:31 AM by user13376823 RSS

    rman duplicate ends with ERROR ORA-01547

    user13376823
      i am using this script to take rman full hot backup

      Please review if i can edit this script so that all archives generated at that time are backed up.


      #resync catalog;
      run
      {
      allocate channel c1 device type disk ;
      #allocate channel c2 device type disk ;

      BACKUP DATABASE FORMAT '/opt/backup/proddb.fgho.com/proddb_%u_%p_%c' TAG = 'DAILY_FULL_BKP';
      #sql 'alter system switch logfile';
      #sql 'alter system archive log current';
      sql 'alter database backup controlfile to trace';
      BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES FORMAT '/opt/backup/proddb.fgho.com/Archlog%U' TAG = 'ARCHIVES_BKP';
      #DELETE NOPROMPT OBSOLETE REDUNDANCY =1 device type disk;
      DELETE NOPROMPT EXPIRED BACKUPSET OF DATABASE device type disk ;
      BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/opt/backup/proddb.fgho.com/CONTROL_FILE_PROD_%U' TAG = 'CONTROL_BKP';
      #BACKUP SPFILE FORMAT '/opt/R12Backups/rman/spfile_%U';
      crosscheck backup;
      crosscheck archivelog all;
      delete noprompt obsolete;

      release channel c1;
      #release channel c2;

      }
        • 1. Re: rman duplicate ends with ERROR ORA-01547
          user13376823
          i get these errors :

          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: '/opt/R12.1.3/oracle/db/apps_st/data/system01.dbf'
          • 2. Re: rman duplicate ends with ERROR ORA-01547
            user13376823
            can this strategy work that i write another small script for rman

            run

            { allocate channel c1 type disk
            sql 'alter system switch logfile';
            BACKUP ARCHIVELOG ALL not backed up 1 time;
            release channel c1;
            }

            and i execute this script manually before running RAN duplicate command and copy generated backup of archivelogs to test server so i will not face

            error recover succeded but open resetlogs would get error below

            please guide me
            • 3. Re: rman duplicate ends with ERROR ORA-01547
              rcc50886
              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: '/opt/R12.1.3/oracle/db/apps_st/data/system01.dbf'
              do a recovery operation at duplicate site.
              rman> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
              It will prompts to apply some archivelogs with particular sequence numbers, so apply them and if they are not available then copy those from the source database.

              apply couple of logas then open the database with resetlogs.

              -Thanks
              • 4. Re: rman duplicate ends with ERROR ORA-01547
                user13376823
                i did that and database is opened with resetlogs option.

                but in R12.1.1 post clone script is not completed successfully if databse is opened with resetlogs option.

                alter database open resetlogs ; ( now database is opened successfully ).

                perl adcfgclone.pl dbconfig /opt/R12.1.3/oracle/db/tech_st/11.1.0/appsutil/TEST8002_testing.xml

                *( Here comes error ) rc-50004 error occurred in applydatabase control file creation failed*


                what we do in that case then ??

                Edited by: user13376823 on Nov 15, 2012 10:58 PM
                • 5. Re: rman duplicate ends with ERROR ORA-01547
                  user13376823
                  is there any way that we never face this error message ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below ??
                  • 6. Re: rman duplicate ends with ERROR ORA-01547
                    rcc50886
                    RESETLOG operation is necessary if we restore the database using the backup controlfile.

                    I don't know about the R12 app but you want to take cold backup of source database and restore it different server to avoid the RESETLOG.

                    -Thanks
                    • 7. Re: rman duplicate ends with ERROR ORA-01547
                      user13376823
                      Dear what you are advising is not possible.

                      PLease any other work around.
                      • 8. Re: rman duplicate ends with ERROR ORA-01547
                        Seberg
                        While Duplicating the Database ,Rman Errors ora-1547,ora-1152,ora-1110 During Recovery [ID 274118.1]
                        • 9. Re: rman duplicate ends with ERROR ORA-01547
                          user13376823
                          the above metalink id (While Duplicating the Database ,Rman Errors ora-1547,ora-1152,ora-1110 During Recovery [ID 274118.1]) also points towards what i said before :

                          i write another small script for rman

                          run

                          { allocate channel c1 type disk
                          sql 'alter system switch logfile';
                          BACKUP ARCHIVELOG ALL not backed up 1 time;
                          release channel c1;
                          }

                          and i execute this script manually before running RAN duplicate command and copy generated backup of archivelogs to test server.
                          • 10. Re: rman duplicate ends with ERROR ORA-01547
                            user13376823
                            run
                            {
                            allocate channel c1 device type disk ;
                            #allocate channel c2 device type disk ;

                            BACKUP DATABASE FORMAT '/opt/backup/proddb.fgho.com/proddb_%u_%p_%c' TAG = 'DAILY_FULL_BKP';
                            #sql 'alter system switch logfile';
                            sql 'alter system archive log current'; *( i activated this statement . before it was in-activated. but still i get error that no backup of archivelog for thread 1 with sequence ........)*
                            sql 'alter database backup controlfile to trace';
                            BACKUP ARCHIVELOG ALL NOT BACKED UP 1 TIMES FORMAT '/opt/backup/proddb.fgho.com/Archlog%U' TAG = 'ARCHIVES_BKP';
                            #DELETE NOPROMPT OBSOLETE REDUNDANCY =1 device type disk;
                            DELETE NOPROMPT EXPIRED BACKUPSET OF DATABASE device type disk ;
                            BACKUP AS COPY CURRENT CONTROLFILE FORMAT '/opt/backup/proddb.fgho.com/CONTROL_FILE_PROD_%U' TAG = 'CONTROL_BKP';
                            #BACKUP SPFILE FORMAT '/opt/R12Backups/rman/spfile_%U';
                            crosscheck backup;
                            crosscheck archivelog all;
                            delete noprompt obsolete;

                            release channel c1;
                            #release channel c2;

                            }



                            what will u suggest how to avaoid such errors while rman duplicate ?