Oracle RMAN Pocket Reference

Full Database Online Backup

For online backups, the database is open for use and must be in archivelog mode. If you’re using Oracle9i, the syntax can be fairly simple:

RMAN> backup database format 
2> '/d99/rmanback/brdstn/rman_%d_%t_%U.bus';

Note

Unlike traditional online (hot) backups, RMAN does not put tablespaces in backup mode. No extra redo is generated. For high-transaction databases, this can lead to significant resource savings.

Again, note that with Oracle8i, the syntax is a bit different with respect to the run{} command:

RMAN> run {
2> allocate channel d1 type disk;
3> backup database format        
4> '/d99/rmanback/brdstn/rman_%d_%t_%U.bus';
5> }