Table of Contents

RSA SecurID - Oracle Archive Log voll

Speicherbereich vergrößern

cd "C:\Programme\RSA Security\RSA Authentication Manager\db\BIN"
sqlplus.exe /NOLOG
connect / as sysdba
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'
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
alter system set db_recovery_file_dest_size=214748364800 scope=both
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
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

cd "C:\Programme\RSA Security\RSA Authentication Manager\db\BIN"
rman target /
run {
    crosscheck archivelog all;
    delete expired archivelog all;
}