ITPub博客

第一种方法：先查询出源表数据：select 'insert into @tmp exec sp_spaceused '+name From sys.tables with(nolock)  order by create_date desc;创建临时表并把查询出来的源表数据insert进入临时表，再查询出来最后临时表里面的数据：declare @tmp table(tbname varchar(255),tbrows int,reserved varchar(255),...

从链接服务器查询远程服务器的数据库信息报错：本地数据库服务器：10.0.0.100远程数据库服务器：10.0.0.101select Company,billno from [10.0.0.101 ].edi.abb.bill where LastUpdateTime between convert(char(10),'2017-09-01',120) and convert(char(10),'2017-09-10',120)DBCC 执行完毕。如果 DBCC 输出了错误信息...

附加数据库失败，操作系统错误 5:"5(拒绝访问。)"解决办法：找到xxx.MDF与xxx_log.LDF文件，右键-属性-安全-在组或用户名处添加Authenticated Users-更改该组权限为完全权限，再次附加成功。 

[oracle@test admin]$ pwd/u01/app/oracle/product/11.2.0/db_1/network/admin[oracle@test admin]$ cat listener.ora# listener.ora Network Configuration File: /oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.LISTENER =  (DESCRIPTI...

SSMS里面操作：master 库：启动端口：use master;ALTER ENDPOINT [Hadr_endpoint] STATE = STARTED;停止端口：use master;ALTER ENDPOINT [Hadr_endpoint] STATE = STOPPED;检查端口状态：从另一台alwayson服务器去telnet本机的alwayson端口5022telnet 10.0.2.100 5022...

授权：grant connect to test01;;

[root@test tmp]# du -sh test.sql17G     test.sqlmysqldump备份的文件[root@test ~]# mysql -uroot -ptestpassword --default-character-set=utf8 test < /tmp/test.sqlmysql: [Warning] Using a password on the command line interface can be insecure.ERROR 1049 (42000): Unknown database 'test'...

在DG上执行：SQL> select database_role from v$database;DATABASE_ROLE----------------PHYSICAL STANDBY原本DG是mount状态。SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;Database altered.SQL> alter database open read only;Database altered.SQL> ALTER DATABASE RECOVER MANAGED STANDB...

数据库版本：11.2.0.3.0RAC双节点，DG一节点。RAC节点1正常，RAC节点2出现log file sync严重等待事件，数据库性能受到严重影响。从AWR报告看：DB Time很高，log file sync等待严重。正常情况下log file sync的Avg wait应该是1。问题表现是log buffer向log file写入很慢。排除了IO问题。有一篇文章关于11.2.0.3的...

在DG上操作：SQL> select RECOVERY_MODE from v$archive_dest_status where rownum select group#,member from v$logfile order by 1;    GROUP#----------MEMBER---------------------------------------------...

[root@test ~]# mysqldump -h 139.100.210.22 -u root -p'test123' --default-character-set=utf8 test_db > /tmp/test_db.sql[root@test ~]# mysqldump -h 远程服务器IP或域名 -u 远端数据库账号 -p'远端数据库密码' --default-character-set=utf8 数据库名字 > /tmp/test_db.sql可以在本地...

修改mysql参数文件：[root@test ~]# vi /etc/my.cnf在[mysqld]后面加入：skip-external-locking保存。[root@test ~]# service mysqld restartMySQL server PID file could not be found!                  [FAILED]不需要密码就能登录：[root@test ~]# mysql -ur...

在sqlserver服务器端安装此下载将安装一系列组件，用于帮助在 2010 Microsoft Office System 文件与非 Microsoft Office 应用程序之间传输数据。AccessDatabaseEngine_X64.exeAccessDatabaseEngine.exe安装完成后在服务器SSMS的链接服务器选项下面会出现：如果服务器上安装了office2013，就会出现下面的那个15.0...

[root@test ~]# su - oracle[oracle@test ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 17 21:28:22 2017Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith ...

找到linux下面mysql执行路径eipdb2:~ # cd /eipdb2/mysql/bin/eipdb2:/eipdb2/mysql/bin # pwd/eipdb2/mysql/bin找到/etc/profile在最后加入环境变量export PATH=/eipdb2/mysql/bin:$PATH"/etc/profile" 419L, 9839C source profile让环境变量生效以后在任何目录下都能输...

环境：mysql主从，一台主机，一台备机。都是虚拟机。备机仅仅用来备份，不用于业务。关闭主机mysql服务，关闭主机系统，加内存。、备机不变。开启主机。内存加好。EIPDB1:~ # free -mtotal used free shared buffers cachedMem: 48274 ...

备库关闭日志应用：SQL> select status from v$instance;STATUS------------MOUNTEDSQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;Database altered.日志报错：ORA-16037: user requested cancel of managed recovery operationManaged Standby Rec...

[root@test ~]# wget http://mirrors.linuxeye.com/oneinstack-full.tar.gz --2017-10-11 10:23:09-- http://mirrors.linuxeye.com/oneinstack-full.tar.gzResolving mirrors.linuxeye.com... 121.196.203.66Connecting to mirrors.linuxeye.com|121.196.203.66|:80... connected.HTTP request sent, aw...

统计信息

oracle 11g 体系结构