Question: Has anyone seen this error before? In RMAN I issued:
backup database plus archivelog;
channel ORA_DISK_1:
starting piece 1 at 17-MAR-07
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of backup command at 03/17/2007 12:12:06
ORA-19502: write error on file "4ceve9st_1_1", blockno 67969 (blocksize=8192)
What does this error message mean and how can I fix this?
Answer: To diagnose any error, you start by using the
oerr utility
to fully display the ORA-19502 error:
ORA-19502:
Write error on file "string", blockno string (blocksize=string)
Cause: Write error on output file
Action: Check the file
This information on ORA-19502 helped to clarify
the initial odd-looking message. It's a write
error on an output file, just as it says. As a result of the
inability to write, it looks like an RMAN backup command failed.
In this situation, it turns out the error was an assumption that the
location parameter default was set up, but this assumption was not
true. Setting the default by issuing a command like the
following corrected the
problem in this case:
configure
channel 1 device type disk format '/export/u03/hot_backup/backup_%U';
|
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|