Database Administration (MOSC)

MOSC Banner

Oracle didn't write archivelog on Solaris (Release 10.2.0.4.0)

I have a database on production (archivelog mode)

Made a backup on prod and restore to uat.

This database has 4 redolog group. It write to two location ( u04, u05).

Everytime I refresh the uat, it has no issues. But this time, it decided to not write on u04 (hence, no archivelog there) but archivelog does exist in u05 ( archivelog numbered 1,2,3,4).

Typing alter system switch logfile will give no result, it just stop there ( but can be cancelled).

After the uat runs for a few hours, trying to backup will fails with rman trying to look for archivelog numbered 34, even though in u05 there is only archivelog 1-4 and none in u04. It shows that internally the archivelog grows, it just didn't get written to disk.

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