Urgent... DB full, can't add new volumen!

[JPReyes]

Seems like our SAPDB is FULL... The DB won't go Online and seems like i can't create a new Volume in Admin mode..

Lst entry on knldiag

2006-06-14 10:18:06 0x58C WRN 40 Converte Restart aborted because of DB Full detection.

2006-06-14 10:18:06 0x58C ERR 69 Log REDO: T1561465 (committed) redoresult: 3, TrError: 1402

2006-06-14 10:18:06 0x880 ERR 52608 RESTART LOCAL: failed

2006-06-14 10:18:06 0x880 ERR 63 Log RESTART ERROR '1402' => SHUTDOWN IS FORCED

Please help!

Points will be rewarded!

Regards

Juan

[alexander_schroeder]

What's the error message appearing when you want to add a volume?

[JPReyes]

It sais "you can not add volumes now, the parameter file is changed. Stop and the restart database instance to get new parameters active"

[alexander_schroeder]

You need to bring the database offline as said by this message (db_offline). db_admin state is not sufficient

for the change you have made. May it be that you used

'param_addvolume' and not 'db_addvolume'?

[JPReyes]

I cannot add volumes when the DB is offline, it sais the db need to be online... at the moment im doing a full_backup in admin mode to see if i can put the db_online and add the volume...

Are you sure you can add volumes with the db_offline?

Regards

Juan

[JPReyes]

Problem solved!

In Admin mode.

I used cmd dbmcli -d <SID> -u db_adddevice data <filename> <vol pages>

Thanks for the help!

Juan