Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
You can run rman in debug mode to get more detailed information about Rman operations. In this way, we get more detailed information about a problem than the error in the log file.
Usage
1 | rman target / debug trace=/tmp/rman.log |
Example
1 2 3 4 5 6 7 8 9 | [oracle@orcldb01 ~]$ rman target / debug trace=/tmp/rman.log Recovery Manager: Release 12.2.0.1.0 - Production on Thu Nov 7 17:27:18 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. RMAN-06005: connected to target database: ORCL (DBID=493182109) RMAN> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | Recovery Manager: Release 12.2.0.1.0 - Production on Thu Nov 7 17:27:18 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. ORACLE_HOME: /u01/app/oracle/product/12.2.0.1/dbhome_1 System name: Linux Node name: orcldb01.saglik.lokal Release: 4.1.12-61.33.1.el6uek.x86_64 Version: #2 SMP Tue Mar 14 13:16:51 PDT 2017 Machine: x86_64 Starting with debugging set to level=9, types=ALL DBGMISC: ENTERED krmksimronly [17:27:18.166] DBGSQL: CHANNEL> alter session set events '19737 trace name context forever' DBGSQL: sqlcode = 0 DBGSQL: CHANNEL> select decode(archiver, 'FAILED', 1, 0) into :archstuck from v$instance DBGSQL: sqlcode = 0 DBGSQL: D :archstuck = 0 DBGSQL: CHANNEL> alter session set events '19737 trace name context off' DBGSQL: sqlcode = 0 DBGMISC: EXITED krmksimronly [17:27:18.168] elapsed time [00:00:00:00.001] DBGSQL: CHANNEL> select sys_context('userenv', 'con_id'), sys_context('userenv', 'cdb_name'), sys_context('userenv', 'con_name') , case when sys_context('userenv', 'is_application_root') = 'YES' then 1 else 0 end into :pdbid, :cdbname, :pdbname, :approot from d ual DBGSQL: sqlcode = 0 DBGSQL: D :pdbid = 0 DBGSQL: D :cdbname = NULL DBGSQL: D :pdbname = ORCL DBGSQL: D :approot = 0 DBGMISC: ENTERED krmksimronly [17:27:18.197] DBGMISC: EXITED krmksimronly [17:27:18.197] elapsed time [00:00:00:00.000] DBGSQL: CHANNEL> select sys_context('userenv', 'con_id'), sys_context('userenv', 'cdb_name'), sys_context('userenv', 'con_name') , case when sys_context('userenv', 'is_application_root') = 'YES' then 1 else 0 end into :pdbid, :cdbname, :pdbname, :approot from d ual DBGSQL: sqlcode = 0 DBGSQL: D :pdbid = 0 DBGSQL: D :cdbname = NULL DBGSQL: D :pdbname = ORCL DBGSQL: D :approot = 0 DBGMISC: ENTERED krmkgetdb [17:27:18.204] DBGRPC: krmxcc - entering DBGRPC: krmxcc - creating context for channel No-chid DBGRPC: krmxcc - connecting using target default channel DBGRPC: krmxcc - seting up for out-of-band DBGRPC: krmxpos - setting up channel No-chid DBGRPC: krmxpos - creating polling channel for channel No-chid DBGMISC: ENTERED krmksimronly [17:27:18.234] DBGMISC: EXITED krmksimronly [17:27:18.234] elapsed time [00:00:00:00.000] DBGSQL: CHANNEL> select sys_context('userenv', 'con_id'), sys_context('userenv', 'cdb_name'), sys_context('userenv', 'con_name' ), case when sys_context('userenv', 'is_application_root') = 'YES' then 1 else 0 end into :pdbid, :cdbname, :pdbname, :approot from dual . . . . . . . . |
