DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: RMAN Controlfile Autobackup Problem

Hybrid View

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    RMAN Controlfile Autobackup Problem

    We are using 8.1.7

    C:\>rman target sys/gateway@wizmen nocatalog

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: WIZMEN (DBID=3460708078)
    RMAN-06009: using target database controlfile instead of recovery catalog

    i want to set automatically backup of control file when backup of full database have been taken
    i am using the following scipt for backup


    RMAN> run {allocate channel c1 type disk
    format 'c:\backup\%U';
    backup database;
    sql ‘alter system switch logfile current’;
    backup format 'c:\backup\arc_%t_%s_%p'
    archivelog all delete input;
    }

    and i when i use the following

    C:\>rman target sys/gateway@wizmen nocatalog

    Recovery Manager: Release 8.1.7.0.0 - Production

    RMAN-06005: connected to target database: WIZMEN (DBID=3460708078)
    RMAN-06009: using target database controlfile instead of recovery catalog

    RMAN> configure controlfile autobackup on;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "controlfile": expecting one of: "compatible"
    RMAN-01007: at line 1 column 11 file: standard input

    Is that option available in 8i if it is then why i am getting this problem
    can anybody help in this regard?

    i also have the following problems

    MAN> show

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter
    , beginline, catalog, change, connect, create, crosscheck, configure, debug, del
    ete, drop, exit, endinline, host, {, library, list, mount, open, print, register
    , release, replace, report, renormalize, reset, resync, rman, rpct·?"
    RMAN-01008: the bad identifier was: show
    RMAN-01007: at line 1 column 1 file: standard input

    RMAN> show all

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter
    , beginline, catalog, change, connect, create, crosscheck, configure, debug, del
    ete, drop, exit, endinline, host, {, library, list, mount, open, print, register
    , release, replace, report, renormalize, reset, resync, rman, rpct·?"
    RMAN-01008: the bad identifier was: show
    RMAN-01007: at line 1 column 1 file: standard input

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    thats a 9i command only

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    I'm being a bit testy today, so ignore this if your shields are down...

    I thought this was most ironic.

    "C:\>rman target sys/gateway@wizmen nocatalog"

    Wise men don't post sys passwords. To your credit, gateway IS better than change_on_install.

    Shields up,

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width