ORA-00257
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 […]
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 […]
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 […]