Oracle rman catalog standard edition

See Oracle Database Insider blog post for more information. Partitioned spatial indexes. Oracle Partitioning. Oracle Machine Learning formerly Advanced Analytics. Oracle Machine Learning no longer requires an extra cost license. Oracle Advanced Compression.

Prefix Compression also called Key Compression. Basic Table Compression. Bitmapped index, bitmapped join index, and bitmap plan conversions. Parallel capture and apply via XStream. Transportable tablespaces, including cross-platform and full transportable export and import. Summary management—Materialized View Query Rewrite.

Table lists Oracle Database options, the Oracle Database offerings for which each option is available, and the features that are included with each option. You must be licensed for an option in order to use any of its features. Fast Incremental Backup on Physical Standby. Oracle Active Data Guard must be licensed on any standby databases with any of the above features in use, as well as the primary database. If there are additional standby databases in the Oracle Data Guard configuration that are not using any of the Oracle Active Data Guard features, those standby databases do not require an Oracle Active Data Guard license.

Oracle Active Data Guard must still be licensed on standby databases, if any other of the above features are in use. An Oracle Active Data Guard license is only required if any of the pluggable databases in the standby is opened for read.

Exadata Flash Cache Compression This feature can be enabled only on Exadata storage servers, and all database processors that access the Exadata storage servers must be licensed for Oracle Advanced Compression. Oracle Advanced Security includes a restricted use license for certain Oracle Enterprise Manager features. Oracle Database Vault includes a restricted use license for certain Oracle Enterprise Manager features. An Oracle Label Security license is not required when Oracle Label Security is merely installed or enabled in any container.

Oracle Label Security includes a restricted use license for certain Oracle Enterprise Manager features. Oracle Multitenant. For EE and PE , the ability to have up to pluggable databases per multitenant container database.

Oracle Real Application Testing includes the following features:. The Oracle Real Application Testing license is required on both capture and replay systems for Database Replay and is charged by the total number of CPUs on those systems.

Database Migration Planner, introduced in Oracle Enterprise Manager Cloud Control 13c, provides a data-driven and systematic approach to consolidation by eliminating guess work and human errors. On the database target home page, select the Administration menu, then select Database Migration Planner.

All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Planner. Database Migration Workbench, introduced in Oracle Enterprise Manager Cloud Control 13c Release 4, is a single workbench that integrates all needs for migration sizing and performance comparison.

All features, functions, links, buttons, and drill-downs on this page are licensed as part of the Database Migration Workbench. Table lists Oracle management packs, the Oracle Database offerings for which each pack is available, and the features that are included with each pack.

You must be licensed for a management pack in order to use any of its features. Database-as-a-Service comprising self-service database provisioning on physical or virtual infrastructure. Support shared server, shared cluster, and shared database Schema-as-a-Service deployment models.

Virtual assembly provisioning. For example, if there is an assembly topology of three VMs two WebLogic Server-managed servers and one database , you will need both packs to cover the respective tiers. Metering and chargeback based on fixed cost, utilization metrics and configuration parameters of the database.

Starting on the Enterprise Summary home page, click the Enterprise menu. Cloud , then Infrastructure Home. Cloud , then Infrastructure Request Dashboard.

Cloud , then Infrastructure Policies. Cloud , then Middleware and Database Home. Cloud , then Middleware and Database Request Dashboard. Cloud , then Self Service Portal. Cloud , then Service Instances. Provisioning and Patching , then Database Provisioning. Starting on the Enterprise Summary home page, click the Setup menu.

Provisioning and Patching , then Storage Registration. On the Multitenant container database's home page, from the Oracle Database menu, select Provisioning , then Provision Pluggable Database.

These verbs operate on a database pool. The following objects within the repository schema are licensed under Oracle Cloud Management Pack for Oracle Database:.

Also, any report created using the "create-like" feature of BI publisher referring the preceding reports, falls under this license. If you want to use the Oracle Database Gateways listed above not solely for the purposes of Oracle Data Masking and Subsetting Pack, then you must purchase full-use licenses for the Oracle Database Gateways. Oracle Data Masking and Subsetting functionality cannot be executed directly against the non-Oracle database.

Oracle Data Masking and Subsetting Pack must be licensed only for the source database server, i. There is no requirement to license the pack for the staging database server on which masking and subsetting operations are executed, or for copies made of the masked database.

All features, functions, links, buttons, and drill-downs on these Oracle Enterprise Manager menus are licensed as part of the Oracle Data Masking and Subsetting Pack. Starting on the Enterprise Summary home page, click the Enterprise menu, then Quality Management , then select:. From the Oracle database or cluster database target home page, click the Security menu, then select:. Data Masking Definitions. With the purchase of Oracle Database Lifecycle Management Pack for Oracle Database, you also are entitled to the features described in the following sections.

The init. The Licensed Links, features, and functions listed in the following sections apply only to the Oracle Database target and the associated host an Oracle Database is deployed on. For management on non-Oracle Database targets, you must purchase the appropriate management pack. All features, functions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

From the Oracle database or cluster database target home page, click the Oracle Database menu, then Provisioning. From the Oracle cluster database target home page, click the Oracle Database menu, then Provisioning. From the database home page, click on Oracle Database , Configuration. All features, functions, links, buttons, and drill-downs on this menu, excluding Topology, are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database.

All features, functions, links, buttons, and drill-downs on this page are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database. When viewing comparison results differences as described in the Configuration Compare feature, select the configuration specification in the tree on the left.

Select Enable File Synchronization. From the database home page, click on Schema , Change Management. All features, unctions, links, buttons, and drill-downs on this menu are licensed as part of Oracle Database Lifecycle Management Pack for Oracle Database. From the Enterprise Manager home page, click the Enterprise menu and Compliance. All reports in each of these sections are licensed as part of this pack.

The following compliance views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following provisioning and patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.

The following configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.

The following Oracle home patching views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following security views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:. The following client configuration views within the repository schema are licensed under Oracle Database Lifecycle Management Pack for Oracle Database:.

Supporting functionality to perform per stream bottleneck detection and per component top wait event analysis. In order to use the features listed above, you must purchase licenses for Oracle Diagnostics Pack. This parameter can be set to one of three values:. To determine which links in Enterprise Manager are part of Oracle Diagnostics Pack, click the Setup link on the top right-hand part of the Enterprise Manager Home page. When you click the Setup link, the navigation bar contains the Management Pack Access link.

Click this link. This will take you to the Management Pack Access page, which allows you to grant and remove access from all the management packs. This procedure disables all the links and tabs associated with Oracle Diagnostics Pack in Enterprise Manager.

All the disabled links and tabs are part of Oracle Diagnostics Pack and therefore require a pack license. Oracle Diagnostics Pack features can also be accessed by way of database server APIs and command-line interfaces:.

They can be used without the Oracle Diagnostics Pack license. This procedure disables all the links and tabs associated with Oracle Tuning Pack in Enterprise Manager.

All the disabled links and tabs are part of Oracle Tuning Pack and therefore require a pack license. Oracle Tuning Pack features can also be accessed by way of database server APIs and command-line interfaces:. This script lists, in two distinct sections:. If you are not a My Oracle Support registered user, then click Register and follow the registration instructions. You can manually run the script on an individual database or use Oracle Enterprise Manager Job System to automatically run the script on multiple databases.

The information obtained from this script will provide you an overview of the licensable Oracle Database options and Oracle management packs that were identified as used by your organization. This is to be used for informational purposes only and this does not represent your license entitlement or requirement.

The far sync instance can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the far sync instance.

The GSM listener can be installed and used on a server different from the server where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the server running the GSM listener. It may not be used or deployed for other uses. Enterprise Edition must be used for the infrastructure repository database s. Oracle will provide support services for Oracle ACFS only if the server it operates on also operates an Oracle product, which may include Oracle Linux or Oracle Solaris, which is under an Oracle support contract.

If you did not configure the default RMAN values above step 2 , you can achieve similar results by running the following backup script:. And as we mentioned earlier, once you have the basics working, you can start looking at more complex scripts and scenarios. The above was just a quick example of how you can utilize the default RMAN configuration to get backups in place quickly.

It is however important to remember that when you are looking at implementing a backup solution for a production environment, that you implement a backup retention period that fits in with your company's backup and recovery policies. Retention periods weren't covered in this post, but we recommend you to read up on retention policies and use of the list, report, crosscheck and delete commands.

The most important recommendation we can give you when implementing backups, is to TEST it. Always test your backups and recovery procedures and document them.

Yes we know everyone hates documentation, but if you have an urgent restore at 3am, having documentation to follow will make it easier. To test your backups, you can easily perform backups on your production system, then copy the backups to another server and perform a restore there. It is crucial that your production backups are tested on a regular basis. See Oracle Support Note The original Note If you have any questions on the above, please don't hesitate to contact us.

Update: This blog is an updated version of the original. We work with partners around the world to give you the best advice and world-class local support. Find out about our continuous database protection for yourself and see how you can keep your world in motion.

Technical pieces. August 14, IT Manager. Introduction With many benefits from the 19c on Oracle Standard Edition upgrade, now is a. As a DBA for over two decades, I have learned a few things along the way. One is how to ensure. Technical pieces getting started with rman. Show more. All 9. The installation of Oracle Database 11 g deployed in this manner may not be used or deployed for other uses.

Oracle Connection Manager. Oracle Connection Manager can be installed and used on a machine different from the machine where the Oracle Database is installed and used. It is not necessary to obtain a separate license for the machine running Oracle Connection Manager. The functionality available on Oracle9 i Database Release 2 is as follows:. Database Replay : Only the Workload Capture feature is supported, and the captured workload may only be replayed only on Oracle Database 11 g.

This feature can be used only to facilitate upgrades from Oracle 9 i Database Release 2 to Oracle Database 11 g. The functionality available on Oracle Database 10 g Release 2 is as follows:. Database Replay : Only the Workload Capture feature is supported, and the captured workload may be replayed only on Oracle Database 11 g.

This feature can be used only to facilitate upgrades from Oracle Database 10 g Release 2 to Oracle Database 11 g. These features can be used only to facilitate upgrades from Oracle9 i Database Release 2 and Oracle Database 10 g Release 1 to Oracle Database 10 g Release 2 or higher. Oracle Database Backup Cloud Service. Oracle Database Backup Cloud Service includes use of two optimizations at no additional cost.

To use additional features of the Oracle Advanced Security Option or the Oracle Advanced Compression Option, you must license those options separately. Support for Oracle Secure Backup Express is provided exclusively through a free Oracle Discussion Forum monitored by Oracle employees as well as community experts. Oracle Secure Backup Express can back up an Oracle database as well as Oracle home files and other file system data requiring tape protection.

The Oracle database secure external password store feature stores passwords in an Oracle Wallet for password-based authentication to the Oracle database. A separate Oracle Database can be installed and used as a Recovery Manager RMAN repository without additional license requirements, provided that all the Oracle databases managed in this repository are correctly licensed. This repository database may also be used for the Oracle Enterprise Grid Control repository. It may not be used or deployed for other uses.

A separate Oracle Database can be installed and used as an Oracle Enterprise Manager Grid Control OEM Grid Control repository without additional license requirements, provided that all the targets databases, applications, and so forth managed in this repository are correctly licensed. This database may also be used for the RMAN repository.

Current User Database Links. Current user database links are one type of database link that is supported inside the Oracle Enterprise Edition database. Current user database links provide stronger security because they do not require credentials to be stored inside the database link definition. Current user database links require Enterprise User Security and use SSL to secure the communication channel over which the current user database link communicates with the target database.

These data changes can be shared between Oracle databases and other systems, such as filesystems and non-Oracle databases. XStream is licensed via the Oracle GoldenGate product.

Please contact your Oracle sales representative for additional information. Oracle Clusterware provides cluster membership and high availability monitoring and failover.

Oracle Clusterware may be used to protect any application restarting or failing over the application in the event of a failure on any server, free of charge. Oracle will provide support for Clusterware only if the server is running an Oracle product that is under a valid Oracle support contract. Oracle will provide support services for Oracle ACFS only if the server it operates on also operates an Oracle product, which may include Oracle Linux or Oracle Solaris, which is under an Oracle support contract.

Restricted-Use Licensing. The following restricted-use licenses are included with Oracle Database 11 g in the editions indicated:. OID may not be used or deployed for other uses. Oracle Database Vault includes a restricted-use license for the following Oracle Enterprise Manager features:. All other uses of Oracle Partitioning require a license for the Oracle Partitioning option, where available. Restricted-use licenses for Oracle Advanced Compression and Oracle Advanced Security are granted when performing either of the following migrations:.

These restricted-use licenses are in effect only while the migration is being performed and apply solely for the purposes of the migration operation. Operators for pluggable mapping, pluggable mapping input signature, pluggable mapping output signature. NET support Native. NET Stored Procedures. However, any use of the Oracle Database Express Edition is subject to the following limitations: Express Edition is limited to a single instance on any server.

RMAN backups of files can reside on either a local or network mounted file system. Oracle Connection Manager Oracle Connection Manager can be installed and used on a machine different from the machine where the Oracle Database is installed and used.

The functionality available on Oracle9 i Database Release 2 is as follows: Database Replay : Only the Workload Capture feature is supported, and the captured workload may only be replayed only on Oracle Database 11 g. The functionality available on Oracle Database 10 g Release 2 is as follows: Database Replay : Only the Workload Capture feature is supported, and the captured workload may be replayed only on Oracle Database 11 g. Infrastructure Repository Databases A separate Oracle Database can be installed and used as a Recovery Manager RMAN repository without additional license requirements, provided that all the Oracle databases managed in this repository are correctly licensed.

Current User Database Links Current user database links are one type of database link that is supported inside the Oracle Enterprise Edition database. Oracle Clusterware Oracle Clusterware provides cluster membership and high availability monitoring and failover. High Availability. Oracle Fail Safe. Oracle Data Guard—Redo Apply. Oracle Data Guard—Snapshot Standby. Oracle Active Data Guard.

Online index rebuild. Online index-organized table organization. Online table redefinition.