1412702161-CSDN博客

完备脚本#!/bin/bashexport ORACLE_SID=db3export ORACLE_BASE=/u01/oracleexport ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1$ORACLE_HOME/bin/rman target / << EOFrun{allocate channel c1 type disk;allocate channel c2 type disk;allocate channel c

2022-01-31 09:52:23 1884

原创 linux 软链结

sudo mv xxx /mnt/ssdsudo ln -s /mnt/ssd/xxx xxx

2022-01-20 09:41:56 703

原创 windows 匿名 nfs server

2022-01-04 09:34:36 338

原创 linux mount nfs

mkdir /dbbackupmount -t nfs -o nolock IP:"/NFS_ORA.BACKUP" /dbbackup/

2022-01-04 09:32:57 574

原创 oracle备份还原

备份#!/bin/bashexport ORACLE_SID=LOCALSIDexport ORACLE_BASE=/u01/oracleexport ORACLE_HOME=/u01/oracle/product/11.2.0/dbhome_1$ORACLE_HOME/bin/rman target / << EOFrun{allocate channel c1 type disk;allocate channel c2 type disk;allocate channe

2022-01-04 09:31:36 641

原创 linux centos mount windows smb

mount -t cifs -o vers=2.0,user=xxxx,password=xxx //IP/xshare /mnt/smb

2021-12-16 10:05:21 1103

原创 KVM BUG: virsh reporting unknown feature amd-sev-es

journal[1405]: internal error: unknown feature amd-sev-es这是已知的BUGhttps://bugzilla.redhat.com/show_bug.cgi?id=1961558https://bugzilla.redhat.com/show_bug.cgi?id=1961562解决方法：降级# yum downgrade edk2-ovmf# mkdir -p /etc/qemu/firmware# touch /etc/qemu/fi

2021-07-27 14:08:52 414

原创 CentOS 8 修改内核启动参数 intel_iommu

安装grubby# yum install grubby查询所有内核# grubby --info=ALLindex=0kernel="/boot/vmlinuz-4.18.0-315.el8.x86_64"args="ro resume=UUID=a63871c8-47e7-4ba0-be75-d4591ae9a6f2 rhgb quiet $tuned_params"root="UUID=bab6c0db-5674-4994-b168-62e87d2a4ae2"initrd="/bo

2021-07-09 09:22:06 2602 1

原创 [Err] 1118 - Row size too large (＞ 8126).

mariadb 与 mysql 新版好像都会遇到1. 关闭数据库2. config 添加或修改两段innodb_log_file_size=1024Minnodb_strict_mode=03. 启动数据库注：启动过程中可能会卡住附：状态查询show variables like '%innodb_strict_mode%;show variables like '%innodb_log_file_size%';...

2021-02-20 21:38:04 203

原创 ORACLE ASM 没挂盘, 手动mount

数据库重启后无法启动ORA-00210: cannot open the specified control fileORA-00202: control file: '+FRA/sqmesdb/controlfile/current.284.1058976347'ORA-17503: ksfdopn:2 Failed to open file +FRA/sqmesdb/controlfile/current.284.1058976347ORA-15001: diskgroup "FRA" do

2021-02-09 14:05:43 398

原创 ORACLE DG 操作

DG启动SQL> STARTUP MOUNT;SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;或（一般我用这个）SQL > STARTUP;SQL>recover managed standby database using current logfile disconnect;DG关闭SQL> ALTER DATABASE RECOV.

2021-02-04 13:23:41 186

原创 ORACLE UNDOTBS 持续增加或 UNDOTBS 过大问题

缩短快照时间alter system set undo_retention=28800 sid=’*’ scope=both;新增一TBS进行新旧替换alter system set undo_tablespace=undotbs3_new;

2021-02-03 10:25:35 366

原创 ORACLE LGWR ARCHIVAL 归档时业务卡顿

相关LOG******************************************************************LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_3******************************************************************LNS: Standby redo logfile selected for thread 3

2021-02-02 09:01:23 408

原创 oracle asm asmca 使用方法

在自己电脑上安装Xmanager 6并且开启程序：Xmanager - Passive登陆到OracleGrid用户# su - oragrid将输出导向export DISPLAY=自己的IP:0.0开启asmca$asmca

2021-02-01 08:49:14 970

原创修改ORACLE DB_FILES

确认DB_FILES数量SQL> show parameter db_files;NAME TYPE VALUE------------------------------------ ----------- ------------------------------db_files integer 200检查是否由SPFILE或PFILE

2020-11-03 16:21:41 1715

原创 ORACLE ASM空间增加(分区盘做法)

今天要还原一台数据库发现空间不足, 正好把加盘的完整操作记录下来整体动作分两块1. LINUX分区2. ASM挂盘1. LINUX分区增加硬盘空间# fdisk /dev/sdbCommand (m for help): pDisk /dev/sdb: 10995.1 GB, 10995116277760 bytes, 21474836480 sectorsUnits = sectors of 1 * 512 = 512 bytesSector size (.

2020-11-02 14:28:35 928

原创 mysql blob 查看

CONVERT (FIELD USING utf8)SELECT *, CONVERT (CONTENT USING utf8) as CONTENT FROM T_CONTENT

2020-06-23 17:30:41 205

空空如也

空空如也