How to Check Oracle UPTIME AND STARTUP history?

Oracle UPTIME AND STARTUP history

Hello guys, the Oracle uptime and startup history is recorded in alert log files. But you also check these details using SQL Queries. “Oracle UPTIME AND STARTUP history”. Connect with us on Social Network Oracle UPTIME AND STARTUP history Heres is the steps to check oracle database uptime and startup history step by step. 1. … Read more

Create spool file with timestamp in oracle

spool file with timestamp

In this article we are going to learn how to create spool file with timestamp oracle database. “oracle spool date format”. Connect with us on Social Network spool file with timestamp oracle Login into database and follow the below steps. Step 1: Create a dummy column with noprint option. Step 2: Select sysdate with reference … Read more

RMAN Backup with Archivelog

RMAN Backup with Archivelog

In this post, we will learn how to take rman backup with archivelog step-by-step guide. What is backup database plus Archivelog? The backup database plus archivelog command will create a database backup with archivelogs using the RMAN utility. RMAN Backup with Archivelog Or you can use the below script for the same task. Output from … Read more

Kill Hung RMAN Session

Kill Hung RMAN Session

I recently encountered a situation where the RMAN backup job was stuck. I ended the hung session as the database size was only four GB and it had been running for the last four hours. We made some changes to the RMAN command and ran the jobs again. It was completed in under an hour. … Read more