Friday 6 January 2012

Master Device curruption

SCENARIO :1: Master Device curruption without a backup .

1) create new mastre device with dataserver utility .
2)Edit the  ASE run file (-d parameter) to point to the new master device.
dataserver -d /var/sybase/masterdb.dat -b100M -sMASTER2K3)start up ASE in single user mode (-m) option .
4)Alter master databse to original size .
5) issue disk reinit command to restore sysdevices entries.
6) issue disk refit command to restore sysdatabases & sysusages entries.
disk refit
go
7)Execute the installmaster T-SQL script .
8)Execute the installmodel T-SQL script .
9)Recreate logins .
10)Restart ASE in multiuser mode .
11)Other step to consider :-
     i) new passwd for all login including sa..
     ii)Mirror the new master device & turn off the default status.
     iii)Run consiustency ( dbcc ) check in critical db.
     iv) Add entries in master..sysservers for the local ASE & all remote servers ,
          including Backup server.
     v) Alter and customize the model database
     vi) disk reinit  :- This step is critical , if you dont have original command disk init you cannot
                               proceed for master restoration.

SCENARIO :2: Master Device curruption with a backup .

1) create new mastre device with dataserver utility .
2)Edit the  ASE run file (-d parameter) to point to the new master device.
dataserver -d /var/sybase/masterdb.dat -b100M -sMASTER2K3)start up ASE in single user mode (-m) option .
4)Alter master databse to original size .
*5) Manually update sysservers for correct Backup server entry.
update sysservers set srvnetname= 'YODA_BACKUP'
where srvnetname='SYB_BACKUP'
*6) Load master database from backup.

7)Execute the installmodel T-SQL script .
8)Restart ASE in multiuser mode .

No comments:

Post a Comment