Backup & Restore Database

Backup

Starting rman for backup

Startup Database

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

Creating a temporary instance

Restoring spfile

### Checking the path of the backuped Spfile ### Restoring

If Control file is missing

### Restoring control file Finding the path of the backuped controlfile