Oracle SQL,PL/SQL

How to RMAN Backup on Oracle Database?

4 years ago

19 Views

How to RMAN Backup on Oracle Database

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 check archive database log list 1 — SQL> archive log list;

How to check archive database log mode?

How to check archive database log mode — SQL> select name ,log_mode from v$database;

How to database shut immediate and startup?

How to database shut immediate and startup — SQL> shut immediate
SQL> startup

How to check archive database log_archive parameter?

How to check archive database log archive parameter — SQL> show parameter log_archive

How to check database mount or not mount?

How to check database mount or not mount — 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

Oracle Backupdmp 1

About the author

shohal

Leave a Comment X