Error RMAN

Salah satu model backup untuk oracle adalah model RMAN. Untuk lebih jelasnya mengenai RMAN bisa langsung aja dipelajari di oracledotcom.

Pada proses backup, terkadang kita mendapatkan error sbb;

..........
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 07/14/2008 21:10:28
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /disk5/ARCHIVE2/itms17517.arc
ORA-27037: unable to obtain file status
Compaq Tru64 UNIX Error: 2: No such file or directory
Additional information: 3

RMAN> RMAN>

Recovery Manager complete.

Script /usr/openv/netbackup/scripts/hot_database_backup.sh
==== ended in error on Mon Jul 14 21:10:29 JAVT 2008 ====

.........

Solusi paling cepat dan benar adalah kita memasukkan kembali file yang diinginkan (itms17517.arc). Akan tetapi jika file tersebut terhapus, atau hilang maka solusinya

rman target sys/sysitms nocatalog
crosscheck archivelog all;

Ada error yang mungkin terjadi lagi, yaitu sbb

sql statement: alter system archive log current
released channel: ch00
released channel: ch01
released channel: ch02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 12/23/2008 23:26:28
RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
ORA-16038: log 4 sequence# 22036 cannot be archived
ORA-19502: write error on file "", blockno (blocksize=)
ORA-00312: online log 4 thread 1: '/disk6/ORADATA/REDO04.LOG02'

RMAN> RMAN>

Error tersebut dikarenakan server kehabisan space. Dan solusinya adalah, kita perluas dahulu space, dan kemudian kita lakukan kembali hal diatas..