Oracle Backup & Restore

From Tom's notes
Revision as of 15:47, 6 April 2016 by 193.121.160.69 (talk) (Created page with "Script to create a backup of all archivelogs and remove them <source lang="sh"> export ORACLE_SID=MYSID export ORACLE_HOME=/oracle/product/11.2/dbhome_1 export PATH=$PATH:$ORA...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Script to create a backup of all archivelogs and remove them 

export ORACLE_SID=MYSID
export ORACLE_HOME=/oracle/product/11.2/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
rman target / <<EOF
backup archivelog all delete input;
exit;
EOF
Retrieved from "https://www.hacks.be/wiki/index.php?title=Oracle_Backup_%26_Restore&oldid=35"