Differences

This shows you the differences between two versions of the page.

--- public:module:oracle:restore [2021/04/20 17:38]
ronnie.chan
+++ public:module:oracle:restore [2021/04/20 18:20] (current)
ronnie.chan
@@ Line 2: / Line 2: @@
 ----
-===== 8.1. Restoring Data =====
+===== 8.1. Overview =====
 ----
@@ Line 17: / Line 17: @@
 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 18c
+  * **Oracle 12c** - [[https://docs.oracle.com/database/121/BRADV/title.htm]]
-https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/index.html
-Oracle 12c
-https://docs.oracle.com/database/121/BRADV/title.htm
 ===== 8.2. Restore to Original Location =====
@@ Line 37: / Line 31: @@
 Example: A running TNS Listener service on Oracle 19c.
+<code>
 C:\Users\Administrator>lsnrctl status
 LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 14-OCT-2020 16:45:29
 Copyright (c) 1991, 2019, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora19c-w2k16)(PORT=1521)))
 STATUS of the LISTENER
 ------------------------
 Alias                     LISTENER
 Version                   TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
 Start Date                14-OCT-2020 11:11:04
 Uptime                    0 days 5 hr. 34 min. 27 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Listener Parameter File   D:\oracle\19.3.0\dbhome\network\admin\listener.ora
 Listener Log File         D:\oracle\diag\tnslsnr\ora19c-w2k16\listener\alert\log.xml
 Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c-w2k16)(PORT=1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora19c-w2k16)(PORT=5500))(Security=(my_wallet_directory=D:\ORACLE\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
 Services Summary...
 Service "52448234712340b69f274bcc790ecfe0" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "9400891b61bb4c4c8b3997957ffa8c8e" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "CLRExtProc" has 1 instance(s).
   Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
 Service "orcl" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "orclXDB" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "orclpdb" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 The command completed successfully
 C:\Users\Administrator>
-NOTE: The values shown are just examples and might be different on your Oracle instance.
+</code>
+<WRAP info>
+The values shown are just examples and might be different on your Oracle instance.
+</WRAP>
 .     Run the sqlplus / as sysdba command to verify if the Oracle service is active.
 The following is just an example after an Oracle instance failure due to corrupted data and/or configuration files. It might be different on your Oracle instance.
+<code>
 C:\Users\Administrator>sqlplus / as sysdba
@@ Line 127: / Line 95: @@
 Connected to an idle instance.
+</code>
 .     On the CloudBacko Pro main interface, click the Restore icon.
+{{public:module:oracle:image131.png}}
 .    Select the backup set that you would like to restore the Oracle database from.
+| {{public:module:oracle:image133.png?700}} |
 .    Select the destination storage that contains the Oracle database(s) that you would like to restore from.
+| {{public:module:oracle:image135.png?700}} |
 .    Select the database(s) that you would like to restore. You can also choose to restore backed up database from a specific backup job using the Select what to restore drop-down menu. Click Next to proceed.
+| {{public:module:oracle:image137.png?700}} |
 .    Choose Original location as where the database(s) will be restored.
+| {{public:module:oracle:image139.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.
+| {{public:module:oracle:image141.png?700}} |
 .    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}} |
 .    When this pop-up message is displayed, click Yes to continue.
+| {{public:module:oracle:image145.png?700}} |
 .  Restore job has completed successfully.
+| {{public:module:oracle:image147.png?700}} |
 .  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
@@ Line 171: / Line 160: @@
 SQL>
+</code>
 ===== 8.3. Restore to Alternate Location =====
@@ Line 178: / Line 168: @@
 Example: A running TNS Listener service on Oracle 19c.
+<code>
 C:\Users\Administrator>lsnrctl status
 LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 14-OCT-2020 16:45:29
 Copyright (c) 1991, 2019, Oracle.  All rights reserved.
 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora19c-w2k16)(PORT=1521)))
 STATUS of the LISTENER
 ------------------------
 Alias                     LISTENER
 Version                   TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
 Start Date                14-OCT-2020 11:11:04
 Uptime                    0 days 5 hr. 34 min. 27 sec
 Trace Level               off
 Security                  ON: Local OS Authentication
 SNMP                      OFF
 Listener Parameter File   D:\oracle\19.3.0\dbhome\network\admin\listener.ora
 Listener Log File         D:\oracle\diag\tnslsnr\ora19c-w2k16\listener\alert\log.xml
 Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora19c-w2k16)(PORT=1521)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=ora19c-w2k16)(PORT=5500))(Security=(my_wallet_directory=D:\ORACLE\admin\orcl\xdb_wallet))(Presentation=HTTP)(Session=RAW))
 Services Summary...
 Service "52448234712340b69f274bcc790ecfe0" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "9400891b61bb4c4c8b3997957ffa8c8e" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "CLRExtProc" has 1 instance(s).
   Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
 Service "orcl" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "orclXDB" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 Service "orclpdb" has 1 instance(s).
   Instance "orcl", status READY, has 1 handler(s) for this service...
 The command completed successfully
 C:\Users\Administrator>
+</code>
-NOTE: The values shown are just examples and might be different on your Oracle instance.
+<WRAP info>
+The values shown are just examples and might be different on your Oracle instance.
+</WRAP>
 .    Run the sqlplus / as sysdba command to verify if the Oracle service is active.
@@ Line 260: / Line 218: @@
 The following is just an example after an Oracle instance failure due to corrupted data and/or configuration files. It might be different on your Oracle instance.
+<code>
 C:\Users\Administrator>sqlplus / as sysdba
@@ Line 269: / Line 228: @@
 Connected to an idle instance.
+</code>
 .    Create the top level folder for the Alternate Location of the database instance that will be restored. For example, D:\orcl1
+| {{public:module:oracle:image150.gif?700}} |
 .    Assign correct permissions to the created folder. To assign, right-click on the folder then select Properties.
+| {{public:module:oracle:image151.png}} |
 Go to the Security tab then click Edit.
+| {{public:module:oracle:image153.png}} |
 Click the Add button then add the the oracle user account to the folder with Full control.
+| {{public:module:oracle:image155.png}} |
+| {{public:module:oracle:image157.png}} |
 Click Apply then click OK to save changes.
-NOTE: Please refer to Appendix B for more details.
+| {{public:module:oracle:image159.png}} |
+<WRAP info>
+Please refer to Appendix B for more details.
+</WRAP>
 .     On the CloudBacko Pro main interface, click the Restore icon.
+{{public:module:oracle:image131.png}}
 .     Select the backup set that you would like to restore the Oracle database from.
+| {{public:module:oracle:image133.png?700}} |
 .    Select the destination storage that contains the Oracle database(s) that you would like to restore from.
+| {{public:module:oracle:image135.png?700}} |
 .     Select the database(s) that you would like to restore, then click Next to proceed.
+| {{public:module:oracle:image137.png?700}} |
 .    Choose Alternate location as where the database(s) will be restored.
+| {{public:module:oracle:image165.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.
-.  Configure the following settings in the Alternate database screen:
+| {{public:module:oracle:image167.png?700}} |
-·         Oracle Home – where the Oracle_Home path is located. This is already set to the location of the Oracle_Home by default.
+.  Configure the following settings in the Alternate database screen:
-·         Host – this value is set to 127.0.0.1.
+  * **Oracle Home** – where the Oracle_Home path is located. This is already set to the location of the Oracle_Home by default.
-·         Port – the new port number of the alternate Oracle database instance.
+  * **Host** – this value is set to 127.0.0.1.
-·         SID – the new SID for the alternate Oracle database instance.
+  * **Port** – the new port number of 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.
+  * **SID** – the new SID for the alternate Oracle database instance.
-·         Password – the password for the system user account in the new database.
+<WRAP info>
+If a restore will be performed to an alternate location, it is required to change the Oracle SID and port number.
+</WRAP>
-NOTE
+  * **Password** – the password for the system user account in the new database.
-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 indent>
+| {{public:module:oracle:image169.png?700}} |
+</WRAP>
-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 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.
+</WRAP>
 Once configured, click Next to proceed.
 .  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}} |
 .  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}} |
 .  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}} |
 .  Restore job has completed successfully.
+| {{public:module:oracle:image147.png?700}} |
 .  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
@@ Line 349: / Line 353: @@
 SQL>
+</code>
 ===== 8.4. Restore Raw File =====
@@ Line 356: / Line 361: @@
 .     On the CloudBacko Pro main interface, click the Restore icon.
+{{public:module:oracle:image131.png}}
 .     Select the backup set that you would like to restore the Oracle database from.
+| {{public:module:oracle:image133.png?700}} |
 .     Select the destination storage that contains the Oracle database(s) that you would like to restore from.
+| {{public:module:oracle:image135.png?700}} |
 .     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}} |
 .     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.
+| {{public:module:oracle:image187.png?700}} |
 .     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}} |
 .    Restore job has completed successfully.
+| {{public:module:oracle:image147.png?700}} |
 .     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
+| {{public:module:oracle:image191.png?700}} |
 .     Recovering RAW Oracle databases
@@ Line 381: / Line 402: @@
 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

User Tools

Site Tools

Differences

Page Tools