public:module:oracle:restore
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:restore [2021/04/20 18:10] ronnie.chan |
public:module:oracle:restore [2021/04/20 18:20] (current) ronnie.chan |
||
|---|---|---|---|
| Line 278: | Line 278: | ||
| If you would like to enable the Verify checksum of in-file delta files during restore setting, click the Show advanced option link. | If you would like to enable the Verify checksum of in-file delta files during restore setting, click the Show advanced option link. | ||
| - | | {{public:module:oracle:image137.png?700}} | | + | | {{public:module:oracle:image167.png?700}} | |
| 10. Configure the following settings in the Alternate database screen: | 10. Configure the following settings in the Alternate database screen: | ||
| - | · Oracle Home – where the Oracle_Home path is located. This is already set to the location of the Oracle_Home by default. | + | * **Oracle Home** – where the Oracle_Home path is located. This is already set to the location of the Oracle_Home by default. |
| - | · Host – this value is set to 127.0.0.1. | + | * **Host** – this value is set to 127.0.0.1. |
| - | · Port – the new port number of the alternate Oracle database instance. | + | * **Port** – the new port number of the alternate Oracle database instance. |
| - | · SID – the new SID for the alternate Oracle database instance. | + | * **SID** – the new SID for the alternate Oracle database instance. |
| - | NOTE: If a restore will be performed to an alternate location, it is required to change the Oracle SID and port number. | + | <WRAP info> |
| + | If a restore will be performed to an alternate location, it is required to change the Oracle SID and port number. | ||
| + | </WRAP> | ||
| - | · Password – the password for the system user account in the new database. | + | * **Password** – the password for the system user account in the new database. |
| - | NOTE | + | <WRAP indent> |
| + | | {{public:module:oracle:image169.png?700}} | | ||
| + | </WRAP> | ||
| - | As the password validation is performed during the start of the actual restore process after the hostname, port number, SID, and all the database file locations are confirmed, ensure that you have entered the correct password in the Database Credentials. | + | <WRAP info> |
| - | + | * As the password validation is performed during the start of the actual restore process after the hostname, port number, SID, and all the database file locations are confirmed, ensure that you have entered the correct password in the Database Credentials. | |
| - | If a mistake in entering the correct password is made, this will result to a failed restore process and will require to go back at the beginning to start all the configuration settings again. Please refer to Appendix A for more details. | + | * If a mistake in entering the correct password is made, this will result to a failed restore process and will require to go back at the beginning to start all the configuration settings again. Please refer to Appendix A for more details. |
| + | </WRAP> | ||
| Once configured, click Next to proceed. | Once configured, click Next to proceed. | ||
| 11. Once the Oracle database instance has been modified, it will reflect on the original Database File Locations automatically. Click Next to proceed. | 11. Once the Oracle database instance has been modified, it will reflect on the original Database File Locations automatically. Click Next to proceed. | ||
| + | |||
| + | | {{public:module:oracle:image171.png?700}} | | ||
| + | |||
| + | | {{public:module:oracle:image173.png?700}} | | ||
| + | |||
| + | | {{public:module:oracle:image175.png?700}} | | ||
| 12. Make sure that the temporary directory path is correct. To change its location, click Browse then click OK to select. Click Restore to start the restore process. | 12. Make sure that the temporary directory path is correct. To change its location, click Browse then click OK to select. Click Restore to start the restore process. | ||
| + | |||
| + | | {{public:module:oracle:image177.gif?700}} | | ||
| 13. When this pop-up message appeared, enter the Windows user account password then click OK to continue with the restore process. | 13. When this pop-up message appeared, enter the Windows user account password then click OK to continue with the restore process. | ||
| + | |||
| + | | {{public:module:oracle:image178.png?700}} | | ||
| 14. Restore job has completed successfully. | 14. Restore job has completed successfully. | ||
| + | |||
| + | | {{public:module:oracle:image147.png?700}} | | ||
| 15. After the restore job is completed, verify if the Oracle database instance has been restored using the following SQL query to verify if the instance is online. | 15. After the restore job is completed, verify if the Oracle database instance has been restored using the following SQL query to verify if the instance is online. | ||
| + | <code> | ||
| C:\Users\Administrator>sqlplus / as sysdba | C:\Users\Administrator>sqlplus / as sysdba | ||
| Line 335: | Line 353: | ||
| SQL> | SQL> | ||
| + | </code> | ||
| ===== 8.4. Restore Raw File ===== | ===== 8.4. Restore Raw File ===== | ||
| Line 342: | Line 361: | ||
| 1. On the CloudBacko Pro main interface, click the Restore icon. | 1. On the CloudBacko Pro main interface, click the Restore icon. | ||
| + | |||
| + | {{public:module:oracle:image131.png}} | ||
| 2. Select the backup set that you would like to restore the Oracle database from. | 2. Select the backup set that you would like to restore the Oracle database from. | ||
| - | + | | {{public:module:oracle:image133.png?700}} | | |
| 3. Select the destination storage that contains the Oracle database(s) that you would like to restore from. | 3. Select the destination storage that contains the Oracle database(s) that you would like to restore from. | ||
| + | |||
| + | | {{public:module:oracle:image135.png?700}} | | ||
| 4. Click the Restore raw file option then select the Oracle database(s) to be restored. Click Next to proceed. | 4. Click the Restore raw file option then select the Oracle database(s) to be restored. Click Next to proceed. | ||
| + | |||
| + | | {{public:module:oracle:image137.png?700}} | | ||
| 5. Click Browse to select the location on the local machine where you wish to restore the Oracle database(s) to. Click Next to proceed. | 5. Click Browse to select the location on the local machine where you wish to restore the Oracle database(s) to. Click Next to proceed. | ||
| + | |||
| + | | {{public:module:oracle:image185.png?700}} | | ||
| If you would like to enable the Verify checksum of in-file delta files during restore setting, click the Show advanced option link. | If you would like to enable the Verify checksum of in-file delta files during restore setting, click the Show advanced option link. | ||
| + | |||
| + | | {{public:module:oracle:image187.png?700}} | | ||
| 6. Make sure that the temporary directory path is correct. To change its location, click Browse then click OK to select. Click Restore to start the restore process. | 6. Make sure that the temporary directory path is correct. To change its location, click Browse then click OK to select. Click Restore to start the restore process. | ||
| + | |||
| + | | {{public:module:oracle:image143.png?700}} | | ||
| 7. Restore job has completed successfully. | 7. Restore job has completed successfully. | ||
| + | |||
| + | | {{public:module:oracle:image147.png?700}} | | ||
| 8. After the restore job is completed, verify if the Oracle database(s) have been restored. Go to the designated path on the local machine where you restored the Oracle database files to. | 8. After the restore job is completed, verify if the Oracle database(s) have been restored. Go to the designated path on the local machine where you restored the Oracle database files to. | ||
| Example: using Windows File Explorer | Example: using Windows File Explorer | ||
| + | |||
| + | | {{public:module:oracle:image191.png?700}} | | ||
| 9. Recovering RAW Oracle databases | 9. Recovering RAW Oracle databases | ||
| Line 367: | Line 402: | ||
| To recover RAW databases, please refer to the following articles of Oracle Database Backup and Recovery User's Guide for details: | To recover RAW databases, please refer to the following articles of Oracle Database Backup and Recovery User's Guide for details: | ||
| - | Oracle 19c | + | * **Oracle 19c** - https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/index.html |
| - | + | ||
| - | https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/index.html | + | |
| - | + | ||
| - | Oracle 18c | + | |
| - | + | ||
| - | https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/index.html | + | |
| - | Oracle 12c | + | * **Oracle 18c** - https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/index.html |
| - | https://docs.oracle.com/database/121/BRADV/title.htm | + | * **Oracle 12c** - https://docs.oracle.com/database/121/BRADV/title.htm |
public/module/oracle/restore.1618913447.txt.gz · Last modified: 2021/04/20 18:10 by ronnie.chan
Page Tools
