Oracle provides different multiple options to have a “backup& recovery” as per the organization’s requirements. Incomplete recovery is one of the types of recovery. Let’s have look on the incomplete recovery.
Check the archive log status

Create a test table with some records

Begin the backup mode

end the backup mode

create another table

Take the SCN and drop the tables and delete datafiles

Recover the datafile

Today’s thought

“I have had all of the disadvantages required for success.” Larry Ellison

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:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’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.