Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to use the debug mode command in RMAN. It is very detailed and has a certain reference value. Friends who are interested must finish reading it!

What does the DEBUG command do in Rman?

The debug parameter is used in RMAN for two purposes:

1. View the generated PL/SQL

two。 Determine where the RMAN command hung or went wrong

2. How to use the debug command and matters needing attention:

The 1.DEBUG option is specified at the RMAN prompt or within the run block.

2. The DEBUG option creates a large number of outputs, so you need to redirect the output to the trace file:

$rman target / catalog rman/rman debug trace tracefile.log

The DEBUG option displays all SQL statements executed during RMAN compilation, as well as the execution results. In addition, all information generated by the recovery directory PL/SQL package is displayed. In the following example, DEBUG output is written during backup of data file 5, but not during backup of data file 6:

RMAN > run {

Debug on;# enables debug

Allocate channel c1 type disk

Backup datafile 5

Debug off;# shuts down debug

Backup datafile 6;}

Keep in mind that the important thing to say three times is that the DEBUG output can be very large, so make sure you have enough disk space to store the trace file. In the following example, no errors were generated in the backup session, only a trace file with a size of approximately 0.2 megabytes was created:

$rman target/catalog rman/rman debug trace tracefile.log

RMAN > backup database

RMAN > host "ls-l tracefile.log"

-rw-r--r-- 1 wzch dba 254291 Jun 7 19:24 tracefile.log

Hostcommand complete

The above is all the contents of this article entitled "how to use debug Modal commands in RMAN". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.