ORA-38707 Tried to enable flashback of whole database, but it failed with ORA-38706 and ORA-38707. SQL> alter database flashback on; alter database flashback on *… Read More »How to Resolve ORA-38707: Media recovery is not enabled
ORA-01123 Tried to make the whole database enter backup mode, but it failed with ORA-01123. SQL> alter database begin backup; alter database begin backup *… Read More »How to Resolve ORA-01123: cannot start online backup; media recovery not enabled
Can not allocate log, archival required Saw an error-like message in alert log: ORACLE Instance ORCL - Can not allocate log, archival required Actually, this… Read More »How to Resolve "Can not allocate log, archival required"
ORA-00265 I bet your database is 8i or 9i and you were trying to startup the database along with a set of procedure in a… Read More »How to Resolve ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Do you know the space that the archived destination has in terms of days? Here is a sample shell script code to calculate the maximum… Read More »How to Calculate the Capacity of Archive Destination in Days