RMAN Error
in [Oracle]
|
From: mrdjmagnet on 5 Dec 2008 12:56 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......
From: ddf on 5 Dec 2008 13:33 On Dec 5, 11:56 am, mrdjmag...(a)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...... I expect your command should be: run { allocate channel d1 type disk; backup validate database archivelog all; backup incremental level 0 plus archivelog delete input format '/backup/oracle/niva/weekly/ora_%M%D%Y_NI00_%p%s' tag weekly_sunday_backup database; restore database validate; release channel d1; } David Fitzjarrell
From: ddf on 5 Dec 2008 13:42 On Dec 5, 11:56 am, mrdjmag...(a)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
From: joel garry on 5 Dec 2008 13:44 On Dec 5, 9:56 am, mrdjmag...(a)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...... Try going into rman and show all. See if that might be the controlfile snapshot setting. Though that is more of a backuppiece looking name. I'd be concerned about oracle not being able to write to oracle home. jg -- @home.com is bogus. http://saddestthing.com/
From: mrdjmagnet on 5 Dec 2008 16:14 On Dec 5, 12:33 pm, ddf <orat...(a)msn.com> wrote: > On Dec 5, 11:56 am, mrdjmag...(a)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...... > > I expect your command should be: > > run { > allocate channel d1 type disk; > backup validate database archivelog all; > backup incremental level 0 > plus archivelog delete input > format '/backup/oracle/niva/weekly/ora_%M%D%Y_NI00_%p%s' > tag weekly_sunday_backup > database; > restore database validate; > release channel d1; > > } > > David Fitzjarrell Looks like that was it David. Thanks....... Would be nice if that was documented, unless I missed it.
|
Next
|
Last
Pages: 1 2 Prev: AWR Sample Report Next: ORA-12899: value too large for column with Oracle Patch 10.2.0.4 |