Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database

Managing Datafiles in Oracle Database: In this article we will discuss about Managing Datafiles in Oracle Database. Guidelines for Managing Datafiles: Datafiles are physical files of the operating system that store the data of all logical structures in the database. They must be explicitly created for each tablespace. Oracle Database assigns each datafile two associated … Read more

Change Flashback mode In Oracle Database

Change Flashback mode In Oracle

Change Flashback mode In Oracle Database: In this article we will discuss how to Change Flashback mode In Oracle Database. By using flashback technology we can restore the database to a particular point in past. It’s like time machine.Here we will see , how to enable and disable flashback in oracle.To enable flashback we need … Read more

Tablespaces and Datafiles Status in Oracle

Tablespaces and Datafiles Status in Oracle

Tablespaces and Datafiles Status in Oracle: In this article we will discuss about How to check Tablespaces and Datafiles Status in Oracle. What is an Oracle Tablespace: Oracle divides a database into one or more logical storage units called tablespaces. Each tablespace consists of one or more files called datafiles. A datafile physically stores the … Read more

Data Guard Protection Modes in oracle

Data Guard Protection Modes in oracle

Data Guard Protection Modes in oracle: In this article we will discuss about Data Guard Protection Modes in oracle. In some situations, a business cannot afford to lose data. In other situations, the availability of the database may be more important than the loss of data. Some applications require maximum database performance and can tolerate … Read more

Oracle Data Guard Concepts

Oracle Data Guard Concepts

Oracle Data Guard Concepts: during this article we are going to discuss about Oracle Data Guard Concepts. The main features of Oracle data guard is A Data guard configuration consists of 1 primary database and one or more standby database. The standby databases are always in sync with primary database. If primary production database is unavailable because of planned or unplanned outage , then we … Read more

Changing Database Name in ORACLE using nid utility

Changing Database Name in ORACLE

Changing Database Name in ORACLE: During this article we’ll discuss about a way to Changing Database Name in ORACLE Database. Question: I need to re-name my database to vary the ORACLE_SID value. I have already changed the instance_name parameter in the parameter file mean init.ora file, but its still now at database said showing same … Read more

Changing Database Name in ORACLE

Changing Database Name in ORACLE

Changing Database Name in ORACLE: During this article we’ll discuss about a way to Changing Database Name in ORACLE Database. Question: I have already changed the instance_name parameter in the parameter file mean init.ora file, but its still now at database said showing same after we select instance_name from v$instance? what’s the right methods to … Read more

Changing the Archive Log Destination in Oracle

Changing the Archive Log Destination in Oracle

Changing the Archive Log Destination in Oracle: During this article we’ll see the way to Changing the Archive Log Destination in Oracle Database. If your present mount point for archivelog destination is going to FULL or for the other reason, you wish to alter the archivelog destination in the database, then follow the below steps. … Read more

Deinstall Oracle 12c Database and Binaries in Linux

Deinstall Oracle 12c

How to Deinstall Oracle 12c Database and Binaries in Linux: During this article we’ll see the way to Deinstall Oracle 12c Binaries from your Linux machine. Note : You’ll run the deinstall command from an home directory after installation. Please always keep in mind this command will also delete or remove your databases and it’s … Read more

Deinstall Oracle 19c Binaries in Linux

Deinstall Oracle 19c

How to Deinstall Oracle 19c Binaries in Linux: During this article we’ll see the way to Deinstall Oracle 19c Binaries from your Linux machine. Note : You’ll run the deinstall command from an home directory after installation. Please always keep in mind this command will also delete or remove your databases and it’s related to … Read more