This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
public:module:oracle:requirements [2021/04/20 15:44] ronnie.chan |
public:module:oracle:requirements [2021/04/20 15:55] ronnie.chan |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Requirements ====== | ====== Requirements ====== | ||
- | --------- | + | ---- |
- | 2.1 Hardware Requirement | + | ===== 2.1. Hardware Requirement ===== |
- | Refer to the following article for the list of hardware requirements for CloudBacko Pro: | + | Refer to [[public:edition:cloudbacko_pro:hardware_requirement|here]] for the list of hardware requirements for CloudBacko Pro. |
- | FAQ: Ahsay Hardware Requirement List (HRL) for version 8.1 or above | + | ===== 2.2. Software Requirement ===== |
- | 2.2 Software Requirement | + | |
- | Refer to the following article for the list of supported operating systems and application versions: | + | * [[public:edition:cloudbacko_pro:supported_platforms|Supported operating systems]] |
+ | * [[public:edition:cloudbacko_pro:supported_applications|Supported application versions]] | ||
- | FAQ: Ahsay Software Compatibility List (SCL) for version 8.1 or above | + | ===== 2.3. CloudBacko Pro Installation ===== |
- | 2.3 CloudBacko Pro Installation | + | |
Make sure the latest version of CloudBacko Pro is installed directly on the machine where the Oracle database server is hosted. | Make sure the latest version of CloudBacko Pro is installed directly on the machine where the Oracle database server is hosted. | ||
- | NOTE | + | <WRAP info> |
Backup and restore of Oracle database(s) running on a remote machine is not supported. | Backup and restore of Oracle database(s) running on a remote machine is not supported. | ||
- | 2.4 CloudBacko Pro Add-On Module Configuration | + | </WRAP> |
- | + | ||
- | Make sure the Oracle Database Server add-on module is enabled on your CloudBacko Pro user account. | + | |
- | Please contact your backup service provider for more details. | + | ===== 2.4. CloudBacko Pro Add-On Module Configuration ===== |
- | 2.5 Backup Quota Requirement | + | Make sure the Oracle Database Server add-on module is purchased for your CloudBacko Pro license. |
- | Make sure that your CloudBacko Pro user account has enough storage quota assigned to accommodate the storage of Oracle database server backup set and retention policy. | + | ===== 2.5. Java Heap Size ===== |
- | 2.6 Java Heap Size | + | |
The default Java heap size setting on CloudBacko Pro is 2048MB. For Oracle database backup, it is highly recommended to increase the Java heap size setting to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on the amount of free memory available on your Oracle server. | The default Java heap size setting on CloudBacko Pro is 2048MB. For Oracle database backup, it is highly recommended to increase the Java heap size setting to be at least 4096MB to improve backup and restore performance. The actual heap size is dependent on the amount of free memory available on your Oracle server. | ||
- | For details on how to modify the Java heap size setting of CloudBacko Pro/AhsayACB, refer to the following article: | + | For details on how to modify the Java heap size setting of CloudBacko Pro/AhsayACB, refer to [[public:edition:cloudbacko_pro:faq:how_to_increase_java_heap_size|here]]. |
- | https://wiki.ahsay.com/doku.php?id=public:8011_faq:how_to_modify_the_java_heap_size_of_ahsayobc | + | ===== 2.6. Temporary Directory Folder ===== |
- | 2.7 Temporary Directory Folder | + | |
The Temporary directory folder is used by CloudBacko Pro during a backup job as the storage of: | The Temporary directory folder is used by CloudBacko Pro during a backup job as the storage of: | ||
- | · The spooled Oracle database(s) and archived log files | + | * The spooled Oracle database(s) and archived log files |
- | + | * Any incremental or differential delta files generated | |
- | · Any incremental or differential delta files generated | + | |
It is strongly recommended that the temporary directory folder is located on a local drive with enough free disk space to be used by the spooled databases and archived log files. The temporary folder should not be located on the Windows System C:\ drive or Oracle Home drive. | It is strongly recommended that the temporary directory folder is located on a local drive with enough free disk space to be used by the spooled databases and archived log files. The temporary folder should not be located on the Windows System C:\ drive or Oracle Home drive. | ||
- | NOTE | + | <WRAP info> |
+ | * The calculation of disk space required on the drive where the temporary folder is located is as follows: \\ (Total Database Size * Delta Ratio) * number of backup destinations = Minimum Free Space Required | ||
+ | </WRAP> | ||
- | The calculation of disk space required on the drive where the temporary folder is located is as follows: | + | **Example:** |
- | (Total Database Size * Delta Ratio) * number of backup destinations = Minimum Free Space Required | + | 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: |
- | Example: | + | 1TB = Total Oracle database size |
- | 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: | + | 500GB = Total maximum size of incremental or differential delta files generated |
- | 1TB = Total Oracle database size | ||
- | |||
- | 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. | ||
- | NOTE: The values shown are just examples and might be different on your Oracle instance. | + | **NOTE:** The values shown are just examples and might be different on your Oracle instance. |
+ | <code> | ||
C:\Users\Administrator>set ORACLE_SID=orcl | C:\Users\Administrator>set ORACLE_SID=orcl | ||
- | |||
- | |||
C:\Users\Administrator>rman target / | C:\Users\Administrator>rman target / | ||
- | |||
- | |||
Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 29 18:29:44 2020 | Recovery Manager: Release 19.0.0.0.0 - Production on Thu Oct 29 18:29:44 2020 | ||
- | |||
Version 19.3.0.0.0 | Version 19.3.0.0.0 | ||
- | |||
- | |||
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. | Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. | ||
- | |||
- | |||
connected to target database: ORCL (DBID=1562659286) | connected to target database: ORCL (DBID=1562659286) | ||
- | |||
- | |||
RMAN> report schema; | RMAN> report schema; | ||
using target database control file instead of recovery catalog | using target database control file instead of recovery catalog | ||
- | |||
Report of database schema for database with db_unique_name ORCL | Report of database schema for database with db_unique_name ORCL | ||
- | |||
- | |||
List of Permanent Datafiles | List of Permanent Datafiles | ||
- | |||
=========================== | =========================== | ||
- | |||
File Size(MB) Tablespace RB segs Datafile Name | File Size(MB) Tablespace RB segs Datafile Name | ||
- | |||
---- ------- ----------- -------- ---------------- | ---- ------- ----------- -------- ---------------- | ||
- | |||
1 910 SYSTEM YES D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF | 1 910 SYSTEM YES D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF | ||
- | |||
3 920 SYSAUX NO D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF | 3 920 SYSAUX NO D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF | ||
- | |||
4 60 UNDOTBS1 YES D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF | 4 60 UNDOTBS1 YES D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF | ||
- | |||
5 260 PDB$SEED:SYSTEM NO D:\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF | 5 260 PDB$SEED:SYSTEM NO D:\ORACLE\ORADATA\ORCL\PDBSEED\SYSTEM01.DBF | ||
- | |||
6 280 PDB$SEED:SYSAUX NO D:\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF | 6 280 PDB$SEED:SYSAUX NO D:\ORACLE\ORADATA\ORCL\PDBSEED\SYSAUX01.DBF | ||
- | |||
7 5 USERS NO D:\ORACLE\ORADATA\ORCL\USERS01.DBF | 7 5 USERS NO D:\ORACLE\ORADATA\ORCL\USERS01.DBF | ||
- | |||
8 100 PDB$SEED:UNDOTBS1 NO D:\ORACLE\ORADATA\ORCL\PDBSEED\UNDOTBS01.DBF | 8 100 PDB$SEED:UNDOTBS1 NO D:\ORACLE\ORADATA\ORCL\PDBSEED\UNDOTBS01.DBF | ||
- | |||
9 260 ORCLPDB:SYSTEM NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\SYSTEM01.DBF | 9 260 ORCLPDB:SYSTEM NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\SYSTEM01.DBF | ||
- | |||
10 300 ORCLPDB:SYSAUX NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\SYSAUX01.DBF | 10 300 ORCLPDB:SYSAUX NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\SYSAUX01.DBF | ||
- | |||
11 100 ORCLPDB:UNDOTBS1 NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\UNDOTBS01.DBF | 11 100 ORCLPDB:UNDOTBS1 NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\UNDOTBS01.DBF | ||
- | |||
12 5 ORCLPDB:USERS NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\USERS01.DBF | 12 5 ORCLPDB:USERS NO D:\ORACLE\ORADATA\ORCL\ORCLPDB\USERS01.DBF | ||
- | |||
- | |||
List of Temporary Files | List of Temporary Files | ||
- | |||
======================= | ======================= | ||
- | |||
File Size(MB) Tablespace Maxsize(MB) Tempfile Name | File Size(MB) Tablespace Maxsize(MB) Tempfile Name | ||
- | |||
---- -------- ----------- ----------- -------------------- | ---- -------- ----------- ----------- -------------------- | ||
- | |||
1 32 TEMP 32767 D:\ORACLE\ORADATA\ORCL\TEMP01.DBF | 1 32 TEMP 32767 D:\ORACLE\ORADATA\ORCL\TEMP01.DBF | ||
- | |||
2 36 PDB$SEED:TEMP 32767 D:\ORACLE\ORADATA\ORCL\PDBSEED\TEMP012020-03-12_18-17-27-260-PM.DBF | 2 36 PDB$SEED:TEMP 32767 D:\ORACLE\ORADATA\ORCL\PDBSEED\TEMP012020-03-12_18-17-27-260-PM.DBF | ||
- | |||
3 128 ORCLPDB:TEMP 32767 D:\ORACLE\ORADATA\ORCL\ORCLPDB\TEMP01.DBF | 3 128 ORCLPDB:TEMP 32767 D:\ORACLE\ORADATA\ORCL\ORCLPDB\TEMP01.DBF | ||
- | |||
- | |||
RMAN> | RMAN> | ||
- | 2.8 Windows Requirements | + | |
+ | </code> | ||
+ | |||
+ | ===== 2.8. Windows Requirements ===== | ||
Ensure that the following Windows requirements and conditions are met. | Ensure that the following Windows requirements and conditions are met. | ||
+ | |||
2.8.1 Supported Windows Server Version | 2.8.1 Supported Windows Server Version | ||
Line 247: | Line 206: | ||
To verify, click the start menu and search for “Services”. Look for the Oracle database-related services. Their statuses should be “Running”. | To verify, click the start menu and search for “Services”. Look for the Oracle database-related services. Their statuses should be “Running”. | ||
- | 2.9 Oracle Backup Requirements | + | ===== 2.9. 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. |