This discussion is archived
10 Replies Latest reply: Nov 21, 2012 10:31 PM by user13376823 RSS

rman duplicate ends with ERROR ORA-01547

user13376823 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Dear what you are advising is not possible.

    PLease any other work around.
  • 8. Re: rman duplicate ends with ERROR ORA-01547
    Acooper Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points