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 . . . . . . . . |
