meta data for this page
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; }