RMAN bkp through oracle scheduler for noarchivelog mode db

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mitu08
    New Member
    • Aug 2014
    • 2

    RMAN bkp through oracle scheduler for noarchivelog mode db

    All,

    I am trying to schedule an RMAN backup through oracle scheduler jobs for a database which is noarchivelog mode. Below is the script i am trying and facing errors..
    Pls highlight the mistake

    Code:
    /ora/sw/app/oracle/product/11gr2/bin/rman target / nocatalog << EOF >  /ora/ls/$ORACLE_SID/log/`echo $ORACLE_SID`_daily_rmanbkp_`echo $dte`.log
    shutdown immediate
    startup mount
    backup database;
    SQL 'ALTER DATABASE OPEN';
    #backup as compressed backupset full database plus archivelog delete all input;
    sql "alter database backup controlfile to trace as ''/ora/b1/ctl/$ORACLE_SID/controlfile_$dte.txt'' ";
    EOF
Working...