Backup from OEM doesn't work !!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Backup from OEM doesn't work !!!!

  1. #1
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24

    Exclamation

    Hi all,
    I'm on Sun Solaris platform with Oracle 8i and registered database on RMAN.
    Submitting a Backup Job from Enterprise Manager I get the following:
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    switch logfile executed

    Argument Value Description
    -----------------------------------------------------------------------------
    target quoted-string connect-string for target database
    rcvcat quoted-string connect-string for recovery catalog
    debug none if specified, activate debugging mode
    cmdfile quoted-string name of input command file
    msglog quoted-string name of output message log file
    trace quoted-string name of output debugging message log file
    append none if specified, msglog opened in append mode
    nocatalog none if specified, then no recovery catalog
    -----------------------------------------------------------------------------
    Both single and double quotes (' or ") are accepted for a quoted-string.
    Quotes are not required unless the string contains embedded white-space.

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00552: syntax error in command line arguments
    RMAN-01006: error signalled during parse
    RMAN-02003: unrecognized character:
    child process exited abnormally
    ,
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    Note: If I use Backup from RMAN prompt it works fine.

    Any ideas ??
    Thanks.
    Fabio Arienzo
    Rome (Italy)

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    First could you pl. give me more details on this including RMAN entries...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    May 2001
    Location
    Rome - Italy
    Posts
    24
    Ok Sambavan ...

    My job on Enterprise Manager console is a Backup Job with
    the following parameters built in by the OEM itself :

    run {
    allocate channel ch_disk type disk format '/usr/local/orabackup/dbflotte/b_%u_%s_%p';
    backup
    ( database include current controlfile );
    backup ( archivelog all delete input );
    }

    The output is in prev entry.
    It seems to be a sintax problem , but I can't recognize where,
    because the job show out just messages without input lines code !!!

    P.S.: The above backup script has token from the OEM by COPY and PAST keys, exactly as it is.

    OEM Ver 2.2.0.0.0 on Oracle 8i and Sun OS 5.8

    Stand by .....

    Thanks in advance.
    Fabio Arienzo
    Rome (Italy)

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Originally posted by farienzo


    run {
    allocate channel ch_disk type disk format '/usr/local/orabackup/dbflotte/b_%u_%s_%p';
    backup
    ( database include current controlfile );
    backup ( archivelog all delete input );
    }


    Code:
    run {
      #
      # Full DB backup
      #
      allocate channel ch_disk1 type disk;
      backup
           full
           tag backup_db_full
           filesperset 5
           format '/usr/local/orabackup/dbflotte/b_%u_%s_%p'; 
           (database include current controlfile);
      release channel ch_disk1;
      #
      # Archive the current log
      #
      sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
      #
      # Backup and delete all your archive logs
      #
      allocate channel ch_disk1 type disk;
      allocate channel ch_disk2 type disk;
      backup
        filesperset 20
        format '/usr/local/orabackup/dbflotte/arch_%d_t%t_s%s_p%p'
        archivelog all
             delete input;
       release channel ch_disk1;
       release channel ch_disk2;
    }
    Hope this would help you.
    Thanx
    Sam



    Life is a journey, not a destination!


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