what the error is telling you is that the redo log is full and it needs to write the information to the archive log but it can't. So, that means one of two problems.
1. You don't have enough disk space on the drive for the archive log to be created.
2. Oracle doesn't have permissions to write to the drive specified.
ps. how many redo logs do you have?
Good Lord I'm messing up.
Ignore the above. Your redo logs...how many and how big are they? Check you alert.log and see how often you're switching redo logs. They're probably too small and not enough. The archiver can't keep up. Also check your log_archive settings in the init.ora to see that it is set to true and if it is did you do a startup mount archive?
Last edited by OracleDoc; 07-29-2004 at 05:40 AM.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
Reply With Quote