Hi All,
Many a times when taking the rman backup you can face the following error reported in the rman log as shown below
allocated channel: ch00
channel ch00: sid=110 devtype=SBT_TAPE
channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
allocated channel: ch01
channel ch01: sid=106 devtype=SBT_TAPE
channel ch01: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)
Starting backup at 19-SEP-07
current log […]
—————-Script to Collect Data Guard Primary Site Diagnostic Information.txt———-
set echo off
set feedback off
column timecol new_value timestamp
column spool_extension new_value suffix
select to_char(sysdate,’Mondd_hhmi’) timecol,
‘.out’ spool_extension from sys.dual;
column output new_value dbname
select value || ‘_’ output
from v$parameter where name = ‘db_name’;
spool dg_prim_diag_&&dbname&×tamp&&suffix
set linesize 79
set pagesize 35
set trim on
set trims on
alter session set nls_date_format = ‘MON-DD-YYYY HH24:MI:SS’;
set feedback on
select to_char(sysdate) time […]