Database Reference
In-Depth Information
Let's find out how RMAN responds.
SQL> EXEC :rv:=site_sys.rman_pipe_if.receive(:pipe_arg, :msg, :wait_for_input, -
> :rman_error, :rman_msg, :ora_error, :ora_
msg)
PL/SQL procedure successfully completed.
SQL> SELECT :rv rv, :msg msg FROM dual;
RV MSG
--- -----------------------------------
1 Starting backup at 18.07.07 16:54
RMAN did start backing up tablespace APPDATA. Next, RMAN sends some messages to
state what is going on as it takes the backup. Here I only show two of the messages and omit the
code used to receive the messages:
SQL> SELECT :rv rv, :msg msg FROM dual;
RV MSG
--- --------------------------------------------------------------
1 using target database control file instead of recovery catalog
…
SQL> SELECT :rv rv, :msg msg FROM dual;
RV MSG
--- ----------------------------------------------------------
1 input datafile fno=00007 name=F:\ORADATA\TEN\APPDATA01.DBF
After receiving some more messages, it turns out that the backup failed due to a block
corruption. Of course I deliberately corrupted a segment in tablespace APPDATA.
1
Following
is the message RMAN sent when it encountered the corruption:
SQL> SELECT :rv rv, :msg msg FROM dual;
RV MSG
--- ----------------------------------------------------------------------
6 RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 07/18/2007 17:01:
59
ORA-19566: exceeded limit of 0 corrupt blocks for file F:\ORADATA\TEN\APPDATA01.
DBF
RMAN-10031: RPC Error: ORA-19583
A block corruption may be created with the UNIX command
dd
, (also ships with Cygwin) after a
tablespace or data file is set offline. This command overwrites the tenth 8 KB block in a data file with
binary zeros:
dd bs=8192 if=/dev/zero of=data_file_name count=1 seek=9 conv=notrunc
.
1.
