public:module:oracle:requirements
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:requirements [2021/04/20 16:24] ronnie.chan |
public:module:oracle:requirements [2021/04/20 16:31] (current) ronnie.chan |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Requirements ====== | ====== Requirements ====== | ||
| - | ---- | ||
| ===== 2.1. Hardware Requirement ===== | ===== 2.1. Hardware Requirement ===== | ||
| Line 46: | Line 45: | ||
| If the default Delta ratio is 50% for in-file delta, and if the total Oracle database size is 1TB and there is only one backup destination, the minimum free space needed on the drive where the temporary directory folder is located = 1.5TB: | If the default Delta ratio is 50% for in-file delta, and if the total Oracle database size is 1TB and there is only one backup destination, the minimum free space needed on the drive where the temporary directory folder is located = 1.5TB: | ||
| - | 1TB = Total Oracle database size | + | * 1TB = Total Oracle database size |
| - | + | * 500GB = Total maximum size of incremental or differential delta files generated | |
| - | 500GB = Total maximum size of incremental or differential delta files generated | + | |
| To obtain the size of the data files on the Oracle database instance, use the Oracle RMAN REPORT SCHEMA feature and sum up the total “List of Permanent Datafiles” by running the following command. | To obtain the size of the data files on the Oracle database instance, use the Oracle RMAN REPORT SCHEMA feature and sum up the total “List of Permanent Datafiles” by running the following command. | ||
| Line 100: | Line 97: | ||
| </code> | </code> | ||
| - | ===== 2.8. Windows Requirements ===== | + | ===== 2.7. Windows Requirements ===== |
| Ensure that the following Windows requirements and conditions are met. | Ensure that the following Windows requirements and conditions are met. | ||
| <WRAP indent> | <WRAP indent> | ||
| - | ==== 2.8.1. Supported Windows Server Version ==== | + | ==== 2.7.1. Supported Windows Server Version ==== |
| <WRAP indent> | <WRAP indent> | ||
| Line 115: | Line 112: | ||
| | Windows Server 2019 | Windows Server 2012 R2 | | | Windows Server 2019 | Windows Server 2012 R2 | | ||
| | Windows Server 2016 | | | | Windows Server 2016 | | | ||
| - | + | ||
| === Oracle 18c (from v8.5.0.77 or above) === | === Oracle 18c (from v8.5.0.77 or above) === | ||
| Line 122: | Line 120: | ||
| | Windows Server 2016 | Windows Server 2012 | | | Windows Server 2016 | Windows Server 2012 | | ||
| | Windows Server 2012 R2 | | | | Windows Server 2012 R2 | | | ||
| - | + | ||
| === Oracle 12c === | === Oracle 12c === | ||
| Line 132: | Line 131: | ||
| </WRAP> | </WRAP> | ||
| - | ==== 2.8.2. Windows User Account Permission ==== | + | ==== 2.7.2. Windows User Account Permission ==== |
| The Windows user account must be a member of the following security groups: | The Windows user account must be a member of the following security groups: | ||
| Line 150: | Line 149: | ||
| {{public:module:oracle:image019.png}} | {{public:module:oracle:image019.png}} | ||
| - | ==== 2.8.3. Oracle Database-related Windows Services ==== | + | ==== 2.7.3. Oracle Database-related Windows Services ==== |
| Ensure that all Oracle database-related services are started: | Ensure that all Oracle database-related services are started: | ||
| Line 165: | Line 164: | ||
| </WRAP> | </WRAP> | ||
| - | ===== 2.9. Oracle Backup Requirements ===== | + | ===== 2.8. Oracle Backup Requirements ===== |
| Ensure that the following requirements and conditions on the Oracle database server are met. | Ensure that the following requirements and conditions on the Oracle database server are met. | ||
| Line 175: | Line 174: | ||
| <WRAP indent> | <WRAP indent> | ||
| - | ==== 2.9.1. Oracle Tools ==== | + | ==== 2.8.1. Oracle Tools ==== |
| Although the following tools are usually installed by default on all Oracle database installations, ensure that the following tools are installed on the Oracle database server and they are functioning correctly. | Although the following tools are usually installed by default on all Oracle database installations, ensure that the following tools are installed on the Oracle database server and they are functioning correctly. | ||
| Line 230: | Line 229: | ||
| </WRAP> | </WRAP> | ||
| - | ==== 2.9.2. Oracle Internal Process Checking ==== | + | ==== 2.8.2. Oracle Internal Process Checking ==== |
| For the Oracle instance to run smoothly, ensure that the following internal processes are working well: | For the Oracle instance to run smoothly, ensure that the following internal processes are working well: | ||
| - | * **PMON** (Process Monitor) | + | * **PMON** (Process Monitor) |
| - | * **PSP0** (Process Spawner Process) | + | |
| - | * **MMAN** (Memory Manager Process) | + | * **PSP0** (Process Spawner Process) |
| - | * **DBW0** (Database Writer) | + | |
| - | * **ARC0** (Archive Process (or thread on Windows)) | + | * **MMAN** (Memory Manager Process) |
| - | * **LGWR** (Log Writer) | + | |
| - | * **CKPT** (Checkpoint process (thread on Windows) that runs by default on Windows) | + | * **DBW0** (Database Writer) |
| - | * **SMON** (System Monitor) | + | |
| - | * **RECO** (Distributed Recovery Background Process) | + | * **ARC0** (Archive Process (or thread on Windows)) |
| + | |||
| + | * **LGWR** (Log Writer) | ||
| + | |||
| + | * **CKPT** (Checkpoint process (thread on Windows) that runs by default on Windows) | ||
| + | |||
| + | * **SMON** (System Monitor) | ||
| + | |||
| + | * **RECO** (Distributed Recovery Background Process) | ||
| To check this, click the start menu and search for “cmd”. Open the command prompt as administrator. | To check this, click the start menu and search for “cmd”. Open the command prompt as administrator. | ||
| Line 418: | Line 426: | ||
| </code> | </code> | ||
| - | ==== 2.9.3. Supported Oracle Database Server Version ==== | + | ==== 2.8.3. Supported Oracle Database Server Version ==== |
| CloudBacko Pro supports the following versions of Oracle database server: | CloudBacko Pro supports the following versions of Oracle database server: | ||
| Line 490: | Line 498: | ||
| </code> | </code> | ||
| - | ==== 2.9.4 System Identifier (SID) ==== | + | ==== 2.8.4 System Identifier (SID) ==== |
| Make sure the System Identifier (SID) is correct by using the following SQL query. | Make sure the System Identifier (SID) is correct by using the following SQL query. | ||
| Line 518: | Line 526: | ||
| </code> | </code> | ||
| - | ==== 2.9.5. Oracle_Home Path ==== | + | ==== 2.8.5. Oracle_Home Path ==== |
| **Oracle 19c** | **Oracle 19c** | ||
| Line 627: | Line 635: | ||
| </code> | </code> | ||
| - | ==== 2.9.6. Database Status ==== | + | ==== 2.8.6. Database Status ==== |
| Ensure that the status of Oracle instance is “Open”. To check, use the following query. | Ensure that the status of Oracle instance is “Open”. To check, use the following query. | ||
| Line 641: | Line 649: | ||
| </code> | </code> | ||
| - | ==== 2.9.7. Archived Log Mode ==== | + | ==== 2.8.7. Archived Log Mode ==== |
| Ensure that the database instance is in Archived Log mode. To check, use the following command. | Ensure that the database instance is in Archived Log mode. To check, use the following command. | ||
| Line 662: | Line 670: | ||
| </WRAP> | </WRAP> | ||
| - | ==== 2.9.8. Java Installation ==== | + | ==== 2.8.8. Java Installation ==== |
| Java must be installed on the Oracle Database. To check if Java is installed, use the following SQL query. The status of the JServer JAVA Virtual Machine and Oracle Database Java Packages should be “VALID”. | Java must be installed on the Oracle Database. To check if Java is installed, use the following SQL query. The status of the JServer JAVA Virtual Machine and Oracle Database Java Packages should be “VALID”. | ||
| Line 729: | Line 737: | ||
| </WRAP> | </WRAP> | ||
| - | ==== 2.9.9. JAVASYSPRIV Permission for Oracle System Account ==== | + | ==== 2.8.9. JAVASYSPRIV Permission for Oracle System Account ==== |
| The Oracle system account is used by CloudBacko Pro to connect to the Oracle database server to authenticate the backup and restore process. The following permission must be assigned to the system account. Use the following SQL query to assign. | The Oracle system account is used by CloudBacko Pro to connect to the Oracle database server to authenticate the backup and restore process. The following permission must be assigned to the system account. Use the following SQL query to assign. | ||
| Line 762: | Line 770: | ||
| </code> | </code> | ||
| - | ==== 2.9.10. SYSDBA Privileges for Oracle System Account ==== | + | ==== 2.8.10. SYSDBA Privileges for Oracle System Account ==== |
| To check if the system account has sysdba privileges, use the following SQL query. | To check if the system account has sysdba privileges, use the following SQL query. | ||
| Line 801: | Line 809: | ||
| </code> | </code> | ||
| - | ==== 2.9.11. TNS Listener Service ==== | + | ==== 2.8.11. TNS Listener Service ==== |
| TNS listener service must be started to allow connections to the Oracle database server. To check if the TNS listener service is running, use the lsnrctl status command. | TNS listener service must be started to allow connections to the Oracle database server. To check if the TNS listener service is running, use the lsnrctl status command. | ||
| Line 855: | Line 863: | ||
| </WRAP> | </WRAP> | ||
| - | ==== 2.9.12. Localhost is Resolvable ==== | + | ==== 2.8.12. Localhost is Resolvable ==== |
| Verify if the localhost IP 127.0.0.1 on the Oracle database server is resolvable using the command ping 127.0.0.1 as this will be the IP address that CloudBacko Pro will use to connect to the Oracle instance. | Verify if the localhost IP 127.0.0.1 on the Oracle database server is resolvable using the command ping 127.0.0.1 as this will be the IP address that CloudBacko Pro will use to connect to the Oracle instance. | ||
| Line 876: | Line 884: | ||
| </code> | </code> | ||
| - | ==== 2.9.13. Oracle Port Number ==== | + | ==== 2.8.13. Oracle Port Number ==== |
| The default Oracle port number is 1521. To check, use the netstat and tnsping commands to verify the actual port number. | The default Oracle port number is 1521. To check, use the netstat and tnsping commands to verify the actual port number. | ||
public/module/oracle/requirements.1618907093.txt.gz · Last modified: 2021/04/20 16:24 by ronnie.chan
Page Tools
