We have seen an ERROR in the opening database. let’s recover it.

Step 1: Connect to the database and start the database using STARTUP command

We can see in the above output database is unable to open . And it threw an error that it cannot identify/lock data file 13.

Step 2: Let’s make it offline

oops..!! It gave me an error as this file does not belong to the CDB database. It belongs to the pdb database. Let’s change session to the pdb database and make it offline.

Step 3: connect to pdb and try to drop it.

Step 4: Again change session to CDB$ROOT and try the opening database

Step 5: Try opening the pdb database

Step 6: Change the current session to the pdb database

Step 7: Drop test tablespace

This is how we can recover the database if there will the loss of any data file and your database is in NOARCHIVELOG mode

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:

Telegram Channel: https://t.me/helporacle

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

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

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