This discussion is archived
11 Replies Latest reply: Oct 8, 2013 9:17 AM by nagulan.selvakumar RSS

RMAN Backup incremental

yxes2013 Newbie
Currently Being Moderated

Hi all,

 

11.2.0.1

Aix 6.1

 

 

Can I do backup incremental twice?

 

I have run backup incremental last week and It was successful. But now I run it again with the same syntax ....and I got error

 

RMAN> backup incremental from scn 1699827028 format '/backup/prod/stnd_backup_%U.bak';

 

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01009: syntax error: found ";": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, comma, ("

RMAN-01007: at line 1 column 79 file: standard input

 

 

Please help ...

 

Thanks,

zxy

  • 1. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    Ok now, I just retype it as is and it was successfull. I wonder why char is corrupted?

  • 2. Re: RMAN Backup incremental
    EdStevens Guru
    Currently Being Moderated

    yxes2013 wrote:

     

    Hi all,

     

    11.2.0.1

    Aix 6.1

     

     

    Can I do backup incremental twice?

     

    I have run backup incremental last week and It was successful. But now I run it again with the same syntax ....and I got error

     

    RMAN> backup incremental from scn 1699827028 format '/backup/prod/stnd_backup_%U.bak';

     

     

    RMAN-00571: ===========================================================

    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

    RMAN-00571: ===========================================================

    RMAN-00558: error encountered while parsing input commands

    RMAN-01009: syntax error: found ";": expecting one of: "archivelog, as, auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy, cumulative, current, database, datafilecopy, datafile, db_file_name_convert, db_recovery_file_dest, device, diskratio, duration, filesperset, force, format, for, from, full, incremental, keep, maxsetsize, nochecksum, noexclude, nokeep, not, pool, proxy, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, to, validate, comma, ("

    RMAN-01007: at line 1 column 79 file: standard input

     

     

    Please help ...

     

    Thanks,

    zxy

     

    Why are you specifying "from scn "?  It is not needed.  If you are taking a proper incremental backup, oracle already knows what to back up "from".

  • 3. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    Hi Ed,

     

    I am doing this to rebuild DR which has GAPs error, hence I need the scn where the primary is not sync with DR.

     

    Thanks

  • 4. Re: RMAN Backup incremental
    nagulan.selvakumar Journeyer
    Currently Being Moderated

    Hi,

     

    >> Ok now, I just retype it as is and it was successfull. I wonder why char is corrupted?


    If you even retype it as is, it will fail again. The reason is "database" keyword is missing.


    RMAN> backup incremental from scn 1699827028 format '/u01/%U';
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01009: syntax error: found ";": expecting one of: "archivelog, as, backup, backupset, blocks, channel, check, comma, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, full, force, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, skip, spfile, setsize, tablespace, tag, to, validate"
    RMAN-01007: at line 1 column 56 file: standard input
    RMAN> backup incremental from scn 1699827028 database format '/u01/%U';
    Starting backup at 26-SEP-13
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=145 devtype=DISK
    allocated channel: ORA_DISK_2
    channel ORA_DISK_2: sid=144 devtype=DISK
    RMAN-06755: WARNING: datafile 1: incremental-start SCN is too recent; using checkpoint SCN 2769470 instead
    RMAN-06755: WARNING: datafile 2: incremental-start SCN is too recent; using checkpoint SCN 2769470 instead
    RMAN-06755: WARNING: datafile 3: incremental-start SCN is too recent; using checkpoint SCN 2769470 instead
    RMAN-06755: WARNING: datafile 4: incremental-start SCN is too recent; using checkpoint SCN 2769470 instead
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00001 name=/u03/oradata/db10g/db10g_SYSTEM_01.dbf
    input datafile fno=00003 name=/u03/oradata/db10g/db10g_SYSAUX_01.dbf
    channel ORA_DISK_1: starting piece 1 at 26-SEP-13
    channel ORA_DISK_2: starting full datafile backupset
    ..
    ..
    ..

    I used the same scn that you used to simulate the error again (for demo case) but changed the format directory alone according to my environment.

     

    Also, you have marked the post "Answered" which is useful for nothing.

     

    Could you please simulate the successful RMAN backup with the same command you just retyped? (Just in case if it's working for you)

     

    Thank you!!


  • 5. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    Dear, we have different error. and you can not use my SCN because we have different time based setup. So expect that error. You can try lowering the SCN to match your setup and you will succeed

  • 6. Re: RMAN Backup incremental
    nagulan.selvakumar Journeyer
    Currently Being Moderated

    It is totally useless and waste of time to make you learn something.

     

    Did you ever find what is wrong with your statement till now that it throws out error? I surely say it's a big NO.

    I'll quit from now on.

     

    Thank you!!

  • 7. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    Wait dear, what do u want me to do again? rerun the command? ok I will do it same syntax. brb

  • 8. Re: RMAN Backup incremental
    nagulan.selvakumar Journeyer
    Currently Being Moderated

    Did you try this?

  • 9. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    I afraid our PROD will get error? Is it ok to run it over and over again?

  • 10. Re: RMAN Backup incremental
    yxes2013 Newbie
    Currently Being Moderated

    Yeah your are right dear I missed the key word "database"

     

    Thanks for your concern....You can sleep now.

  • 11. Re: RMAN Backup incremental
    nagulan.selvakumar Journeyer
    Currently Being Moderated

    You don't have to care if I sleep or not. Mark the correct answer as "Correct answer" and try to learn at least from now on.

    Don't use "dear". It sounds irritating when working on a public forum.

Legend

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