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 .
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