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 col STATUS format a10 col hrs format 999.99 select SESSION_KEY, … Read more How to check RMAN backup status and timings

Share this
Share

Storing RMAN output in log file

RMAN Outputs in Log file

Hello, friends in this article we are going to discussed how to store RMAN outputs in the log file. What is the RMAN log file? RMAN log file is a just text file which is store complete output of RMAN commands. Generally, this file is used to check the backup has been done successfully or … Read more Storing RMAN output in log file

Share this
Share

How to restore archive logs from rman backup

Restore archive logs from backup

To restore the archive logs from RMAN backup, we need to reset the default location of archivelogs otherwise RMAN restore it’s on default location, to change archivelogs location we used SET ARCHIVELOG DESTINATION command. You also know how to use RMAN in NOARCHIVELOG MODE Steps to restore archive logs from RMAN backup: Your Database must … Read more How to restore archive logs from rman backup

Share this
Share

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. Use RMAN in NOARCHIVE You must check¬† How to Restore RMAN Backup on New Server As you know Oracle strongly recommended to run your database in archivelog mode for the database security.If you running … Read more Use RMAN in NOARCHIVE

Share this
Share

Restore the SPFILE from the Controlfile Autobackup

How to Restore SPFILE from autobackup? If you have lost the SPFILE (server parameter file), and your Database abnormally shutdown then you will be try to startup you 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 … Read more Restore the SPFILE from the Controlfile Autobackup

Share this
Share
Share