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
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
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 : 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
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 : 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
