Databases Reference
In-Depth Information
After running the script, you may be asked to upload the following files:
•
${ORACLE_SID}_${dateNOW}_rmanout.log
•
${ORACLE_SID}_${dateNOW}_rmanout.trc
•
${ORACLE_SID}_${dateNOW}_precmd.lst
•
${ORACLE_SID}_${dateNOW}_postcmd.lst
•
Trace file generated by RMAN backup with event 10046
•
Latest alert.log
Listed next is the precmd.sql script. Inspect this script carefully before running this to ensure the table names
used in the script do not match any existing table names in your environment:
spool precmd;
set line 2000
set echo on;
alter session set nls_date_format = 'DD-MON-YYYY HH:MI:SS';
drop table pre_cmd_wait_time;
drop table cmd_start_time;
drop table pre_backup_sync_io;
drop table pre_backup_async_io;
drop table pre_cmd_ksfq_events;
create table pre_cmd_wait_time
as select sum (time_waited_micro/1000000) time_waited_secs
from v$system_event where event like '%sbt%';
create table pre_backup_async_io
as select * from v$backup_async_io;
create table pre_backup_sync_io
as select * from v$backup_sync_io;
create table cmd_start_time
as select sysdate start_time from dual;
create table pre_cmd_ksfq_events
as select * from v$system_event
where event in ('i/o slave wait', 'io done');
exit;
Here is the postcmd.sql script:
spool postcmd;
set echo on;
-- Look for STATISTICS SECTION below for relevant statistics that will help
-- analyse RMAN backup performance problems
set line 2000
alter session set nls_date_format = 'DD-MON-YYYY HH:MI:SS';
drop table cmd_end_time;
create table cmd_end_time as select sysdate end_time from dual;
drop table post_cmd_wait_time;
drop table backup_async_io;
drop table backup_sync_io;
create table backup_async_io
as (select * from v$backup_async_io
