вторник, 7 декабря 2010 г.

ORA-19809: limit exceeded for recovery files

In such situation we need to deal with the error fast as possilbe as database in freeze state and could potentially abort if no action has taken. Bellow I will show 2 ways to do it in fast manner as follows:

1) If we need archived logs (production)
Backup all archivelogs (fra or not) by 1 archive log (delete) to temporary destination
rman target /
backup archivelog all to destination "C:\Project\testdb\bkp\fra" filesperset 1 delete input;


2) If we do not need archived logs to be backed up (test/dev system)
os: delete old archivelogs
rman:
crosscheck archivelog all;
delete expired archivelog all;

Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...