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
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