Skip to content

Root Fan

Linux & Oracle DBA Blog

  • Home
  • Contact
  • About
  • Index

Tag: backup

Posted on March 16, 2024March 17, 2024

RMAN Level 0 and Level 1 Backup Script

brown wooden floor

In this article I show you how to backup your Oracle database using a bash script.

You will use 3 files for the RMAN backup.

You execute it like that to generate a level 0 backup for your SID:

./rman_backup.sh -d {SID} -l 0

For level 1 backup you should execute it like that

./rman_backup.sh -d {SID} -l 1
Continue reading “RMAN Level 0 and Level 1 Backup Script”
Posted on April 10, 2021April 4, 2022

How to Enable Archive Log Mode in Oracle 19c

landscape photography of snow pathway between trees during winter

If you want to enable archive log mode in your Oracle database because you want to backup your database while it’s opened, then you should follow these simple steps.

Be aware that you’ll need to restart your database.

So here we go.

Continue reading “How to Enable Archive Log Mode in Oracle 19c”

Posts pagination

Previous page Page 1 Page 2

Unmissable Posts

  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • Oracle 19c RMAN Duplicate Database From Backup
  • RMAN Level 0 and Level 1 Backup Script
  • How to Restore an Oracle Database From a Backup
  • How to Change AWR Retention Period in Oracle Database

Recent Posts

  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

Unmissable posts

  • How to Check PDB Status in Oracle
  • Copy Password File From Primary ASM to Standby ASM on Oracle 19c
  • How to Find Alert Log File Location in Oracle
  • Top 7 Oracle Wait Events Explained
  • RMAN Level 0 and Level 1 Backup Script
  • How to Read an AWR Report in Oracle
  • PostgreSQL Performance Tuning: How to Optimize Your Database Server
  • PostgreSQL SQL Tuning: How to Find and Fix Slow Queries
  • Oracle Exadata vs ExaCC vs ExaCS
  • Oracle Query to Check RMAN Backup Status

Categories

  • Apache
  • Exadata
  • Firewall
  • Linux
  • Oracle
  • Postfix
  • PostgreSQL
  • Security
  • Ubuntu

EN
EN
ES FR

  • Facebook
  • Twitter
  • Email
Privacy Policy Proudly powered by WordPress