脚踏实地、勇往直前!
全部博文(1005)
发布时间:2018-12-12 16:04:36
CentOs下安装Elasticsearch集群环境:OS:CentOs 7Elasticsearch:6.5.0 1.安装步骤1.1 环境部署数据库部署节点ip角色Host01.........【阅读全文】
发布时间:2018-11-10 18:56:15
全部在rman下操作:1.backup AS copy datafile 4 format '/u01/app/oracle/oradata/catlogdb_copy/users01.dbf';2.SQL 'alter database datafile 4 offline';3.switch datafile 4 TO copy;4.recover datafile 4;5.SQL 'alter database datafile 4 online';RMAN> backup AS copy datafile 4 format '/u01/a.........【阅读全文】
发布时间:2018-10-09 15:46:14
ERROR 1709 (HY000) at line 50558: Index column size too large. The maximum column size is 767 bytes.解决办法:步骤1:set global innodb_file_format = BARRACUDA;set global innodb_large_prefix = ON;步骤2:修改创建表的脚本,条件如下项目ROW_FORMAT=DYNAMICDROP TABLE IF EXISTS `monxin_weixin_authcod.........【阅读全文】
发布时间:2018-09-03 10:43:39
1.停掉数据库[postgres@localhost rmanbak]$ pg_ctl stop -m immediate -D /db/pgsql/datawaiting for server to shut down.... doneserver stopped2.删除pg_data目录下的所有文件,我这里是重命名文件夹[postgres@localhost pgsql]$ mv data bakdata[postgres@localhost pgsql]$ mkdir data3.恢复[postgres@local.........【阅读全文】