Experiences after Oracle database recovery

1. After installing the Oracle database, You 'd better back up the entire Oracle folder before installing the application, because it is a "clean" database, similar to after installing the operating system, create a clean ghost. After the application is installed and no data has been added, You 'd better back up the entire Oracle folder;

2. When backing up system data, it is best to back up the log information at the same time, such as data export backup, it is best to back up the display information at the time of export, when the backup file is damaged, some clues can be found accordingly;

3. Multiple methods to back up the database at the same time. In addition to regular backup (such as data export), it is best to include unconventional backup, such as regular backup of Oracle physical data files, even the entire Oracle folder;

4. The longer the backup file is saved, the better, depending on the storage space;

5. Before the database is restored, check the application logs and database running logs (oracle/admin/SID/bdump/alert_SID.log) patiently to find out what happened;

6. Before the database is restored, it is best to back up the entire failed Oracle folder completely, because it is hard to say that the database is restored, and the database is worse;

7. Learn more and get familiar with Oracle.