Blog: Medium Images

Oracle ORA-1157 Troubleshooting

Posted by PDSERVICE April 06, 2020 0 comments

PURPOSE

This note is intended to list the common reasons and solutions for the ORA-1157 error.

SCOPE

How to Recover from a Lost or Deleted Oracle Datafile with Different Scenarios

Posted by PDSERVICE April 06, 2020 0 comments

PURPOSE

This article explains the various scenarios for ORA-01157 and how to avoid them.

SCOPE & APPLICATION

Recreating a missing Oracle datafile with no backups

Posted by PDSERVICE April 06, 2020 0 comments

GOAL

How to recreate a datafile that is missing at the operating system level. Missing/inaccessible files may be reported with one or more of these errors:

How to Recover an Oracle Database Having Added a Datafile Since Last Backup

Posted by PDSERVICE April 06, 2020 0 comments

NOTE: In the images and/or the document content below, the user information and environment

data used represents fictitious data from the Oracle sample schema(s), Public Documentation

You are here

Blog: Medium Images

Oracle ORA-1157 Troubleshooting

How to Recover from a Lost or Deleted Oracle Datafile with Different Scenarios

Recreating a missing Oracle datafile with no backups

How to Recover an Oracle Database Having Added a Datafile Since Last Backup

Pages