Re: RMAN Error

On Dec 5, 11:56 am, mrdjmag..._at_aol.com wrote:
> We're starting to run RMAN.  It backups the archive logs just fine.
> However, all of a sudden we receive this error:
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-03002: failure of backup plus archivelog command at 12/05/2008
> 11:48:32
> ORA-19502: write error on file "/opt/oracle/product/ora10/dbs/
> puk1g4e9_1_1", blockno 1249281 (blocksize=8192)
> ORA-27072: File I/O error
> Linux-x86_64 Error: 2: No such file or directory
>
> Why is it trying to write to the Oracle Home, and what is that
> file???  The parameter file is this:
>
> run {
> allocate channel d1 type disk;
> backup validate database archivelog all;
> backup incremental level 0 database
> plus archivelog delete input
> format '/backup/oracle/niva/weekly/ora_%M%D%Y_NI00_%p%s'
> tag weekly_sunday_backup;
> restore database validate;
>
> }
>
> Can't seem to find anything on the internet......

And my first response wasn't correct; I'll try again :

run {
allocate channel d1 type disk;
backup validate database archivelog all; backup incremental level 0
format '/backup/oracle/niva/weekly/ora_%M%D%Y_NI00_%p%s' tag weekly_sunday_backup
database plus archivelog delete input;
restore database validate;
}

The format specifier must appear before the keyword 'database'. My mistake was in the location of the 'plus archivelog delete input' operand, which has been corrected here.

David Fitzjarrell Received on Fri Dec 05 2008 - 12:42:16 CST