oracle database errors

[former_member182505]

hi experts

i m getting there error while checking database in db16. after clicking it its providing corrective action but

i dont know how to do this kindly provide m helps.

BACKUP_TOO_OLD- Start a complete database backup

LAST_BACKUP_FAILED- Check the database backup log

Checkpoint not complete- Increase the size of online redo log files

LOG_BUFFER- Change the Oracle parameter

19502- Check the archive destination

27072- Check the disk

ARCHIVER_STUCK- Save and delete archive log files

ARCHIVE_TOO_OLD- Start an archive log backup

16038- Check the archive destination

thanks

[former_member182505]

needfull help goted

[Former Member]

First check your systems file system specially Archive log directory. if it is full then take backup of archive log file iwth CopyDeleteSave option. once backup completed again verify your Backup. take full offline backup.

download ur init file and open it on Notepad then copare the parameter of Archivelog dest with cureent archive location . if it is differ then correct it.

Thnaks

Presu

[Former Member]

There are two way to to reduce log buffer probelm

1. Increase log buffer

2. Increase online Redo log file

See Note 309526 - Enlarging redo log files

Archive Stuck use -CDS option

[former_member204746]

have you ever backed up your system with BRBACKUP?

[former_member182505]

hi

i m taking backup thru brtools only.

[former_member204746]

from your logs:

BACKUP_TOO_OLD- Start a complete database backup

LAST_BACKUP_FAILED- Check the database backup log

your last valid backup is probably 10 days old... or older. This is unacceptable!

your last backup attempt failed. check that out.

[Former Member]

Hi,

In addition to above check below SAP notes & link.

Note 435290 - Description of BRCONNECT 6.10 DB check conditions

Note 483856 - Description of the alerts for Oracle database monitoring

http://help.sap.com/erp2005_ehp_04/helpdata/DE/4d/a241f0ee0d11d5996600508b5d5211/frameset.htm

Hope this helps.

Thanks

Sushil

[former_member204746]

db13 job "CheckDB" feeds info into DB16.

and checks are configured in DB17. so, read SAP note 830576, adapt Oracle parameters, then, adapt DB17. once done, clear DB16 entries and run DB13-checkDB again. at last, cfheck DB16 for errors that eare left and correct them by searching SAP note.

[Former Member]

Sadiq

refer this

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/3213b1c1d20c4ee10000000a11466f/content.htm

'BACKUP_TOO_OLD- Start a complete database backup'

read Notes, google, SDN about how to schedule/take backups

'LAST_BACKUP_FAILED'

it's because that the backup took last time, was failed, you can check return code in the backup logs

in /oracle/SID/sapbackup directory

LOG_BUFFER

refer Notes as per your release like this SAP Note 830576 - Parameter recommendations for Oracle

and then read oracle documentation and sap notes that how to change/update oracle parameters-not difficult

ARCHIVER_STUCK- Save and delete archive log files

ARCHIVE_TOO_OLD- Start an archive log backup

/oracle/SID/oraarch or /oracle/SID/saparch contains oracle redo log files, archiver_stuck means one of these filesystems is full, so you have to run redolog backup as the next warning says that archive_too_old .. read oracle docs and sap docs that how toschedule redolog backups

other things too, check and try to do first and if problem comes, always welcome

[abhimanyu_pandey]

Hi..

Please error ARCHIVER_STUCK check your "oraarch" and "saparch" whether it has space or not. IF not delete old archive OR take backup of old archive via Brarchive.

For LOG_BUFFER, please increase the LOG_BUFFER parameter by 10 times in initSID.ora

Regards,

Abhimanyu

[former_member182505]

hi

can u tell me plz how can i do this.