Let’s recover if some datafile is unavailable.

Let’s delete users01.dbf datafile which is in USERS tablespace.

Let’s try to create a table name A in tablespace Users.

We need to restore and recover the datafile. Restore means copy from backup, recover means applying changes since the backup is taken.

Restore datafile:

Recover datafile:

Checking:

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.