Zum Inhalt springen
RSA SecurID - Oracle Archive Log voll

RSA SecurID - Oracle Archive Log voll

Analyse

SQL*Plus starten

C:\Programme\RSA Security\RSA Authentication Manager\db\BIN> sqlplus.exe /NOLOG
> connect / as sysdba

Datenbank neustarten, Fehler erkennen

> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
> startup
ORACLE instance started.
Total System Global Area  612368384 bytes
Fixed Size                  1298160 bytes
Variable Size             486539536 bytes
Database Buffers          117440512 bytes
Redo Buffers                7090176 bytes
Database mounted.
ORA-16038: log 3 sequence# 2299 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 3 thread 1:
'C:\PROGRAMME\RSASEC~1\RSAAUT~1\DB\ORADATA\ENCXUZRO\REDO03.LOG'

Größe auslesen

> select name, floor(space_limit / 1024 / 1024) "Size MB", ceil(space_used  / 1024 / 1024) "Used MB" from v$recovery_file_dest order by name;

NAME                                     Size MB    Used MB
---------------------------------------- ---------- ----------
C:/Programme/RSASEC~1/RSAAUT~1/backup    102400     102400

Speicherbereich vergrößern

Anpassung

> alter system set db_recovery_file_dest_size=214748364800 scope=both

Ergebnis kontrollieren

> select name, floor(space_limit / 1024 / 1024) "Size MB", ceil(space_used  / 1024 / 1024) "Used MB" from v$recovery_file_dest order by name;

NAME                                     Size MB    Used MB
---------------------------------------- ---------- ----------
C:/Programme/RSASEC~1/RSAAUT~1/backup    204800     102400

Datenbank neustarten

> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1298160 bytes
Variable Size 486539536 bytes
Database Buffers 117440512 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.

Archive Logs löschen

C:\Programme\RSA Security\RSA Authentication Manager\db\BIN> rman target /
run {
    crosscheck archivelog all;
    delete expired archivelog all;
}
Zuletzt aktualisiert am