13.1. individual delete all datafile and restore (only datafiles ). - sayanbhattacharya1234/Oracle_DBA GitHub Wiki

if backup not work by offline , you have to shutdown the database and start database mount state . and goto rman > restore > recover > alter database open.

1. USERS datafile backup delete and restore.

Step 1 : Take backup of a datafile with ID.

Step 2: Delete that datafile and check it from datafiles location:

Step 3: Offline the datafile or tablespace

Step 4: Goto RMAN > restore datafile > recover datafile :

Step 5: Online that datafile again:

Check the datafile is recover in that location:

2. SYSAUX datafile delete and restore , recover from backup;

3. SYSTEM datafile delete and restore , recover from backup; (mount state)

system tablesapce can't be offline so database shut down abort > we have to startup mount state then restore and recover and then alter database open.

4. UNDOTBS1 datafile delete and restore , recover from backup;

undotbs1 tablesapce can't be offline so database shut down > we have to startup mount state then restore and recover and then alter database open.

in undotbs1 datafile , tablespace cannot offline so db start with mount state.

5. I created a new DAMMY tablespace datafile dammy01.dbf - delete the file and restore , recover from backup .

6. SALES bigfile datafile delete and restore , recover from backup.