jueves, 16 de julio de 2020

RMAN TRACE - DEBUG

EJEMPLO 1

[oracle@localhost backup]$ rman target / trace trace.log

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jul 16 18:24:42 2020

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1376021099)

RMAN> host;

[oracle@localhost backup]$ ls
ACME  asm_metadata_data  asm_metadata_fra  control.trc  trace.log
[oracle@localhost backup]$ exit
exit
host command complete

RMAN> backup datafile 1;

Starting backup at 16-JUL-20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_hhqvrdhj_.dbf
channel ORA_DISK_1: starting piece 1 at 16-JUL-20
channel ORA_DISK_1: finished piece 1 at 16-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_16/o1_mf_nnndf_TAG20200716T182516_hk1rgwjx_.bkp tag=TAG20200716T182516 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 16-JUL-20

Starting Control File and SPFILE Autobackup at 16-JUL-20
piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2020_07_16/o1_mf_s_1045938351_hk1rj01v_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 16-JUL-20

RMAN> 

EJEMPLO 2


[oracle@localhost backup]$ rman target / trace trace.log

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Jul 16 18:29:07 2020

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1376021099)

RMAN> run 
2> {
3> debug on;
4> backup datafile 2;
5> debug off;
6> }

RMAN-03036: Debugging set to level=9, types=ALL

RMAN-03090: Starting backup at 16-JUL-20
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=62 device type=DISK
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00002 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_hjwsv73p_.dbf
RMAN-08038: channel ORA_DISK_1: starting piece 1 at 16-JUL-20
RMAN-08044: channel ORA_DISK_1: finished piece 1 at 16-JUL-20
RMAN-08530: piece handle=/u01/app/oracle/fast_recovery_area/ORCL/backupset/2020_07_16/o1_mf_nnndf_TAG20200716T182948_hk1rqd92_.bkp tag=TAG20200716T182948 comment=NONE
RMAN-08540: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
RMAN-03091: Finished backup at 16-JUL-20

RMAN-03090: Starting Control File and SPFILE Autobackup at 16-JUL-20
RMAN-08503: piece handle=/u01/app/oracle/fast_recovery_area/ORCL/autobackup/2020_07_16/o1_mf_s_1045938595_hk1rqmkk_.bkp comment=NONE
RMAN-03091: Finished Control File and SPFILE Autobackup at 16-JUL-20

Debugging turned off

RMAN> 


EJEMPLO 3

[oracle@localhost ~]$ rman target / debug trace trace.log

Recovery Manager: Release 12.1.0.1.0 - Production on Mon May 24 19:43:56 2021

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

RMAN-06005: connected to target database: ORCL (DBID=1376021099)

RMAN> backup database;   

RMAN-03090: Starting backup at 24-MAY-21
RMAN-06009: using target database control file instead of recovery catalog
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=37 device type=DISK
RMAN-08008: channel ORA_DISK_1: starting full datafile backup set
RMAN-08010: channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-08522: input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_9qwm8fym_.dbf
RMAN-08522: input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_j9cy9cfn_.dbf
RMAN-08522: input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_9qwmf6kp_.dbf
RMAN-08522: input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_j86zjfnv_.dbf



No hay comentarios: