ORA-19809: limit exceeded for recovery files

ORA-19809 limit exceeded for recovery files

ORA-19809: limit exceeded for recovery files: In this article we will be discuss about the ORA-19809: limit exceeded for recovery files. This same solution is also working for the error ORA-00257: archiver error. Connect internal only, until freed. Error: Cause: db_recovery_file_dest_size used space was filled. Solution: Check the db_recovery_file_dest_size value and the space usage in … Read more

Enable or Disable Unified Auditing in Oracle 19c

Enable or Disable Unified Auditing in Oracle 19c

Enable or Disable Unified Auditing in Oracle 19c: In this Article we will discuss about how to Enable or Disable Unified Auditing in Oracle 19c. What is Unified Auditing? After installing and starting up your oracle 19c database, check that the “Unified Auditing” status by default it should be “FALSE”. When you create a new … Read more

Auditing in Oracle Database

Auditing in Oracle Database

Auditing in Oracle Database: In this article we will discuss about Auditing in Oracle Database. Here we use our Oracle 19c database. Auditing is a default feature in Oracle Database to monitoring and recording of configured database actions, from both database users and nondatabase users. Below are the initialization parameters that can be displayed and … Read more

Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle

Recover Standby Database from Primary using Service in Oracle: In this article we will discuss about how to Recover Standby Database from Primary using Service in Oracle 19c. If your standby database is out of sync from primary. Or some archive logs got deleted before it is being shipped or applied to standby. Then, you … Read more

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database

Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more

Change AWR snapshot Retention period and Interval in Oracle

Change AWR snapshot Retention period and Interval in Oracle

Change AWR snapshot Retention period and Interval in Oracle: In this article we will discuss about how to Change AWR snapshot Retention period and Interval in Oracle. About AWR Report: Oracle MMON background process collect the AWR statistics and generate the snapshot based on retention period, which violates the threshold metric. You can enable this … Read more

How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle

How to create a password file using ORAPWD Utility in oracle: In this post we will discuss about how to create a password file using ORAPWD Utility in oracle. What is password file in ORACLE ? The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over … Read more

Oracle 19c 2 node RAC to single instance standby database setup

Oracle-19c-2-node-RAC-to-single-instance-standby-database-setup

Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … Read more

Upgrade Oracle Database from 12c to 19c using the RMAN backup

Upgrade Oracle Database from 12c to 19c using the RMAN backup

Upgrade Oracle Database from 12c to 19c using the RMAN backup : In this article we will discuss about how to Upgrade Oracle Database from 12c to 19c using the RMAN backup. Enviroment: Steps of Oracle Database 19c Restore from 12c rman backup : In Oracle 12c : Create pfile from spfile of 12cR2 database: … Read more

Oracle Database startup and shutdown procedure

Oracle Database startup and shutdown procedure

For a DBA, starting up and shutting down of oracle database is a routine and basic operation. Sometimes Linux administrator or programmer may end-up doing some basic DBA operations on development database. So, it is important for non-DBAs to understand some basic database administration activities. Oracle Database startup and shutdown procedure Oracle Database startup and … Read more