摘要:
静默安装Oracle数据库11g 需求:静默安装Oracle数据库11g 操作系统:centos 7 【0】配置yum源(若有yum源也可以不用配置本地) 【0】修改主机名和/etc/hosts 【1】防火墙配置 【2】Selinux配置 【3】修改/etc/sysctl.conf 【4】修改/et 阅读全文
摘要:
表空间管理类 查看表空间使用率 sql> set line 220 sql> select total.tablespace_name,round(total.MB, 2) as Total_MB,round(total.MB - free.MB, 2) as Used_MB,round((1 - 阅读全文
摘要:
SQL> startup nomount ORACLE instance started. Total System Global Area 395387088 bytes Fixed Size 454864 bytes Variable Size 285212672 bytes Database 阅读全文
摘要:
Firstly ORACLE will never allow you to drop the current ONLINE redolog file – Ex : SQL> select GROUP#,THREAD#,STATUS from v$log; GROUP# THREAD# STATUS 阅读全文
摘要:
This note examines how to create an Oracle 12.1.0 physical standby Active Data Guard database using the RMAN DUPLICATE FROM ACTIVE command. We will be 阅读全文