07 2023 档案

Oracle打开归档、强制、最小附加日志

摘要：startup mount; alter database archivelog; alter database force logging; alter database add supplemental log data; SELECT LOG_MODE,FORCE_LOGGING,SUPPLE 阅读全文

posted @ 2023-07-25 10:29 捌玖阅读(749) 评论(0) 推荐(0) 编辑

centos 7换源

摘要：yum install -y wget wget -P /etc/yum.repos.d/ wget http://mirrors.aliyun.com/repo/Centos-7.repo yum clean all cd /etc/yum.repos.d/ mkdir bak mv CentOS 阅读全文

posted @ 2023-07-24 18:00 捌玖阅读(10) 评论(0) 推荐(0) 编辑

迁移PDB文件

摘要：alter pluggable database PDB open; !mkdir /u01/app/oracle/oradata/PRODCDB/PDB/datafile -p alter database move datafile'/u01/app/oracle/oradata/PRODCDB 阅读全文

posted @ 2023-07-24 11:47 捌玖阅读(20) 评论(0) 推荐(0) 编辑