Apply Patch RU on Database 19c(19.30)

 

Environment:- 

      DB Version : Oracle 19c, File system: Normal

       Platform : Linux86_64

Download Patch from My Oracle Support:- 

https://support.oracle.com/support/anchorId=&documentId=CPU4&page=sptemplate&sptemplate=km-article

Unzip Patch:-

Unzip Bundle Patch

First, apply the Database RU patch 38632161.
Minimum required OPatch version for this patch is 12.2.0.1.48.
Let’s verify our current OPatch version before proceeding.

Current Version:-

Let’s upgrade the OPatch version by downloading Patch 6880880.
While downloading, select "OPatch for DB 19.0.0.0.0" from the Select a Release dropdown menu, as shown in the screenshot below.

Now, the OPatch version has been upgraded.

 Interim Patch Conflict Detection and Resolution

Shutdown database and as well listener

Let's Apply Database RU patch 

Applying OJVM Patch 

Current Version Apply SQL Changes(DataPatch)

Verify from dba_registry_sqlpatch

Caution: Your use of any information or materials on this Blog is entirely at your own risk. It is provided for educational purposes only.

Install Oracle database 19c

 Step-by-Step Installation of Oracle 19c (Release 3) on Linux 8 Download Software

All prerequisite configurations have already been completed, including memory allocation, swap configuration, kernel parameter settings, creation of required groups and users, and profile setup.

Download Software 

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

 Unzip Software

Invoke ./runInstaller

Start the Oracle Universal Installer by issuing the  command.

Note :- Use of any information or materials provided on this website is solely at your own risk. The content is intended for educational purposes only

Step-by-Step Guide to Create an Autonomous Database in Oracle OCI

 Log in to Oracle Cloud Console

•     Go to the Oracle Cloud Console
•     Log in with your Oracle Cloud credentials.

Navigate to Autonomous Database Section

Click on Create Autonomous Database

    Click on Create Autonomous Database and select correct Compartment

Fill Out the Create Autonomous Database Form

• Compartment
• Display Name
• Database Type
• Deployment Type
• Database Version
• License Type

Configure Database Options

• Admin Password
• Storage
• Auto Scaling
• Network
• Backup & Restore

Click on Create Autonomous Database 

Wait for the Database to be Provisioned

    OCI will now provision your Autonomous Database. This can take a few minutes.

    Once the database is ready, you'll see its status as Running on the console.

CREATE NEW PDB BY CLONING AN EXISTING PDB

 Pre-Checks: -

 Close existing Pluggable Database PRODPDB: -

Open existing Pluggable Database PRODPDB in Read-Only: -

Create new directory at os level: -

CREATE NEW PDB (PRODPDB1) BY CLONING AN EXISTING PDB (PRODPDB): -

OPEN NEW PLUGGABLE DATABASE PRODPDB1: -

Close existing PLUGGABLE DATABASE FROM PRODPDB Read only MODE: -

Open existing PLUGGABLE DATABASE PRODPDB Read write MODE: -

Verification: - 

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.

Recovery from complete loss of all online redo log files using RMAN

Database name and version 

Member logfile Name

Remove redo log file for safer side I'm taking as backup.

Note: - If one or all of the online redo logfiles are delete then the database hangs and in the alert log file we can see the following error message:

Shutdown the database

Mount the database!

Using RMAN connect to the target database.

Recover database!

run {

set until sequence 12;

restore database;

recover database;

alter database open resetlogs;

}

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only.