ORA-00257

LearnoMate Technologies > ORA-00257
ORA-00257: archiver error. Connect internal only, until freed.
05
Nov

ORA-00257: ARCHIVER ERROR. CONNECT INTERNAL ONLY, UNTIL FREED. A very common Oracle database error that is basically telling you that you have run out of logical or physical space on the mount, disk, or your db_recovery_file_dest location that holds your archivelogs. When you get this error your database hangs and will not allow anyone besides […]

Posted in: Oracle DBA ,
Tags: ORA-00257 ,
Archive log Mode and No Archive Log Mode in Oracle 12C Database
10
May

In this blog we will see you how to put database in archive log mode and no archive log mode. Oracle database have two kind of log mode Archive log mode No Archive log mode. Database can be put in archive log mode whenever we want to take hot backup. Roll forward is possible with […]

Posted in: Oracle DBA ,
Tags: archivelog , dba , log mode , no archivelog , noarchivelog , ORA-00257 , ORA-01126 , oracle , oracle 12c , oracle admin , oracle dba ,
When archive log generates in Oracle?
16
Apr

In this blog we will try to understand generation of archivelog in Oracle database. if our database is an article of mode and on the database if there are many transactions are happening to the database changes will be recorded in archivelog . all DML and DDL operations are get recorded into archivelog mode. 1 […]

Posted in: Oracle DBA ,
Tags: archive , archivelog , ORA-00257 , oracle , oracle 12c , oracle admin , oracle dba ,