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
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
How to find and kill a session in Oracle: During this article we are going to discuss the way to find and kill Oracle sessions. Many times we are facing issue in Database Level, then we would to check and find out sessions details, how much there are active/inactive/killed sessions and might killed some sessions. … Read more
ESTIMATE required diskspace for EXPORT backup: During this article we are going to discuss about ESTIMATE required diskspace for EXPORT backup using ESTIMATE_ONLY parameter in Oracle Database. Here we’ll do that activity on Oracle 19c Database. ESTIMATE_ONLY parameter in Oracle Database: ESTIMATE_ONLY parameter is utilized in EXPDP command, to estimate the disc space required for … Read more
Generate user ddl in Oracle: In this article we will discuss about how to Generate user ddl in Oracle. You can use below scripts to generate DDL statements for a user or multiple users with their roles, system and object privileges. To generate ddl for a specified user: In this case we generate ddl for … Read more
How to generate tablespace ddl in Oracle: In this article we will see How to generate tablespace ddl in Oracle for one tablespace and all tablespaces. Generate one tablespace’s ddl By this below query you can generate tablespace ddl for a specified tablespace. After run this query it will ask you to provide the tablespace_name. … Read more
Create an Oracle Listener with Oracle Network Configuration Assistant : In this article we will see how to Create an Oracle Listener with Oracle Network Configuration Assistant. In order t remote connections to an Oracle database the database must be registered with an Oracle Listener. If you will need to create a Listener manually. This document will detail the … Read more
Drop And Recreate Temp Tablespace In Oracle : During this article we’ll see how to Drop And Recreate temp tablespace In Oracle Database. Note :- While doing this activity, existing temporary tablespace may have existing live sessions, due to same oracle won’t let us to drop existing temporary tablespace. Resulting, we need to kill existing … Read more
Upgrade Oracle Database Manually from 12.2.0.1 to 19c: In this article we will see how Upgrade Oracle Database Manually from 12.2.0.1 to 19c. Follow the below Steps for this activity: Environment : Pre-Upgrade Tasks : Step-1 Take Backup : In this case we take Database RMAN full backup. Take Backup of Network files, init files, … Read more
Apply Patching On Oracle 12c Database Release Update 12.2.0.1.190115 : In this article We are going Apply Patching On Oracle 12c Database Release Update 12.2.0.1.190115 (Patch 28822515). For this activity you can follow Oracle Database 12c Release Update Known Issues (Doc ID 2285557.1) Description:- This article we are going to see steps used to apply … Read more
