-
Ora-00257
I got an error message when I connect to oracle 8i, which is about ora-00257. I took a look at the error message. It said the archiver desitination is full. I checked the disk storage. Yes, it was full and then I freed them by deleting the old archiving logs. When I see there are enough space for archiving,I connected to the database. Unfortunately, the same error came up again. Should I delete all the archiving logs and make the archiving destination available 100% or I have to restart the database?
If I try to restart the database, there are a archiving process suspending.
Thanks in advance.
-
Do 'alter system archive log current'
OCP 7.3,8.0,8i,9i
-
sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;
if archive log destination is full the above command it sets/starts archiving to secondary destination i.e which we are specifying so that you wonot get any error
J Gangadhar
-
Hi,
Even after u free space in archive destination, oracle will still not be able to open the failed destination.
use the below command
ALTER SYSTEM ARCHIVE LOG START;
and Arch process will start archiving the redologs to the same destination
regards
anandkl
anandkl
-
sql> alter system set archive_log_dest=c:/abcd/efhn/ijk/....;
You need the REOPEN at the end, or else it won't start achiving. (and it's log_archive_dest, not archive_log_dest...)
Code:
ALTER SYSTEM SET log_archive_dest='location=/u01/oradata/archive reopen';
ALTER SYSTEM ARCHIVE LOG ALL;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|