-
编辑 删除
恢复master db 到新建的server上出现的坑
今天，因为WINDOWS PATCH原因，导致SQLSERVER生产库上的WINDOWS崩溃，也因为SQLSERVER没有HA，DR， 但是有每天的FULL BACKUP（万幸）， 没办法，赶紧恢复数据库到新的server上，碰到了一些坑1.WINDOWS TEAM的人新建了NEW SERVER2.开始在新建的NEW SERVER上INSTALL SQLSERVER3.环境准备好，开始恢复MASTER DB，如下将...
-
编辑 删除
oracle 常用查询/oracle common query
create table tom1 (id int,age varchar(10),name varchar(20));insert into tom1 values(1,'20','tom');select * from tom1;##查找当前SGA值show parameter sga_targetselect * from v$sgastat;##查找在给定时间内分配给PGA的最大值select value from v$pgastat where name='maximum PGA allocated'；##sga_tar...
-
编辑 删除
ASM common view/ASM 常用视图
V$ASM_DISK Contains one row for every disk discovered by the Oracle ASM instance, including disks that are not part of any disk group.This view performs disk discovery every time it is queried.V$ASM_DISK_IOSTATDisplays information about disk I/O statistics for each Oracle ASM client.In an Oracle D...
-
编辑 删除
MSSQLSERVER| Linked server can not been connected
解决因为SPN的原因导致linked server不能连接的问题
-
编辑 删除
oracle shrink tempfile to release free space on the tempspace
background: Received Disk capacity Warning on one of our oracle database servers,So needs to check is the data increasing as expect or any abnormal case1. Checked on the target Drive to check if any other files created --checked--No2. Checked the tablespace useage as followSQL...
-
编辑 删除
DB2 V9.7 install special fixpack steps
1. log on to the target server & sudo to db2 instance IDsudo su – db2fin2. backup the related cfg fil...
-
编辑 删除
Ten TOP T-SQL IN MS-SQL
T-SQL Statement 1The following T-SQL statement retrieves information such as Hostname, Current instance name, Edition, Server type, ServicePack and version number from current SQL Server connection. 'Edition' will give information on a 32 bit or 64 bit architecture and 'Productlevel' give...
-
编辑 删除
MS-SQL 常用命令
1. 将DB立即置于OFFLINE状态ALTER DATABASE bba_pld03_20150304 SET OFFLINE with ROLLBACK IMMEDIATE;2.如果碰到错误如“ALTER DATABASE failed because a lock could not be placed on database",则可以先运行SP_WHO，找出当前哪些SPID在需要OFFLINE的DB上。KILL <SPID>3.查看MS-SQL启动时间...
