This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
public:module:oracle:best_practices [2021/04/20 16:35] ronnie.chan created |
public:module:oracle:best_practices [2021/04/20 16:37] (current) ronnie.chan |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== 3. Best Practices and Recommendations ====== | ====== 3. Best Practices and Recommendations ====== | ||
+ | ---- | ||
1. To enable a full Oracle database instance recovery, all databases including SYSAUX, SYSTEM, UNDOTBS1, USERS and related application databases except for “TEMP” must be selected in the backup source when creating the backup set. Otherwise, without a backup of these databases, a full Oracle database instance recovery will NOT be possible. | 1. To enable a full Oracle database instance recovery, all databases including SYSAUX, SYSTEM, UNDOTBS1, USERS and related application databases except for “TEMP” must be selected in the backup source when creating the backup set. Otherwise, without a backup of these databases, a full Oracle database instance recovery will NOT be possible. | ||
Line 19: | Line 20: | ||
Please refer to the following articles of Oracle Database Backup and Recovery User's Guide for details: | Please refer to the following articles of Oracle Database Backup and Recovery User's Guide for details: | ||
+ | |||
+ | <WRAP indent> | ||
**Oracle 19c** | **Oracle 19c** | ||
Line 31: | Line 34: | ||
[[https://docs.oracle.com/database/121/BRADV/title.htm]] | [[https://docs.oracle.com/database/121/BRADV/title.htm]] | ||
+ | |||
+ | </WRAP> | ||
7. To ensure an optimal backup/restoration performance, it is highly recommended to set the temporary directory folder to a local disk location with sufficient free disk space. It must be on another location other than Drive C: (e.g., Drive E:). | 7. To ensure an optimal backup/restoration performance, it is highly recommended to set the temporary directory folder to a local disk location with sufficient free disk space. It must be on another location other than Drive C: (e.g., Drive E:). |