RMAN in Oracle
ORA-19809: limit exceeded for recovery files: In this article we will be discuss about the ORA-19809: limit exceeded for recovery files. This same solution is also working for the error ORA-00257: archiver error. Connect internal only, until freed. Error: Cause: db_recovery_file_dest_size used space was filled. Solution: Check the db_recovery_file_dest_size value and the space usage in … Read more
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
Oracle 19c 2 node RAC to single instance standby database setup: In this article we will discuss about how to setup Oracle 19c 2 node RAC to single instance standby database step by step. Environment Details for both (Primary and Standby): Primary Server side Configurations:- Make sure primary is in archivelog mode: Check FORCE LOGGING … 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
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
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
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
