RSA SecurID - Oracle Archive Log voll
Analyse
SQL*Plus starten
C:\Programme\RSA Security\RSA Authentication Manager\db\BIN> sqlplus.exe /NOLOG> connect / as sysdbaDatenbank 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 102400Speicherbereich vergrößern
Anpassung
> alter system set db_recovery_file_dest_size=214748364800 scope=bothErgebnis 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 102400Datenbank 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