on 01-22-2013 4:07 PM
Hi
For our DMS server d/b is MAXDB 7.6 and OS WIN32.
when i open D/b manager for backup , we can see two files to backup (S1 and S2)
S1 is able to come online but not S2. If i double click it (to make it online), error is something like --
"24988 sql server error [ backup_save S2 data recovery ] , -902 Message not available"
If i check database error files ---
2013-01-22 11:51:24 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:51:24 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:51:24 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:51:24 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 11:51:24 0x818 ERR 53013 I/O b15l_attach_log_for_read: blank devname
2013-01-22 11:51:30 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:51:30 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:51:30 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:51:30 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 11:51:30 0x818 ERR 53013 I/O b15l_attach_log_for_read: blank devname
2013-01-22 11:51:37 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:51:37 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:51:37 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:51:37 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 11:51:37 0x818 ERR 53013 I/O b15l_attach_log_for_read: blank devname
2013-01-22 11:52:22 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:52:22 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:52:22 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:52:22 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 11:52:22 0x818 ERR 53013 I/O b15l_attach_log_for_read: blank devname
2013-01-22 11:56:58 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:56:58 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:56:58 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:56:58 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 11:57:07 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:57:07 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:57:07 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
2013-01-22 11:57:07 0x818 ERR 53016 I/O F:\sapdb\CDB\saplog\DISKL001
2013-01-22 15:41:00 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 15:41:00 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 15:41:00 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
Can someone advice on this error. how to make it online?
WR
Swati
Hi Swati,
Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
As per above message it looks like log file for CDB database has some corruption. CDB is mostly used for caching in SAP DMS. Incase you have not enabled caching, you may restore CDB from old backup or re-install only the cache server again in your system.
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.
Hi Srinivasan and deepak,
Thanks for your reply
@srinivasan - I came to know that we can use USE_BACKUP_SECURITY_DESCRIPTOR parameter only If we want to backup to a Samba share, set this parameter to NO.
Also i have check parameter given under configuration in database manager but i cannot find this particular parameter.Where to find it..!
@deepak - Can you tell me what are the steps if he i re-install cache or restore the data for CDB.
Do we have other alternative.
Also in diagnosis file i found this error -
2013-01-21 17:42:24 | 0x1378 | 19614 DBSTATE I/O thread for 'G:\sapdb\CDB\sapdata\DISKD0001' stopped | ||
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0001', UKT:3 | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0001', UKT:6 | |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'G:\sapdb\CDB\sapdata\DISKD0002' | |
2013-01-21 17:42:24 | 0x970 | 19614 DBSTATE I/O thread for 'G:\sapdb\CDB\sapdata\DISKD0002' stopped | ||
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0002', UKT:3 | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0002', UKT:6 | |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'G:\sapdb\CDB\sapdata\DISKD0003' | |
2013-01-21 17:42:24 | 0x25C | 19614 DBSTATE I/O thread for 'G:\sapdb\CDB\sapdata\DISKD0003' stopped | ||
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0003', UKT:3 | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0003', UKT:6 | |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'G:\sapdb\CDB\sapdata\DISKD0004' | |
2013-01-21 17:42:24 | 0x1014 | 19614 DBSTATE I/O thread for 'G:\sapdb\CDB\sapdata\DISKD0004' stopped | ||
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0004', UKT:3 | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0004', UKT:6 | |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'G:\sapdb\CDB\sapdata\DISKD0005' | |
2013-01-21 17:42:24 | 0x1274 | 19614 DBSTATE I/O thread for 'G:\sapdb\CDB\sapdata\DISKD0005' stopped | ||
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0005', UKT:3 | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'G:\sapdb\CDB\sapdata\DISKD0005', UKT:6 | |
2013-01-21 17:42:24 | 0x1520 ERR 52050 SHUTDOWN *** EMERGENCY ***: 9050 | |||
2013-01-21 17:42:24 | 0x1520 | 19621 DBSTATE Shutdown kill requested | ||
2013-01-21 17:42:24 | 0x133C | 19617 DEVIO | Single I/O attach, 'knltrace', UKT:1 | |
2013-01-21 17:42:24 | 0x1398 | 19684 TASKING Tracewriter termination timeout: 1200 sec | ||
2013-01-21 17:42:25 | 0x133C | 19619 TASKING Releasing tracewriter | ||
2013-01-21 17:42:25 | 0x1398 | 19684 TASKING Tracewriter termination timeout: 1200 sec | ||
2013-01-21 17:42:25 | 0x1398 | 19600 VERSION 'Kernel | 7.3.0 | Build 035-000-090-294' |
2013-01-21 17:42:25 | 0x1398 | 19654 DBSTATE SERVERDB 'CDB' has stopped |
WR
Swati
Hi Deepak
Thanks a lot for your quick reply.
I will check regarding hardware as there is some issue going on with tivoli and will get back to you.
1 query as per above error mentioned in 1st post -
"
2013-01-22 11:51:24 0x71C ERR 18249 IO Devspace 'F:\sapdb\CDB\saplog\DISKL001' marked as bad at position 80
2013-01-22 11:51:24 0x818 ERR 53013 I/O error evaluating devspace
2013-01-22 11:51:24 0x818 ERR 53017 I/O LOGDEV DEVNO: 1
"
what is devspace exactly as i am new to maxdb database and dont know much abt it.
In dignosis file , same error for F: drive also -
2013-01-21 17:42:24 | 0x1520 ERR 53016 I/O | F:\sapdb\CDB\saplog\DISKL001 | |
2013-01-21 17:42:24 | 0xE90 ERR 18248 IO | Devspace 'F:\sapdb\CDB\saplog\DISKL001', position 80 was marked as bad | |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'F:\sapdb\CDB\saplog\DISKL001' |
2013-01-21 17:42:24 | 0x12BC | 19614 DBSTATE I/O thread for 'F:\sapdb\CDB\saplog\DISKL001' stopped | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'F:\sapdb\CDB\saplog\DISKL001', UKT:2 |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'F:\sapdb\CDB\saplog\DISKL001', UKT:3 |
2013-01-21 17:42:24 | 0x1520 ERR 52050 SHUTDOWN continued_log/disk_not_accessibl | ||
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'C:\sapdb\CDB\dbsys\SYS' |
2013-01-21 17:42:24 | 0x9D8 | 19614 DBSTATE I/O thread for 'C:\sapdb\CDB\dbsys\SYS' stopped | |
2013-01-21 17:42:24 | 0xE90 | 19618 DEVIO | Single I/O detach, 'C:\sapdb\CDB\dbsys\SYS', UKT:3 |
2013-01-21 17:42:24 | 0x1520 | 19616 DEVIO | Detaching devspace 'G:\sapdb\CDB\sapdata\DISKD0001' |
WR
Swati
Hi
We are planning to restore the database CDB. Can any1 help me out with the steps how to do it.
I know that it can be done thru recovery wizard.
do i need to create a new database and then restore all the data from CDB?
Please advice how to start with this.
WR
Swati
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepak
Thanks a lot for your quick response.
Just to confirm as i will do restore for first time , these are the steps i am going to follow -
1 Select the CDB d/b.
2 Goto recovery wizard and select option "restore a specified backup from history"
3 choose the file ( complete bkup file) that was last done on 18th jan.
4 Start
Is it ok to follow this steps? I am afraid that we cannot recover the files as last backup done was 18th jan.
If you can also confirm how much time it will take to restore.
My full points for you for all your help once i am sure with the activity to perform.
Hi Swati,
From MaxDB Version 7.5.00 Build 40 and 7.6.02 Build 03 onwards, a new parameter has been created to enable the use of SMB shares: USE_BACKUP_SECURITY_DESCRIPTOR
If you set this parameter to NO, no security descriptor will be used for opening backup file, thus the backup will run without problems.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.