Home » RMAN Tutorials

RMAN Environment

RMAN Environment Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files. The RMAN environment consists

Rman at work

Connecting to RMAN with “NOCATALOG” and “CATALOG” “rman” client application can be opened directly from command prompt c:\Oracle\bin>set ORACLE_SID=srinivas c:\Oracle\bin>echo %ORACLE_SID%srinivas c:\Oracle\bin>rman Recovery Manager: Release 19.0.0.0.0 – Production on Tue Dec 8 12:43:47 2020Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle

RMAN Troubleshooting

           Troubleshooting RMAN Run the following command to find if RMAN sessions exist in the database instance (format the output for readability): SELECT     p.SPID,     s.EVENT,     s.SECONDS_IN_WAIT AS SEC_WAIT,            sw.STATE,     s.CLIENT_INFOFROM       V$SESSION_WAIT sw,   

Oracle SW installation

Installing the Oracle Database Software on the Destination Host When the source and destination host are different, you must install the Oracle Database software on the destination host, so that the auxiliary instance can be created. Note: Ensure that you

Duplicating database prerequisites

                Duplicating Databases                 (source: Oracle Docs) Duplicating a Database to a Remote Host by Using Active Database Duplication with Image Copies There are multiple questions to answer as prerequisities. a. Do backups of the

RMAN Environment

RMAN Environment Recovery Manager (RMAN) is an Oracle Database client that performs backup and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up, restoring, and recovering database files. The RMAN environment consists

Rman at work

Connecting to RMAN with “NOCATALOG” and “CATALOG” “rman” client application can be opened directly from command prompt c:\Oracle\bin>set ORACLE_SID=srinivas c:\Oracle\bin>echo %ORACLE_SID%srinivas c:\Oracle\bin>rman Recovery Manager: Release 19.0.0.0.0 – Production on Tue Dec 8 12:43:47 2020Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle

RMAN Troubleshooting

           Troubleshooting RMAN Run the following command to find if RMAN sessions exist in the database instance (format the output for readability): SELECT     p.SPID,     s.EVENT,     s.SECONDS_IN_WAIT AS SEC_WAIT,            sw.STATE,     s.CLIENT_INFOFROM       V$SESSION_WAIT sw,   

Oracle SW installation

Installing the Oracle Database Software on the Destination Host When the source and destination host are different, you must install the Oracle Database software on the destination host, so that the auxiliary instance can be created. Note: Ensure that you

Duplicating database prerequisites

                Duplicating Databases                 (source: Oracle Docs) Duplicating a Database to a Remote Host by Using Active Database Duplication with Image Copies There are multiple questions to answer as prerequisities. a. Do backups of the

Scroll to Top