Posts by Sagayaraj Rajamanickam

ORA-19809: limit exceeded for recovery files:

ORA-19809: limit exceeded for recovery files In this blog, we are going to resolve the “ORA-19809” error The limit for recovery files specified by the db_recovery_file_dest_size was exceeded. Here I am…

Read More

Multiplex Oracle control file

Multiplex Oracle control file: In order to reduce the risk of losing control files due to corruption, accidental removal, or any possible worst. Viewing the Control file available in our…

Read More

DATABASE_LINK PARAMETER

DATABASE_LINK PARAMETER A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. You can query a table or view…

Read More

Recovering online redo log files without Backup

In this blog, We are going to learn about recovering online redo log files without any backup Step 1: Starting Up the database, SQL> startup ORACLE instance started. Total System…

Read More

Recover a loss of all online redo log files using RMAN Backup

Steps to recover a loss of all online redo log files using RMAN Every instance of an Oracle database has an associated online redo log to protect the database in case of an…

Read More

Creating a Instance in cloud

Here I am going to explain about how to create a Instance in cloud, Step 1: Provide the instance name as your suitable: Step 2 : Click the change Image…

Read More

ALTERING ARCHIVE LOG DESTINATION:

ARCHIVE LOG: In Oracle, the Archive log is a copy of a filled redo log file, The process of converting the redo log into archiving log file is called Archiving.…

Read More

Importing a .dmp file in a Pluggable database

Importing a traditionally exported dump file in a Pluggable database:   Step 1: Creating a new pluggable database : Create a new pluggable database(dbca) Step 2: Checking the status of the…

Read More

Cloning a Local Pluggable Database

Here we are going to see about how to clone a local Pluggable database in simple steps, Pluggable Database Name- PDB1 Step 1:  Check the available Pluggable Database in the…

Read More

Creating a Pluggable Database in previously created Container Database

Here I am going to explain about Creating a Pluggable Database in our Container Database using DBCA method Let’s see, Note: Before creating a PDB we need to ensure our…

Read More