Oracle SQL,PL/SQL

How to RMAN Backup on Oracle Database?

How to RMAN Backup on Oracle Database? | TechTweet
Avatar of shohal
Written by shohal

Backups

•Logical-Using Export or Export Data Pump Utilities

•Physical –Using O/S copy or RMAN based backups.

How to RMAN Backup on Oracle Database

•If do RMAN backup database must be archive database log mode active.

How to check Archive Log List?

How to RMAN Backup on Oracle Database? | TechTweet
SQL> archive log list;

How to check archive database log mode?

How to RMAN Backup on Oracle Database? | TechTweet
SQL> select name ,log_mode from v$database;

How to database shut immediate and startup?

How to RMAN Backup on Oracle Database? | TechTweet
SQL> shut immediate
SQL> startup

How to check archive database log_archive parameter?

How to RMAN Backup on Oracle Database? | TechTweet
SQL> show parameter log_archive

How to check database mount or not mount?

How to RMAN Backup on Oracle Database? | TechTweet
SQL> select open_mode from v$database;

Note : Oracle Database Backup from SqlPlus.

Go to CMD and enter into the file path with .dmp

Example : C:\Users\Shohal-IT>exp Automobile/A@orclpdb File=J:\oraclebackup\test.dmp

How to RMAN Backup on Oracle Database? | TechTweet
How to RMAN Backup on Oracle Database? | TechTweet

About the author

Avatar of shohal

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment