Oracle RedoLogs are Full - Now What?

[A. Clay Stephenson]

Hi Scott:

The easist thing to do (and avoid any Oracle stuff altogether) is to do some basic unix stuff. How abour this:

1) Unmount /u06
2) comment the entry in /etc/fstab so that you do not try to mount it later
3) Set up a symbolic link from some other directory/filesystem to /u06

[Andreas D. Skjervold]

Hi

To change your archive destination, just change your init.ora setting: "log_archive_dest=/new_path/" and startup once more.

If you're not familiar with Oracle, your init.ora is located in $ORACLE_HOME/dbs as init.ora (either as file or link to $ORACLE_BASE/admin/SID/pfile/init.ora)

Andreas

[Scott Buckingham]

Thanks, Clay, for the great advice! Your last suggestion worked like a champ! I ran fsck on the drive in question and it came up with all kinds of errors so until we get a new one, this solution will take precedence.

Andreas, I likde your suggestion too, but I tend to do things in order.

Thanks to all for your responses!

[A. Clay Stephenson]

Hi Scott:

Glad I was able to help. I intentionally gave you a 'pure' UNIX workaround since you seemed to be more comfortable in that world.

Regards, Clay