Step by step guide on how to create a physical standby database using RMAN without using duplicate command. Create a Physical Standby Database Using the RMAN Backup and Restore process.: In this content, you will see and learn how we can Create a Physical Standby Database Using RMAN Backup and Restore. We will performed here … 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
Datapump sqlfile Parameter in Oracle 19c : During this article we are going to see Datapump sqlfile Parameter in Oracle 19c and the way we are able to use sqlfile parameter in Oracle database. It will be used, only with IMPDP. This sqlfile parameter helps you to generate the DDLs from a dumpfile. Suppose i’ve … Read more
During this article we will discuss with you about a way to find the list of Character set of the Oracle database. Notes : Review characterset options before you begin installation. After a database creation is done then, changing its Character set is typically very expensive in terms of your time and resources. Such type … Read more
How to install, configure, and use Stats pack in Oracle. During this article, we’ll see the way to install, configure, and use Statspack in Oracle Database. Here we will do this activity in Oracle 19c Database. What is Statspack in Oracle? The collected Data are analyzed using the Statspack reports, which has an instance health … 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
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
Apply Patching On Oracle 19c Database Release Update 19.6.2.0.200714: In this article We are going Apply Patching On Oracle 19c Database Release Update 19.6.2.0.200714 (Patch 31212138). For this activity you can follow Oracle Database 12c Release Update Known Issues (Doc ID 2663985.1) Description:- This article we are going to see steps used to apply the … 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
