Database backup is a representative copy of data; when the original data is lost, the backup can be used to reconstruct lost information. Backing up is the activity of copying files or databases so that they will be preserved in case of equipment failure or any other issues. Putting back the data in the system is called restoring them. Backup needs to be restored when the system is formatted for any reason. It is advised to always take backup at regular intervals in order to prevent loss of valuable information.
| Warning |
|---|
Note: The backup should ideally be taken in an external storage so that even if the system crashes, the data is safe. |
Pre-requisites
Please make sure you have followed the checklist below before taking backup:
The ORACLE export / import utility location is selected.
Tip To check the location follow the path: <Installed drive>\Oracle\Database\Ora12CDB\BIN
The Backup location is present.
Warning The system will not allow you to proceed if the Backup folder is absent and or there is insufficient privilege for file creation in selected backup location.
- The disk of your backup location has sufficient space available to store the backup.
- A proper database connection is present.
Step-by-step guide
The steps are as follows:
...