This note outlines the steps to create an Oracle 19c Container Database via DBCA and then use the RMAN DUPLICATE command to create an Oracle 19c physical standby Container Database. Download the note …. Please follow and like us:
In earlier versions the RMAN DUPLICATE database command was a push-based method. One of the new features in Oracle 12c is that it has been changed to a pull-based method which has many advantages. Let us note the difference between the two methods. In the earlier push-based method, the source database transfers the required database […]
Here are a few examples of backup and recovery in an Oracle 12c multitenant environment with Container and Pluggable databases involved. The first thing to keep in mind is the structure of a 12c Container and Pluggable database. There is only one set of control files and redo log files and that is at the […]
Scenario: 1) We want to restore the production database which is running on two-node RAC environment in a test non-RAC environment 2) We want to restore the backup residing on ASM disk groups in a non-ASM file system. Note: The production database orcl has two instances named orcl1 and orcl2. The database will be restored […]
This note describes the procedure used to perform a 32 bit to 64 bit conversion of an 11.2.0.3 database on the Linux platform. The RMAN CONVERT DATABASE command is used to automate the movement of an entire database from one platform (the source platform) to another (the destination platform). This is provided that the source […]
This note outlines the procedure to clone or refresh an Oracle Real Application Clusters database using the RMAN Duplicate Database feature. In case of a RAC to RAC clone, with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database. While the […]
I have added a few more RMAN recovery scenarios which I have come across recently and may be faced by others – so thought I’d share those with the community. The first relates to a case where we need to create a replica of a production database on a test or development environment and we […]
