public:module:oracle:create_backup_set
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
public:module:oracle:create_backup_set [2021/04/20 16:42] ronnie.chan |
public:module:oracle:create_backup_set [2021/04/20 16:55] (current) ronnie.chan |
||
|---|---|---|---|
| Line 30: | Line 30: | ||
| 4. In the Backup Source menu, select the Oracle database(s) you would like to back up. Click Next to proceed. | 4. In the Backup Source menu, select the Oracle database(s) you would like to back up. Click Next to proceed. | ||
| - | | {{public:module:oracle:image049.png?700}} | | + | | {{public:module:oracle:image049.jpg?700}} | |
| <WRAP info> | <WRAP info> | ||
| - | 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. | + | * 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. |
| - | + | * Even if the “TEMP” is selected in the backup source, this database will be skipped during a backup job. | |
| - | Even if the “TEMP” is selected in the backup source, this database will be skipped during a backup job. | + | |
| </WRAP> | </WRAP> | ||
| Line 44: | Line 43: | ||
| There are two types of backup schedule: | There are two types of backup schedule: | ||
| - | · Tablespace Backup Schedule | + | * **Tablespace Backup Schedule** – This type of backup scheduler will automatically run weekly every Friday at 23:00. |
| - | · Archived Redo Log Backup Schedule | + | <WRAP indent> |
| + | | {{public:module:oracle:image052.png?700}} | | ||
| + | </WRAP> | ||
| - | Tablespace Backup Schedule – This type of backup scheduler will automatically run weekly every Friday at 23:00. | + | * **Archived Redo Log Backup Schedule** – This type of backup scheduler will automatically run weekly every Monday, Tuesday, Wednesday and Thursday at 23:00. |
| - | Archived Redo Log Backup Schedule – This type of backup scheduler will automatically run weekly every Monday, Tuesday, Wednesday and Thursday at 23:00. | + | <WRAP indent> |
| - | + | | {{public:module:oracle:image054.png?700}} | | |
| - | + | </WRAP> | |
| To change the backup schedule settings of an existing schedule, double-click the schedule to be modified. Otherwise, click Next to proceed. | To change the backup schedule settings of an existing schedule, double-click the schedule to be modified. Otherwise, click Next to proceed. | ||
| - | 6. In the Destination window, select a backup mode then click the button to add a backup storage destination. | + | 6. In the Destination window, select a backup mode then click the "+" button to add a backup storage destination. |
| + | |||
| + | | {{public:module:oracle:image058.png?700}} | | ||
| In the New Storage Destination / Destination Pool window, select the destination storage. Then, click OK to confirm your selection. | In the New Storage Destination / Destination Pool window, select the destination storage. Then, click OK to confirm your selection. | ||
| + | |||
| + | | {{public:module:oracle:image060b.png?700}} | | ||
| If Local / Mapped Drive / Network Drive / Removable Drive is selected, you need to specify the path by clicking Change to select the path or you can manually enter it. Once a network address is entered, This share requires access credentials check box will be enabled. Check the box beside it if access credentials are required to connect to the destination storage then enter the User name and Password. Otherwise, leave it unchecked. Click Test to check the connection. | If Local / Mapped Drive / Network Drive / Removable Drive is selected, you need to specify the path by clicking Change to select the path or you can manually enter it. Once a network address is entered, This share requires access credentials check box will be enabled. Check the box beside it if access credentials are required to connect to the destination storage then enter the User name and Password. Otherwise, leave it unchecked. Click Test to check the connection. | ||
| + | |||
| + | | {{public:module:oracle:image062.png?700}} | | ||
| When the Test completed successfully message is shown, click OK to proceed. | When the Test completed successfully message is shown, click OK to proceed. | ||
| - | 7. In the Destination window, your selected storage destination will be shown. Click Next to proceed. | + | | {{public:module:oracle:image064.png?700}} | |
| - | 8. In the Encryption window, the Encrypt Backup Data option is enabled by default with an encryption key preset by the system. | + | 7. In the Destination window, your selected storage destination will be shown. Click Next to proceed. |
| - | There are three (3) types of Encryption to choose from: | + | | {{public:module:oracle:image066b.png?700}} | |
| - | · Default – an encryption key with forty-four (44) alpha numeric characters will be randomly generated by the system. | + | 8. In the Encryption window, the Encrypt Backup Data option is enabled by default with an encryption key preset by the system. |
| - | · User password – the encryption key will be the same as the login password of your CloudBacko Pro at the time when this backup set is created. Please be reminded that if you change the CloudBacko Pro login password later, the encryption keys of the backup sets previously created with this encryption type will remain unchanged. | + | There are 2 types of Encryption to choose from: |
| - | · Custom – the encryption key can be customized where the user can select the Algorithm, Method and Key length, and then input an Encryption key. | + | * **Default** – an encryption key with forty-four (44) alpha numeric characters will be randomly generated by the system. |
| + | |||
| + | * **Custom** – the encryption key can be customized where the user can select the Algorithm, Method and Key length, and then input an Encryption key. | ||
| Click Next once done with the Encryption settings. | Click Next once done with the Encryption settings. | ||
| - | 9. If the Encryption feature is enabled in the previous step, the following window will pop-up whichever encryption type is selected. | + | 9. If the Encryption feature is enabled in the previous step, the following window will pop-up whichever encryption type is selected. |
| + | |||
| + | | {{public:module:oracle:image070.png?700}} | | ||
| This pop-up window has three (3) options to choose from: | This pop-up window has three (3) options to choose from: | ||
| - | · Unmask encryption key – The encryption key is masked by default. Click this option to display the encryption key. | + | * **Unmask encryption key** – The encryption key is masked by default. Click this option to display the encryption key. \\ {{public:module:oracle:image072.png?700}} |
| - | · Copy to clipboard – Select this option to copy the encryption key. Once copied, you can paste it to a text editor (e.g., Notepad) and save to a location. | + | * **Copy to clipboard** – Select this option to copy the encryption key. Once copied, you can paste it to a text editor (e.g., Notepad) and save to a location. |
| - | · Confirm – Select this option to exit the pop-up window and proceed to the next step. | + | * **Confirm** – Select this option to exit the pop-up window and proceed to the next step. |
| - | 10. After completing all the configuration settings, the Oracle database server backup set will be created. | + | 10. After completing all the configuration settings, the Oracle database server backup set will be created. |
| - | 11. According to Best Practices and Recommendations, it is highly recommended to set the temporary directory to another location other than Drive C: (e.g., Drive E:). To do this, click the Backup Sets icon on the CloudBacko Pro main interface, then select a backup set. Click Show advanced settings link. Go to Others > Temporary Directory and click the Change button to browse for another location. | + | | {{public:module:oracle:image074.png?700}} | |
| + | |||
| + | 11. According to Best Practices and Recommendations, it is highly recommended to set the temporary directory to another location other than Drive C: (e.g., Drive E:). To do this, click the Backup Sets icon on the CloudBacko Pro main interface, then select a backup set. Click Show advanced settings link. Go to Others > Temporary Directory and click the Change button to browse for another location. | ||
| + | |||
| + | | {{public:module:oracle:image076.png?700}} | | ||
| Tick the “Remove temporary files after backup” option. | Tick the “Remove temporary files after backup” option. | ||
| - | 12. Optional: Archived Log Deletion | + | 12. Optional: Archived Log Deletion |
| The deletion of the archived logs is enabled by default and archived logs more than 60 days are deleted from the Oracle database instance. This process is done after every databases and archived log backup job. | The deletion of the archived logs is enabled by default and archived logs more than 60 days are deleted from the Oracle database instance. This process is done after every databases and archived log backup job. | ||
| Line 100: | Line 115: | ||
| For example, if the Oracle database instance generates a lot of archived log files, you may want to reduce the number of days before they are deleted. | For example, if the Oracle database instance generates a lot of archived log files, you may want to reduce the number of days before they are deleted. | ||
| - | 13. Optional: Select your preferred Compression type. The compression type is set to Fast with optimization for local by default. To change the compression type, go to Others > Compressions. | + | | {{public:module:oracle:image078.png?700}} | |
| - | + | 13. Optional: Select your preferred Compression type. The compression type is set to Fast with optimization for local by default. To change the compression type, go to Others > Compressions. | |
| + | |||
| + | | {{public:module:oracle:image080.png?700}} | | ||
| Select from the following: | Select from the following: | ||
| - | · No Compression | + | * No Compression |
| + | |||
| + | * Normal | ||
| - | · Normal | + | * Fast (Compressed size larger than normal) |
| - | · Fast (Compressed size larger than normal) | + | * Fast with optimization for local |
| - | · Fast with optimization for local | + | | {{public:module:oracle:image082.png?700}} | |
| 14. Click Save to apply the changes. | 14. Click Save to apply the changes. | ||
public/module/oracle/create_backup_set.1618908165.txt.gz · Last modified: 2021/04/20 16:42 by ronnie.chan
Page Tools
