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

Exclude Tablespace from Rman Backup in ORACLE

Exclude Tablespace from Rman Backup in ORACLE

During this article we will discuss how to Exclude Tablespace from Backup and configure Exclude option using RMAN. Sometimes we may exclude one or more tablespace from our database RMAN backup or regular RMAN backup. Suppose a tablespace contains test data only or its data never changed in such cases, we may exclude this from … Read more

How to Restore spfile from autobackup in ORACLE

How to Restore spfile from autobackup in ORACLE

If you have lost the SPFILE (server parameter file), and your Database abnormally shutdown. Then you will try to startup your Database but you got an error regarding spfile not found. You can restore spfile from autobackup using RMAN. NOTE:- Database must be in archivelog mode and must be configured Controlfile Autobackup on. Error : … Read more

Take RMAN backup in NOARCHIVE mode

Take RMAN backup in NOARCHIVE mode

Take RMAN backup in NOARCHIVE mode : In this article I’m going to demonstrate to you how to use RMAN in NOARCHIVE mode steps by steps. As you know Oracle strongly recommended running your database in archivelog mode for database security. If you running the database in noarchivelog mode, you refused any recovery. During Oracle … Read more

Restore RMAN backup to Different Server with Same Database Name

Restore RMAN backup to Different Server with Same Database Name

How to Restore the RMAN backup on different Server with Same Database Name. During this article we will discuss the way how to Restore RMAN backup to completely different Server with Same Database Name. We will perform this restoration process with same directory structure as our production environment on Oracle 19c Database. The production server … Read more

Flash/Fast Recovery Area (FRA) in Oracle

Fast Recovery Area (FRA) in Oracle

Flash/Fast Recovery Area (FRA) in Oracle : In this article we will see Flash/Fast Recovery Area (FRA) in Oracle. How to Setting Initialization Parameters for Size and Location of the Flash Recovery Area. What does the Oracle fast recovery area do? The FRA is essentially a disk location for the storage of files related to … Read more