Database Administration (MOSC)

MOSC Banner

Archiver Error ORA-00257

edited Aug 9, 2018 10:20PM in Database Administration (MOSC) 17 comments

Hi Guys,

Need some advice on this error I am having.

Whenever I get this error (when connecting to the database) I would notice that the partition (where oracle is in installed at) is full.

Here is the following solutions I have tried:

1. Increase db_recovery_file_dest_size numerous times! (now its at 200gb)

2. Backed up all archived logs, deleted expired logs, crosschecked all logs. (no errors)

3. Changing the path of the FRA to a larger partition on my server from /u01/ to my home directory (Change Oracle Flash Recovery Area location | Beyond Oracle )

4. I have tried moving archive logs

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center