数据库安装
首先在虚拟机172.17.10.22上部署Oracle 11.2.0.4数据库
查看Linux系统版本信息
[root@localhost ~]# cat /proc/version
Linux version 2.6.32-504.el6.x86_64 (mockbuild@x86-023.build.eng.bos.redhat.com) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-11) (GCC) ) #1 SMP Tue Sep 16 01:56:35 EDT 2014
查看Linux发行版本ID及描述信息
[root@localhost ~]# lsb_release -id
Distributor ID: RedHatEnterpriseServer
Description: Red Hat Enterprise Linux Server release 6.6 (Santiago)
查看CPU信息
[root@localhost ~]# lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 16
On-line CPU(s) list: 0-15
Thread(s) per core: 1
Core(s) per socket: 1
Socket(s): 16
NUMA node(s): 2
Vendor ID: GenuineIntel
CPU family: 6
Model: 85
Stepping: 7
CPU MHz: 2194.843
BogoMIPS: 4389.68
Hypervisor vendor: VMware
Virtualization type: full
L1d cache: 32K
L1i cache: 32K
L2 cache: 1024K
L3 cache: 14080K
NUMA node0 CPU(s): 0-7
NUMA node1 CPU(s): 8-15
查看内存信息
[root@localhost ~]# free -m
total used free shared buffers cached
Mem: 32111 565 31546 1 62 118
-/+ buffers/cache: 384 31727
Swap: 2047 0 2047
设置yum源
查看镜像是否挂载
[root@localhost ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 392G 13G 359G 4% /
tmpfs 16G 72K 16G 1% /dev/shm
新建挂载目录
[root@localhost ~]# mkdir -p /media/cdrom
将镜像挂载到目录
[root@localhost ~]# mount /dev/cdrom /media/cdrom/
mount: block device /dev/sr0 is write-protected, mounting read-only
编辑yum源配置文件
[root@localhost ~]# vi /etc/yum.repos.d/rhel.repo
[rhel]
name=rhel
baseurl=file:///media/cdrom
enabled=1
gpgcheck=0
清空并重新加载yum仓库
[root@localhost ~]# yum clean all
[root@localhost ~]# yum repolist all
安装软件包
[root@localhost ~]# yum install -y binutils* compat-lib* gcc* glibc* ksh* libgcc* libstdc* libaio* make* sysstat* elfutils*
新建组
[root@localhost ~]# /usr/sbin/groupadd oinstall
新建dba、oper组并赋予组id
[root@localhost ~]# /usr/sbin/groupadd -g 502 dba
[root@localhost ~]# /usr/sbin/groupadd -g 503 oper
新建用户oracle并赋予用户id,并将oinstall组设置为初始组、dba和oper为附加组
[root@localhost ~]# /usr/sbin/useradd -u 502 -g oinstall -G dba,oper oracle
设置oracle用户密码
[root@localhost ~]# passwd oracle
设置oracle的软限制和硬限制
[root@localhost ~]# vi /etc/security/limits.conf
加入下列内容(最好手动输入,不要复制)
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
设置内核参数
[root@localhost ~]# vi /etc/sysctl.conf
加入下列内容
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
内核生效
[root@localhost ~]# /sbin/sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
创建数据库目录
[root@localhost ~]# mkdir -p /u01/oracle
变更目录的所有者及所属组
[root@localhost ~]# chown -R oracle:oinstall /u01
变更目录权限
[root@localhost ~]# chmod -R 775 /u01/oracle
配置oracle用户环境
[root@localhost ~]# su - oracle
[oracle@localhost~]$ vi /home/oracle/.bash_profile
加入下列内容
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_TERM=xterm
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export CLASSPATH=$ORACLE_HOME/JRE:ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
将Oracle安装包上传至/u01/oracle目录,root用户解压
[root@localhost ~]# cd /u01/oracle/
[root@localhost oracle]# ll
total 2487200
-rw-r--r--. 1 oracle oinstall 1395582860 Jan 19 20:00 p13390677_112040_Linux-x86-64_1of7.zip
-rw-r--r--. 1 oracle oinstall 1151304589 Jan 19 20:00 p13390677_112040_Linux-x86-64_2of7.zip
[root@localhost oracle]# unzip p13390677_112040_Linux-x86-64_1of7.zip
[root@localhost oracle]# unzip p13390677_112040_Linux-x86-64_2of7.zip
[root@localhost database]# vi /etc/profile
[root@localhost database]# cat /etc/profile
#省略……
export DISPLAY=:0.0
[root@localhost database]# source /etc/profile
[root@localhost database]# xhost +
access control disabled, clients can connect from any host
执行oracle安装程序,进入图形化安装界面
[root@localhost oracle]# su - oracle
[oracle@localhost ~]$ cd /u01/oracle/database/
[oracle@localhost database]$ ./runInstaller
去除I wish to receive security updates via My Oracle Support前面的勾
选择Yes,下一步
选择Skip software updates,下一步
选择Create and configure a database,下一步
选择Server Class,下一步
选择Single instance database installation,下一步
选择Advanced install,下一步
将Simplified Chinese添加到右侧,下一步
选择Enterprise Edition,下一步
核对数据库目录,下一步
默认,下一步
选择General Purpose/Transaction Processing,下一步
默认,下一步
默认启用内存自动管理
字符集中选择Simplified Chinese ZHS16GBK,其余默认
默认,下一步
选择File System,确认数据库文件位置,下一步
选择Do not enable automated backups,下一步
选择Use the same password for all accounts,下一步
默认,下一步
根据先决条件检查结果,将不满足的问题一一解决
选择Fix&Check Again,进入/tmp/CVU_11.2.0.4.0_oracle/目录,运行runfixup.sh脚本
[oracle@localhost ~]$ cd /tmp/CVU_11.2.0.4.0_oracle
[oracle@localhost CVU_11.2.0.4.0_oracle]$ ./runfixup.sh
部分问题已解决
对swap空间进行扩容,扩容大小根据先决条件中提示的大小,其中bs的大小和count的数据乘积就是需要的大小
[root@localhost ~]# cd /tmp
[root@localhost tmp]# dd if=/dev/zero of=swapfree bs=32k count=524288
将swapfree设置为Swap交互空间
[root@Orcl tmp]# mkswap swapfree
开启交换空间
[root@Orcl tmp]# swapon swapfree
上传pdksh-5.2.14-37.el5.x86_64.rpm至/u01/oracle目录
[oracle@localhost ~]$ cd /u01/oracle
[oracle@localhost oracle]$ rpm -ivh --nodeps pdksh-5.2.14-37.el5.x86_64.rpm
针对soft limit问题,root用户在/etc/security/limit.cof中手动输入,复制粘贴可能系统识别不了
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
再次检测,告警全部消失,选择install
数据库开始安装
安装完成后,弹框中选择OK即可
运行相应脚本
[root@localhost ~]# cd /u01/oraInventory/
[root@localhost oraInventory]# ./orainstRoot.sh
[root@localhost oraInventory]# cd /u01/oracle/product/11.2.0/db_1/
[root@localhost db_1]# ./root.sh
数据库相关信息如下
至此,数据库安装完成,相同方式在虚拟机172.17.10.23上部署Oracle 11.2.0.4数据库
DG部署
在172.17.10.22主库配置
修改主机名
[root@localhost ~]# vi /etc/hosts
添加
172.17.10.22 cffcdg1
[root@localhost ~]# vi /etc/sysconfig/network
将HOSTNAME=localhost.localdomain修改成
HOSTNAME=cffcdg1
重启172.17.10.22主库
在172.17.10.23备库配置
修改主机名
[root@localhost ~]# vi /etc/hosts
添加
172.17.10.23 cffcdg2
[root@localhost ~]# vi /etc/sysconfig/network
将HOSTNAME=localhost.localdomain修改成
HOSTNAME=cffcdg2
重启172.17.10.23备库
在172.17.10.22主库配置
[oracle@cffcdg1 ~]$ vi /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/
admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = cffcdg1)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/oracle/product/11.2.0/db_1)
(SID_NAME = orcl)
)
ADR_BASE_LISTENER = /u01/oracle
[oracle@cffcdg1 ~]$ vi /u01/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/
admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
STANDBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
重启监听
[oracle@cffcdg1 ~]$ lsnrctl stop
[oracle@cffcdg1 ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-JAN-2022 21:46:55
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/cffcdg1/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-JAN-2022 21:46:55
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
启动数据库
[oracle@cffcdg1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 21:54:03 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 922747784 bytes
Database Buffers 3338665984 bytes
Redo Buffers 12107776 bytes
Database mounted.
Database opened.
root用户关闭防火墙和selinux
[root@cffcdg1 ~]# vi /etc/selinux/config
[root@cffcdg1 ~]# service iptables stop
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Flushing firewall rules: [ OK ]
iptables: Unloading modules: [ OK ]
[root@cffcdg1 ~]# chkconfig iptables off
在172.17.10.23备库配置
[oracle@cffcdg2 ~]$ vi /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/
admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = cffcdg2)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/oracle/product/11.2.0/db_1)
(SID_NAME = orcl)
)
ADR_BASE_LISTENER = /u01/oracle
[oracle@cffcdg2 ~]$ vi /u01/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/
admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
STANDBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.10.23)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
重启监听
[oracle@cffcdg2 ~]$ lsnrctl stop
[oracle@cffcdg2 ~]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-JAN-2022 21:48:53
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/cffcdg2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg2)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-JAN-2022 21:48:53
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg2)(PORT=1521)))
The listener supports no services
The command completed successfully
启动数据库
[oracle@cffcdg2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 21:58:35 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 922747784 bytes
Database Buffers 3338665984 bytes
Redo Buffers 12107776 bytes
Database mounted.
Database opened.
root用户关闭防火墙和selinux
[root@cffcdg2 ~]# vi /etc/selinux/config
[root@cffcdg2 ~]# service iptables stop
[root@cffcdg2 ~]# chkconfig iptables off
测试主备库网络
主库测试
[oracle@cffcdg1 ~]$ sqlplus system/CFFC_Server1023@standby
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 22:05:52 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
[oracle@cffcdg1 ~]$ sqlplus system/CFFC_Server1022@primary
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 22:06:00 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
备库测试
[oracle@cffcdg2 ~]$ sqlplus system/CFFC_Server1022@primary
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 22:10:02 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
[oracle@cffcdg2 ~]$ sqlplus system/CFFC_Server1023@standby
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 19 22:10:34 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
如果在主备库均可登陆对端数据库,则表明 listener.ora 和 tnsnames.ora 文件配置正常。
在172.17.10.22主库配置
[oracle@cffcdg1 ~]$ mkdir /u01/oracle/oradata/archivelog
开启数据库归档
[oracle@cffcdg1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 07:33:07 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Current log sequence 9
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 922747784 bytes
Database Buffers 3338665984 bytes
Redo Buffers 12107776 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system set log_archive_dest_1='location=/u01/oracle/oradata/archivelog' scope=spfile;
System altered.
开启数据库force_logging
SQL> select force_logging from v$database;
FOR
---
NO
SQL> alter database force logging;
Database altered.
SQL> select force_logging from v$database;
FOR
---
YES
配置数据库redo日志,配置5个redo日志,每个redo日志500M
SQL> set linesize 150
SQL> col member for a50
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo03.log 3 1 1 CURRENT 50
/u01/oracle/oradata/orcl/redo02.log 2 1 1 INACTIVE 50
/u01/oracle/oradata/orcl/redo01.log 1 1 1 INACTIVE 50
SQL> alter database add logfile group 4 '/u01/oracle/oradata/orcl/redo04.log' size 500m;
Database altered.
SQL> alter database add logfile group 5 '/u01/oracle/oradata/orcl/redo05.log' size 500m;
Database altered.
SQL> alter database add logfile group 6 '/u01/oracle/oradata/orcl/redo06.log' size 500m;
Database altered.
多次切换redo日志,使redo01、redo02、redo03状态为INACTIVE
SQL> alter system switch logfile;
System altered.
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo03.log 3 1 1 INACTIVE 50
/u01/oracle/oradata/orcl/redo02.log 2 1 1 INACTIVE 50
/u01/oracle/oradata/orcl/redo01.log 1 1 1 INACTIVE 50
/u01/oracle/oradata/orcl/redo04.log 4 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo05.log 5 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo06.log 6 1 1 CURRENT 500
6 rows selected.
删除group 1、group 2、group 3
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo04.log 4 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo05.log 5 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo06.log 6 1 1 CURRENT 500
SQL> exit
删除redo01.log、redo02.log、redo03.log
[oracle@cffcdg1 ~]$ cd /u01/oracle/oradata/orcl/
[oracle@cffcdg1 orcl]$ rm -rf redo01.log
[oracle@cffcdg1 orcl]$ rm -rf redo02.log
[oracle@cffcdg1 orcl]$ rm -rf redo03.log
添加group1、group2、group3,并将redo大小设置为500M
[oracle@cffcdg1 orcl]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 07:37:38 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database add logfile group 1 '/u01/oracle/oradata/orcl/redo01.log' size 500m;
Database altered.
SQL> alter database add logfile group 2 '/u01/oracle/oradata/orcl/redo02.log' size 500m;
Database altered.
SQL> alter database add logfile group 3 '/u01/oracle/oradata/orcl/redo03.log' size 500m;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo01.log 1 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo02.log 2 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo03.log 3 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo04.log 4 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo05.log 5 1 1 CURRENT 500
/u01/oracle/oradata/orcl/redo06.log 6 1 1 INACTIVE 500
6 rows selected.
SQL> alter database drop logfile group 6;
Database altered.
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo01.log 1 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo02.log 2 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo03.log 3 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo04.log 4 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo05.log 5 1 1 CURRENT 500
SQL> exit
删除redo06.log
[oracle@cffcdg1 ~]$ cd /u01/oracle/oradata/orcl/
[oracle@cffcdg1 orcl]$ rm -rf redo06.log
在主库上创建备库日志文件,备库日志文件始终比主库日志文件多一个
[oracle@cffcdg1 orcl]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 07:39:32 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set linesize 150
SQL> col member for a50
SQL> select a.member,b.group#,b.thread#,b.members,b.status,b.bytes/1024/1024 from v$logfile a,v$log b where a.group#=b.group#;
MEMBER GROUP# THREAD# MEMBERS STATUS B.BYTES/1024/1024
-------------------------------------------------- ---------- ---------- ---------- ---------------- -----------------
/u01/oracle/oradata/orcl/redo01.log 1 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo02.log 2 1 1 INACTIVE 500
/u01/oracle/oradata/orcl/redo03.log 3 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo04.log 4 1 1 ACTIVE 500
/u01/oracle/oradata/orcl/redo05.log 5 1 1 CURRENT 500
SQL> alter database add standby logfile group 6 '/u01/oracle/oradata/orcl/redo06.log' size 500m;
Database altered.
SQL> alter database add standby logfile group 7 '/u01/oracle/oradata/orcl/redo07.log' size 500m;
Database altered.
SQL> alter database add standby logfile group 8 '/u01/oracle/oradata/orcl/redo08.log' size 500m;
Database altered.
SQL> alter database add standby logfile group 9 '/u01/oracle/oradata/orcl/redo09.log' size 500m;
Database altered.
SQL> alter database add standby logfile group 10 '/u01/oracle/oradata/orcl/redo10.log' size 500m;
Database altered.
SQL> alter database add standby logfile group 11 '/u01/oracle/oradata/orcl/redo11.log' size 500m;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------- ---
1 ONLINE /u01/oracle/oradata/orcl/redo01.log NO
2 ONLINE /u01/oracle/oradata/orcl/redo02.log NO
3 ONLINE /u01/oracle/oradata/orcl/redo03.log NO
4 ONLINE /u01/oracle/oradata/orcl/redo04.log NO
5 ONLINE /u01/oracle/oradata/orcl/redo05.log NO
6 STANDBY /u01/oracle/oradata/orcl/redo06.log NO
7 STANDBY /u01/oracle/oradata/orcl/redo07.log NO
8 STANDBY /u01/oracle/oradata/orcl/redo08.log NO
9 STANDBY /u01/oracle/oradata/orcl/redo09.log NO
10 STANDBY /u01/oracle/oradata/orcl/redo10.log NO
11 STANDBY /u01/oracle/oradata/orcl/redo11.log NO
11 rows selected.
主库创建standby控制文件与参数文件
SQL> alter database create standby controlfile as '/u01/standby.ctl';
Database altered.
SQL> create pfile='/u01/initorcl.ora' from spfile;
File created.
将standby控制文件与参数文件拷贝一份到备库
[oracle@cffcdg1 orcl]$ cd /u01/
[oracle@cffcdg1 u01]$ scp initorcl.ora oracle@172.17.10.23:/u01
[oracle@cffcdg1 u01]$ scp standby.ctl oracle@172.17.10.23:/u01
修改主库参数文件
添加以下内容
[oracle@cffcdg1 u01]$ vi initorcl.ora
*.db_unique_name='primary'
*.archive_lag_target=1800
*.fal_client='standby'
*.fal_server='primary'
*.log_archive_config='DG_CONFIG=(primary,standby)'
*.log_archive_dest_1='LOCATION=/u01/oracle/oradata/archivelog VALID_FOR=(all_logfiles,all_roles) db_unique_name=primary'
*.log_archive_dest_2='SERVICE=standby lgwr sync VALID_FOR=(online_logfiles,primary_role) db_unique_name=standby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.dbf'
*.DB_FILE_NAME_CONVERT='/u01/oracle/oradata/orcl','/u01/oracle/oradata/orcl'
*.LOG_FILE_NAME_CONVERT='/u01/oracle/oradata/orcl','/u01/oracle/oradata/orcl'
*.standby_file_management='auto'
创建密码文件
[oracle@cffcdg1 u01]$ cd /u01/oracle/product/11.2.0/db_1/dbs/
[oracle@cffcdg1 dbs]$ mv orapworcl orapworclbak
[oracle@cffcdg1 dbs]$ orapwd file=orapworcl password=123456 entries=10
将密码文件复制到备库
[oracle@cffcdg1 dbs]$ scp orapworcl oracle@172.17.10.23:/u01/oracle/product/11.2.0/
db_1/dbs/
关闭数据库
[oracle@cffcdg1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 07:51:14 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
将主库/u01/oracle/目录下的admin、cfgtoollogs、diag、fast_recovery_area/orcl目录复制到备库相同目录下
[oracle@cffcdg1 dbs]$ cd /u01/oracle/
[oracle@cffcdg1 oracle]$ scp -r admin/ oracle@172.17.10.23:/u01/oracle/
[oracle@cffcdg1 oracle]$ scp -r cfgtoollogs/ oracle@172.17.10.23:/u01/oracle/
[oracle@cffcdg1 oracle]$ scp -r diag/ oracle@172.17.10.23:/u01/oracle/
[oracle@cffcdg1 oracle]$ scp -r fast_recovery_area/orcl/ oracle@172.17.10.23:/u01/oracle/
fast_recovery_area/
将主库/u01/oracle/oradata/目录下的orcl目录复制到备库相同目录下
[oracle@cffcdg1 oracle]$ cd /u01/oracle/oradata/
[oracle@cffcdg1 oradata]$ scp -r orcl/ oracle@172.17.10.23:/u01/oracle/oradata/
主库开启数据库及监听
[oracle@cffcdg1 oradata]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2022 07:57:05
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-JAN-2022 21:46:55
Uptime 0 days 10 hr. 10 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@cffcdg1 oradata]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 07:57:22 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile='/u01/initorcl.ora';
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 922747784 bytes
Database Buffers 3338665984 bytes
Redo Buffers 12107776 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='/u01/initorcl.ora';
File created.
在172.17.10.23备库配置
修改备库参数文件
添加以下内容
[oracle@cffcdg2 dbs]$ cd /u01/
[oracle@cffcdg2 u01]$ vi initorcl.ora
*.db_unique_name='standby'
*.archive_lag_target=1800
*.fal_client='primary'
*.fal_server='standby'
*.log_archive_config='DG_CONFIG=(primary,standby)'
*.log_archive_dest_1='LOCATION=/u01/oracle/oradata/archivelog VALID_FOR=(all_logfiles,all_roles) db_unique_name=standby'
*.log_archive_dest_2='SERVICE=primary lgwr sync VALID_FOR=(online_logfiles,primary_role) db_unique_name=primary'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_archive_format='%t_%s_%r.dbf'
*.DB_FILE_NAME_CONVERT='/u01/oracle/oradata/orcl','/u01/oracle/oradata/orcl'
*.LOG_FILE_NAME_CONVERT='/u01/oracle/oradata/orcl','/u01/oracle/oradata/orcl'
*.standby_file_management='auto'
修改备库控制文件
[oracle@cffcdg2 u01]$ cp standby.ctl /u01/oracle/oradata/orcl/
[oracle@cffcdg2 u01]$ cp standby.ctl /u01/oracle/fast_recovery_area/orcl/
[oracle@cffcdg2 u01]$ cd /u01/oracle/oradata/orcl/
[oracle@cffcdg2 orcl]$ mv control01.ctl control01bak.ctl
[oracle@cffcdg2 orcl]$ mv standby.ctl control01.ctl
[oracle@cffcdg2 orcl]$ cd /u01/oracle/fast_recovery_area/orcl/
[oracle@cffcdg2 orcl]$ mv control02.ctl control02bak.ctl
[oracle@cffcdg2 orcl]$ mv standby.ctl control02.ctl
创建归档目录
[oracle@cffcdg2 orcl]$ cd /u01/oracle/oradata/
[oracle@cffcdg2 oradata]$ mkdir /u01/oracle/oradata/archivelog
启动监听
[oracle@cffcdg2 oradata]$ lsnrctl start
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2022 08:06:32
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Starting /u01/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/oracle/diag/tnslsnr/cffcdg2/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg2)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 20-JAN-2022 08:06:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg2)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
启动数据库
[oracle@cffcdg2 oradata]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 08:06:41 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile='/u01/initorcl.ora';
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2260088 bytes
Variable Size 922747784 bytes
Database Buffers 3338665984 bytes
Redo Buffers 12107776 bytes
SQL> create spfile from pfile='/u01/app/initorcl.ora';
File created.
SQL> alter database mount standby database;
Database altered.
SQL> alter database open read only;
Database altered.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
SQL> select pid,process,status,sequence# from v$managed_standby;
PID PROCESS STATUS SEQUENCE#
---------- --------- ------------ ----------
11953 ARCH CONNECTED 0
11955 ARCH CONNECTED 0
11957 ARCH CONNECTED 0
11959 ARCH CLOSING 42
11991 RFS IDLE 0
11981 RFS IDLE 0
11987 RFS IDLE 43
11989 RFS IDLE 0
11993 MRP0 WAIT_FOR_LOG 43
9 rows selected.
SQL> set linesize 200
SQL> col dest_name for a30
SQL> select DEST_NAME,STATUS,RECOVERY_MODE from v$archive_dest_status;
DEST_NAME STATUS RECOVERY_MODE
------------------------------ --------- -----------------------
LOG_ARCHIVE_DEST_1 VALID MANAGED
LOG_ARCHIVE_DEST_2 VALID IDLE
LOG_ARCHIVE_DEST_3 INACTIVE IDLE
LOG_ARCHIVE_DEST_4 INACTIVE IDLE
LOG_ARCHIVE_DEST_5 INACTIVE IDLE
LOG_ARCHIVE_DEST_6 INACTIVE IDLE
LOG_ARCHIVE_DEST_7 INACTIVE IDLE
LOG_ARCHIVE_DEST_8 INACTIVE IDLE
LOG_ARCHIVE_DEST_9 INACTIVE IDLE
LOG_ARCHIVE_DEST_10 INACTIVE IDLE
LOG_ARCHIVE_DEST_11 INACTIVE IDLE
DEST_NAME STATUS RECOVERY_MODE
------------------------------ --------- -----------------------
LOG_ARCHIVE_DEST_12 INACTIVE IDLE
LOG_ARCHIVE_DEST_13 INACTIVE IDLE
LOG_ARCHIVE_DEST_14 INACTIVE IDLE
LOG_ARCHIVE_DEST_15 INACTIVE IDLE
LOG_ARCHIVE_DEST_16 INACTIVE IDLE
LOG_ARCHIVE_DEST_17 INACTIVE IDLE
LOG_ARCHIVE_DEST_18 INACTIVE IDLE
LOG_ARCHIVE_DEST_19 INACTIVE IDLE
LOG_ARCHIVE_DEST_20 INACTIVE IDLE
LOG_ARCHIVE_DEST_21 INACTIVE IDLE
LOG_ARCHIVE_DEST_22 INACTIVE IDLE
DEST_NAME STATUS RECOVERY_MODE
------------------------------ --------- -----------------------
LOG_ARCHIVE_DEST_23 INACTIVE IDLE
LOG_ARCHIVE_DEST_24 INACTIVE IDLE
LOG_ARCHIVE_DEST_25 INACTIVE IDLE
LOG_ARCHIVE_DEST_26 INACTIVE IDLE
LOG_ARCHIVE_DEST_27 INACTIVE IDLE
LOG_ARCHIVE_DEST_28 INACTIVE IDLE
LOG_ARCHIVE_DEST_29 INACTIVE IDLE
LOG_ARCHIVE_DEST_30 INACTIVE IDLE
LOG_ARCHIVE_DEST_31 INACTIVE IDLE
STANDBY_ARCHIVE_DEST VALID IDLE
32 rows selected.
主备库同步测试
主库查看归档
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/oradata/archivelog
Oldest online log sequence 39
Next log sequence to archive 43
Current log sequence 43
主库创建表m,插入100万条数据
SQL> create table m(i int,name varchar(10));
Table created.
SQL> begin
2 for i in 1 .. 1000000
3 loop
4 insert into m values(i,'boobooke');
5 end loop
6 ;
7 commit;
8 end;
9 /
PL/SQL procedure successfully completed.
多次切换redo日志
SQL> alter system switch logfile;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/oradata/archivelog
Oldest online log sequence 97
Next log sequence to archive 101
Current log sequence 101
SQL> select count(*) from m;
COUNT(*)
----------
1000000
备库查看同步情况
SQL> select pid,process,status,sequence# from v$managed_standby;
PID PROCESS STATUS SEQUENCE#
---------- --------- ------------ ----------
13221 ARCH CLOSING 101
13223 ARCH CONNECTED 0
13225 ARCH CONNECTED 0
13227 ARCH CLOSING 91
13240 MRP0 WAIT_FOR_LOG 102
13292 RFS IDLE 0
13286 RFS IDLE 0
13290 RFS IDLE 0
13288 RFS IDLE 102
9 rows selected.
SQL> select count(*) from m;
COUNT(*)
----------
1000000
主库再次插入大量数据
SQL> create table t(i int,name varchar(100));
Table created.
SQL> begin
2 for i in 1000000 .. 10000000
3 loop
4 insert into t values(i,'boobooke'||i);
5 end loop
6 ;
7 commit;
8 end;
9 /
PL/SQL procedure successfully completed.
SQL> select count(*) from t;
COUNT(*)
----------
9000001
多次切换redo日志
SQL> alter system switch logfile;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/oradata/archivelog
Oldest online log sequence 113
Next log sequence to archive 117
Current log sequence 117
备库查询数据同步情况
SQL> select pid,process,status,sequence# from v$managed_standby;
PID PROCESS STATUS SEQUENCE#
---------- --------- ------------ ----------
13221 ARCH CLOSING 116
13223 ARCH CLOSING 114
13225 ARCH CONNECTED 0
13227 ARCH CLOSING 115
13240 MRP0 WAIT_FOR_LOG 117
13292 RFS IDLE 0
13286 RFS IDLE 0
13290 RFS IDLE 0
13288 RFS IDLE 117
9 rows selected.
SQL> select count(*) from t;
COUNT(*)
----------
9000001
运行一段时间后
主库
[oracle@cffcdg1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2022 13:57:32
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 20-JAN-2022 09:29:39
Uptime 0 days 4 hr. 27 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg1)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "primary" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@cffcdg1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 13:57:38 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/oracle/oradata/archivelog
Oldest online log sequence 121
Next log sequence to archive 125
Current log sequence 125
SQL> exit
[oracle@cffcdg1 ~]$ cd /u01/oracle/oradata/archivelog/
[oracle@cffcdg1 archivelog]$ ll
total 2741640
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:30 1_100_1094416210.dbf
-rw-r-----. 1 oracle oinstall 26112 Jan 20 09:31 1_101_1094416210.dbf
-rw-r-----. 1 oracle oinstall 492839424 Jan 20 09:37 1_102_1094416210.dbf
-rw-r-----. 1 oracle oinstall 475978752 Jan 20 09:37 1_103_1094416210.dbf
-rw-r-----. 1 oracle oinstall 447607296 Jan 20 09:38 1_104_1094416210.dbf
-rw-r-----. 1 oracle oinstall 442979328 Jan 20 09:38 1_105_1094416210.dbf
-rw-r-----. 1 oracle oinstall 449125888 Jan 20 09:39 1_106_1094416210.dbf
-rw-r-----. 1 oracle oinstall 204488192 Jan 20 09:44 1_107_1094416210.dbf
-rw-r-----. 1 oracle oinstall 36352 Jan 20 09:44 1_108_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_109_1094416210.dbf
-rw-r-----. 1 oracle oinstall 235520 Jan 20 09:44 1_110_1094416210.dbf
-rw-r-----. 1 oracle oinstall 151552 Jan 20 09:44 1_111_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_112_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_113_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_114_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_115_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:44 1_116_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3198976 Jan 20 10:14 1_117_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1438720 Jan 20 10:44 1_118_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2852352 Jan 20 11:14 1_119_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1521664 Jan 20 11:44 1_120_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2931712 Jan 20 12:14 1_121_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1475072 Jan 20 12:44 1_122_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2783744 Jan 20 13:14 1_123_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1461248 Jan 20 13:44 1_124_1094416210.dbf
-rw-r-----. 1 oracle oinstall 484352 Jan 20 07:57 1_41_1094416210.dbf
-rw-r-----. 1 oracle oinstall 568832 Jan 20 08:02 1_42_1094416210.dbf
-rw-r-----. 1 oracle oinstall 269314048 Jan 20 08:17 1_43_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3072 Jan 20 08:17 1_44_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 08:17 1_45_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:17 1_46_1094416210.dbf
-rw-r-----. 1 oracle oinstall 4608 Jan 20 08:17 1_47_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:17 1_48_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:17 1_49_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:17 1_50_1094416210.dbf
-rw-r-----. 1 oracle oinstall 193536 Jan 20 08:19 1_51_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:19 1_52_1094416210.dbf
-rw-r-----. 1 oracle oinstall 63488 Jan 20 08:19 1_53_1094416210.dbf
-rw-r-----. 1 oracle oinstall 24576 Jan 20 08:20 1_54_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2048 Jan 20 08:20 1_55_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 08:20 1_56_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3584 Jan 20 08:20 1_57_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 08:20 1_58_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:20 1_59_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:20 1_60_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:20 1_61_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:20 1_62_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 08:20 1_63_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:20 1_64_1094416210.dbf
-rw-r-----. 1 oracle oinstall 482304 Jan 20 08:30 1_65_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1833472 Jan 20 09:00 1_66_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2027520 Jan 20 09:11 1_67_1094416210.dbf
-rw-r-----. 1 oracle oinstall 16896 Jan 20 09:12 1_68_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:12 1_69_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:12 1_70_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:12 1_71_1094416210.dbf
-rw-r-----. 1 oracle oinstall 24064 Jan 20 09:12 1_72_1094416210.dbf
-rw-r-----. 1 oracle oinstall 11776 Jan 20 09:13 1_73_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:13 1_74_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_75_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_76_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:13 1_77_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_78_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_79_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_80_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:13 1_81_1094416210.dbf
-rw-r-----. 1 oracle oinstall 206336 Jan 20 09:18 1_82_1094416210.dbf
-rw-r-----. 1 oracle oinstall 506368 Jan 20 09:27 1_83_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:27 1_84_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:27 1_85_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:27 1_86_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:27 1_87_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:27 1_88_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:27 1_89_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:27 1_90_1094416210.dbf
-rw-r-----. 1 oracle oinstall 43520 Jan 20 09:28 1_91_1094416210.dbf
-rw-r-----. 1 oracle oinstall 31232 Jan 20 09:29 1_92_1094416210.dbf
-rw-r-----. 1 oracle oinstall 184832 Jan 20 09:30 1_93_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:30 1_94_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:30 1_95_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:30 1_96_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3584 Jan 20 09:30 1_97_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:30 1_98_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:30 1_99_1094416210.dbf
备库
[oracle@cffcdg2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 20-JAN-2022 14:02:40
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 20-JAN-2022 09:34:46
Uptime 0 days 4 hr. 27 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/oracle/diag/tnslsnr/cffcdg2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cffcdg2)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "standby" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@cffcdg2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Jan 20 14:02:45 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select pid,process,status,sequence# from v$managed_standby;
PID PROCESS STATUS SEQUENCE#
---------- --------- ------------ ----------
13221 ARCH CLOSING 122
13223 ARCH CLOSING 123
13225 ARCH CONNECTED 0
13227 ARCH CLOSING 124
13240 MRP0 WAIT_FOR_LOG 125
13292 RFS IDLE 0
13286 RFS IDLE 0
13290 RFS IDLE 0
13288 RFS IDLE 125
9 rows selected.
SQL> exit
[oracle@cffcdg2 ~]$ cd /u01/oracle/oradata/archivelog/
[oracle@cffcdg2 archivelog]$ ll
total 2741636
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:35 1_100_1094416210.dbf
-rw-r-----. 1 oracle oinstall 26112 Jan 20 09:35 1_101_1094416210.dbf
-rw-r-----. 1 oracle oinstall 492839424 Jan 20 09:41 1_102_1094416210.dbf
-rw-r-----. 1 oracle oinstall 475978752 Jan 20 09:42 1_103_1094416210.dbf
-rw-r-----. 1 oracle oinstall 447607296 Jan 20 09:42 1_104_1094416210.dbf
-rw-r-----. 1 oracle oinstall 442979328 Jan 20 09:43 1_105_1094416210.dbf
-rw-r-----. 1 oracle oinstall 449125888 Jan 20 09:43 1_106_1094416210.dbf
-rw-r-----. 1 oracle oinstall 204488192 Jan 20 09:48 1_107_1094416210.dbf
-rw-r-----. 1 oracle oinstall 36352 Jan 20 09:48 1_108_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_109_1094416210.dbf
-rw-r-----. 1 oracle oinstall 235520 Jan 20 09:48 1_110_1094416210.dbf
-rw-r-----. 1 oracle oinstall 151552 Jan 20 09:48 1_111_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_112_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_113_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_114_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_115_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:48 1_116_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3198976 Jan 20 10:18 1_117_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1438720 Jan 20 10:48 1_118_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2852352 Jan 20 11:18 1_119_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1521664 Jan 20 11:48 1_120_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2931712 Jan 20 12:18 1_121_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1475072 Jan 20 12:48 1_122_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2783744 Jan 20 13:18 1_123_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1461248 Jan 20 13:48 1_124_1094416210.dbf
-rw-r-----. 1 oracle oinstall 484352 Jan 20 08:07 1_41_1094416210.dbf
-rw-r-----. 1 oracle oinstall 568832 Jan 20 08:07 1_42_1094416210.dbf
-rw-r-----. 1 oracle oinstall 269314048 Jan 20 08:21 1_43_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3072 Jan 20 08:21 1_44_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 08:21 1_45_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:21 1_46_1094416210.dbf
-rw-r-----. 1 oracle oinstall 4608 Jan 20 08:21 1_47_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:21 1_48_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:21 1_49_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:21 1_50_1094416210.dbf
-rw-r-----. 1 oracle oinstall 193536 Jan 20 08:23 1_51_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 08:24 1_52_1094416210.dbf
-rw-r-----. 1 oracle oinstall 63488 Jan 20 08:24 1_53_1094416210.dbf
-rw-r-----. 1 oracle oinstall 24576 Jan 20 09:16 1_54_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2048 Jan 20 09:16 1_55_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:16 1_56_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3584 Jan 20 09:16 1_57_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:16 1_58_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_59_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_60_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_61_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_62_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:16 1_63_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_64_1094416210.dbf
-rw-r-----. 1 oracle oinstall 482304 Jan 20 09:16 1_65_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1833472 Jan 20 09:16 1_66_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2027520 Jan 20 09:16 1_67_1094416210.dbf
-rw-r-----. 1 oracle oinstall 16896 Jan 20 09:16 1_68_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:16 1_69_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:16 1_70_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:16 1_71_1094416210.dbf
-rw-r-----. 1 oracle oinstall 24064 Jan 20 09:23 1_72_1094416210.dbf
-rw-r-----. 1 oracle oinstall 11776 Jan 20 09:23 1_73_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:23 1_74_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_75_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_76_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:23 1_77_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_78_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_79_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_80_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:23 1_81_1094416210.dbf
-rw-r-----. 1 oracle oinstall 206336 Jan 20 09:23 1_82_1094416210.dbf
-rw-r-----. 1 oracle oinstall 506368 Jan 20 09:32 1_83_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:32 1_84_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:32 1_85_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:32 1_86_1094416210.dbf
-rw-r-----. 1 oracle oinstall 2560 Jan 20 09:32 1_87_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:32 1_88_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:32 1_89_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:32 1_90_1094416210.dbf
-rw-r-----. 1 oracle oinstall 43520 Jan 20 09:35 1_91_1094416210.dbf
-rw-r-----. 1 oracle oinstall 31232 Jan 20 09:35 1_92_1094416210.dbf
-rw-r-----. 1 oracle oinstall 184832 Jan 20 09:35 1_93_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:35 1_94_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:35 1_95_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1536 Jan 20 09:35 1_96_1094416210.dbf
-rw-r-----. 1 oracle oinstall 3584 Jan 20 09:35 1_97_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:35 1_98_1094416210.dbf
-rw-r-----. 1 oracle oinstall 1024 Jan 20 09:35 1_99_1094416210.dbf