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
Manual data guard switchover in Oracle: In this article we will explain about how to perform Manual Data Guard switchover in Oracle from primary to physical standby database manually. In a Data Guard environment two types of roles primary database and physical standby database are there we can altered these roles without any data lose … Read more
How to create a new Pluggable Database in Oracle 19c using dbca.- In this article we will explain about How to create a Pluggable Database in Oracle 19c using dbca. From Oracle 12c oracle started Multitenant Architecture. In multitenant architecture you could create multiple PDBs and PDBs are created in CDB. Before we create a … Read more
ORA-01274: cannot add data file that was originally created as: In this paragraph i will discuss about ORA-01274 database error. When you getting ORA-01274 error follow below steps to resolve the issue. Problem: After adding a datafile in primary database, recovery process in standby database stopped with below error. Primary Side: After adding a datafile … Read more
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
MAX_STRING_SIZE Parameter in Oracle 19c : In this article we will discuss about MAX_STRING_SIZE Parameter in Oracle 19c. This parameter was introduced in Oracle 12c onwards. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. By default this parameter value is STANDARD, We can change the value of MAX_STRING_SIZE from STANDARD to EXTENDED, … Read more
Transparent Data Encryption In Oracle : In this article we will discuss about configuring and enabling Transparent Data Encryption (TDE) in Oracle 19c. To configure Auto Login Wallet in Oracle 19c there are few parameters which needs to be set in spfile. Lets see how to configure TDE. I need to create a subdirectory for … Read more
How we can Create A Database Manually in Oracle 19c.: During this article we are going to see the way to create a standalone database manually in Oracle 19c step by step. You can create an database either using Manually or using DBCA( GUI Method) in Oracle. But few organizations recommend you to use manual … Read more
