Backup & Restore Database - rahulstackio/Data-Architect GitHub Wiki

Backup

Starting rman for backup

Check the list of backup

delete backup

Backup Database

Backup spfile

Backup current controlfile

Backup datafile'u01/app/oracle/oradata/ORCL/users01.dbf'

Backup tablespace users

Backup incremental level 0 database;

Backup incremental level 1 database;

Restore

Backup database plus archivelog

If SPfile is removed

Removing spfile

Starting a database without a spfile

Restoring SPfile

Starting up in Nomount

Restoring spfile

If Control file is missing