on 06-12-2014 10:16 AM
Hello members,
One of our SAP server with MaxDB as database is down. Data Area is 100 full. Server Disk space is also full. We cannot create/add new data volumes in this disc.
Now we have created directory in another server. Can we map that network folder on server and add new data volume to that folder?
I am trying to do it but I am getting -24988 SQL error [db_online -f]; -902, I/O error
I have also followed link
Please help.
Thanks,
Srikanth
Hi Srikanth,
Now we have created directory in another server. Can we map that network folder on server and add new data volume to that folder?
This is not a good solution as access to network folders during runtime may create issues.
Can you add up disks to the server and create data volumes in the same.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the reply Deepak.
Yes, now we have created space in local drive only.
But somehow when trying to create file on network drive, though it was not successful, it created a file in local default database folder with 0 KB size. And in database, data file size shows as 3 GB.
Now able add file to newly created space in local drive, nor able to delete the existing data file.
Database is also offline. It is not coming online.
Any suggestions please.
Thanks,
Srikanth
Hello Deepak,
Issue is resolved now.
I took back up of SID file in /sapdb/data/wrk directory. And run 'restore_param 1' command.
Later I was able to bring back DB to online state. And I was able to add new Data volumes to another local disk.
System is up now.
Thanks for your help man.
Thanks,
Srikanth
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
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.