on 01-16-2009 10:16 AM
I have problem today i couldn't see may archive redo log on production system.
I use ECC6 on Oracle 10.2 and Windows 2003 server.
windows system event -
> The file system structure on the disk is corrupt and unusable. Please run the chkdsk utility on the volume REDO. /RAID1 only for archive and origlog/
I trying to change my archive log destination without stop database instance but archive process cannot write archive redo logs .
Could you help me with this problem
i change log_archive destination parameter in memory and arch process write first archive log , now i will start online backup
thank you very much
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Plamen,
This issue should not be taken lightly. It may turn out to be a costly affair.
My suggestion is to
1) Stop your DB instance.
2) Change your archive log backup destination directory by changing the parameter.
Ensure that orasid user has read,write authorisation to this new destination.
3) Take backup of the file archSID.log (placed at /oracle/SID/oraarch) and alertSID.log (placed at /oracle/SID/saptrace/background).
4) Start the DB instance.
5) Look for any errors reported in the alertSID.log
6) Start an online backup of the system to ensure that the DB can be recovered in case of a crash.
Hope this helps.
Regards,
Deoraj Alok.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As per http://support.microsoft.com/kb/246026
You might have to consider fixing the filesystem and restore from backup.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.