Enable RMAN logging for backup or restore in Oracle

RMAN command enables logging or spooling for backup in Oracle

Enable logging during the RMAN command line:

A log parameter is used to define or write in a log file.

rman TARGET / LOG = E:\rman\rman_log.log 

rman TARGET / cmdfile=E:\rman\cmd_file.txt LOG = E:\rman\rman_log.log

-- Mention append to append the file:
rman TARGET / cmdfile=E:\rman\cmd_file.txt LOG = E:\rman\rman_log.log append

Spooling the log file in the command file or direct command RMAN prompt:

rman> spool log to E:\rman\rman_log.log;
rman> run {execute script.................}
rman> spool log off;
Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.