How to Recover lost datafile with no backup

Recover lost datafile with no backup

In this article, we are going to learn how to recover lost datafile with no backup. Suppose expediently you lost a datafile at the OS level and there is no current backup available. But the best point is that you are in archivelog mode and you have all archive logs available since the datafile was … Read more

Oracle RMAN Backup Types

rman backup type

In this article, we are going to discuss oracle rman backup types. As you know RMAN is a utility of oracle database which is used to take Database backup. The RMAN backup is two types: Full Backup Incremental Backup Full RMAN backup A complete backup differs from a full database backup. A full backup of the … Read more

Rman full database backup script

rman full database backup script

In this article, we are going to learn how to create rman full database backup script step by step. RMAN (Recovery Manager) is a popular tool to create Oracle Database backups. Using RMAN we can create two types of backups listed below. Full Database Backup Incremental Database Backup So, here we are going to learn … Read more

crosscheck archivelog all

crosscheck archivelog all

In this article, we are going to learn, why we need to run crosscheck archivelog all commands. You must read this article carefully and follow all steps. Why we run crosscheck archivelog all? Rman utility is a very powerful utility that is used for creating Oracle Database backup. The crosscheck command only verifies the existence … Read more

RMAN BACKUP SCRIPT

RMAN BACKUP SCRIPT

How to automate Oracle RMAN Backup with shell script In a real environment, you obviously won’t manually trigger all of the Oracle database backups. An automated mechanism is required to enable RMAN backups. In this article, we’ll look at automating RMAN backup using a shell script. Create Backup Location On your database server, create a … Read more

Set newname RMAN script

Set newname RMAN script

RMAN script In this article, we are going to learn how to create a rman restoration script with a set newname parameter. If you try to restore the database on another server using RMAN and the directory structure is different, you can use the below query for restoration. Step 1. Check datafile location on the … Read more

How to Restore RMAN Backup with a Different Database Name

How to Restore RMAN Backup with a Different Database Name

Hello friends, in this article I’m going to demonstrate to you Restore RMAN Backup with a Different Database Name on New Server step-by-step guide. Restore oracle database from rman backup to another server Steps to Clone database to different DB name use RMAN Full or Level 0 Database RMAN backup. Controlfile backup. spfile backup. Password … Read more

Restore the SPFILE from the controlfile Autobackup

Restore the SPFILE from the controlfile Autobackup

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. How to Restore SPFILE from autobackup? NOTE:- Database must be in archivelog mode and must be configured Controlfile Autobackup … Read more

Use RMAN in NOARCHIVE

Use RMAN in NOARCHIVE

Hello, friends 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. Error in Noarchive Mode If you are … Read more

How to restore archive logs from RMAN backup

How to restore archive logs from rman backup

How do I restore archive log from backup? In this article, we are going to learn how to restore the archive logs from RMAN backup. RMAN restores archives on the default location. To change archive logs location we used the SET ARCHIVELOG DESTINATION command. Your Database must be in mounted or open mode. start RMAN and connect with the target … Read more

Store RMAN output in a logfile

RMAN output in a logfile

Hello, friends in this article we are going to discuss how to Store RMAN output in a logfile. What is the RMAN log file? RMAN log file is a just text file that stores the complete output of RMAN commands. Generally, this file is used to check the backup has been done successfully or not. … Read more

How to check RMAN backup status and timings

How to check RMAN backup status and timings

Hello friends, in this article we learn how to check RMAN backup status and timings on the target database. Using the following command you will get the details about currently running RMAN and ARCHIVE backup. Click Here for YouTube Query to check RMAN backup status Using the below query you can the rman backup monitoring. Output: … Read more