基于ORACLE 12.1.0.2 RAC搭建单机DG

原创 IT烧麦 2023-08-21

938

前言

上一篇写了ORACLE 12.1.0.2 RAC的安装配置，下面对这套RAC做一个单机DG
ORACLE 12.1.0.2 RAC安装部署

一、环境介绍

操作系统：ORACLE LINUX 6.8

IP地址分配

主机名称	IP地址
dg	192.168.10.60

二、环境准备

1、创建用户和组

创建组

groupadd -g 1001 oinstall
groupadd -g 1002 dba
groupadd -g 1003 oper
groupadd -g 1004 asmadmin
groupadd -g 1005 asmdba
groupadd -g 1006 asmoper

创建用户

useradd -u 501 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
useradd -u 502 -g oinstall -G dba,oper,asmdba oracle

配置密码

Changing password for user oracle.
passwd: all authentication tokens updated successfully.
[root@dg ~]# echo '123456'|passwd --stdin grid
Changing password for user grid.
passwd: all authentication tokens updated successfully.
[root@dg ~]#

2、配置环境变量

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=RACDBDG
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LC_ALL="en_US.UTF-8"
export LANG="en_US.UTF-8"
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

3、创建BASE目录

mkdir -p /u01/app/oraInventory
mkdir -p /u01/app/oracle

授权

chown -R oracle:oinstall /u01/app/

4、修改内核

cat >> /etc/sysctl.conf <<EOF
# For Oracle 12c RAC
#vm.nr_hugepages = 26000
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 8589934592
kernel.shmmax = 21474836480
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
EOF

sysctl -p

5、修改用户资源限制

cat >> /etc/security/limits.conf <<EOF
# For Oracle 12c
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
oracle soft memlock 475482060
oracle hard memlock 475482060
grid soft nproc 16384
grid hard nproc 16384
grid soft nofile 65536
grid hard nofile 65536
grid soft memlock 475482060
grid hard memlock 475482060
EOF

6、配置登陆验证模块

cat >> /etc/pam.d/login <<EOF
# For oracle 12c
session    required    pam_limits.so
EOF

7、安装依赖软件包

yum -y install binutils compat-libcap1 compat-libstdc++-33* gcc gcc-c++ glibc* glibc-devel* ksh libgcc* libstdc++* libstdc++-devel* libaio* libaio-devel-* make sysstat unixODBC-* unixODBC-devel-* elfutils-libelf-devel elfutils-libelf

三、安装oracle软件

1、解压 oracle软件

unzip V46095-01_1of2\ \(oracle-12.1.0.2\).zip
unzip V46095-01_2of2\ \(oracle-12.1.0.2\).zip

2、使用Oracle用户开始安装

su - oracle
cd /software/database
./runInstaller

开始安装

选择仅安装软件

选择安装模式

选择语言

版本选择

用户组选择

环境检查

开始安装

执行脚本

使用root用户执行脚本

/u01/app/oraInventory/orainstRoot.sh

 /u01/app/oracle/product/12.1.0/dbhome_1/root.sh

安装完成

四、主库配置

1、启用force logging

查询

SQL> select force_logging from v$database;

FORCE_LOGGING
---------------------------------------
NO

开启

SQL> alter database force logging;

Database altered.

2、创建Standby日志组

查看日志组和日志文件大小

SQL> select thread#,group#,bytes from v$log order by 1;

每个thread添加3组备用日志文件，日志文件大小与前面查询的日志文件大小一致

alter database add standby logfile thread 1 group 5 size 50M;
alter database add standby logfile thread 1 group 6 size 50M;
alter database add standby logfile thread 1 group 7 size 50M;
alter database add standby logfile thread 2 group 8 size 50M;
alter database add standby logfile thread 2 group 9 size 50M;
alter database add standby logfile thread 2 group 10 size 50M;

查看Standby log

select thread#,group#,bytes from v$standby_log order by 1;

3、配置LOG_ARCHIVE_CONFIG

RAC环境中，在任一主库节点执行。
dataguard开关

alter system set LOG_ARCHIVE_CONFIG='DG_CONFIG=(RACDB,RACDBDG)' scope=both sid='*';

alter system set log_archive_config='dg_config=(主库的唯一名,从库1的唯一名,从库2的唯一名...)';

4、配置归档参数

alter system set LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=RACDB' scope=BOTH sid='*';

alter system set log_archive_dest_1='location=目录或者（USE_DB_RECOVERY_FILE_DEST）  valid_for=(日志类型,数据库的角色)

日志类型：all_logfiles | online_logfiles | standby_logfiles
数据库的角色: all_roles | primary_role | standby_role

5、激活本地归档

alter system set log_archive_dest_state_1='enable' scope=BOTH sid='*';

默认是enable的

6、主库打开远程归档

alter system set LOG_ARCHIVE_DEST_2='SERVICE=RACDBDG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=RACDBDG'  scope=BOTH SID='*';

alter system set log_archive_dest_3='service=服务命名 valid_for=(日志类型,数据库的角色) db_unique_name=从库唯一名';

7、激活主库远程归档路径

alter system set log_archive_dest_state_2='enable';

默认是enable的

8、设置FAL参数

alter system set FAL_SERVER=RACDBDG scope=both sid='*';
alter system set fal_client=RACDB scope=both sid='*';

9、配置STANDBY_FILE_MANAGEMENT参数

alter system set STANDBY_FILE_MANAGEMENT=AUTO scope=both sid='*';

DB_FILE_NAME_CONVERT和LOG_FILE_NAME_CONVERT参数修改需要重启数据库生效、主库不修改也行。

alter system set DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/racdbdg','+OCRDG' scope=spfile sid='*';
alter system set LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/racdbdg','+OCRDG' scope=spfile sid='*';

配置tnsnames.ora

所有节点都添加

vi  /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
RACDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = dg)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDBDG)
    )
  )

五、备库配置

1、创建目录

su - oracle
mkdir -p /u01/app/oracle/admin/racdbdg/adump
mkdir -p /u01/app/oracle/oradata/racdbdg/
mkdir -p /u01/app/oracle/fast_recovery_dest/racdbdg/

2、配置监听

配置静态监听
在listener.ora添加如下内容

vi /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = RACDBDG)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1)
      (SID_NAME = RACDBDG)
    )
  )

加载配置

lsnrctl reload

配置tnsnames.ora

vi tnsnames.ora
RACDB1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDBDG)
    )
  )

RACDB2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDBDG)
    )
  )

RACDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.73)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.74)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.75)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = RACDB)
    )
  )

3、设置密码

su - oracle
cd $ORACLE_HOME/dbs
orapwd file=orapwRACDBDG password=123456 entries=10;

RMAN-05614: Passwords for target and auxiliary connections must be the same when using active duplicate
主库的密码和备库的密码必须一样所以一般都把主库的密码拿过来用

4、配置备库参数

在主库生成参数，传到备库，进行修改

SQL> create pfile='/home/oracle/rac.ora' from memory;

修改如下
把带2个节点信息的删除掉、其他的把路径修改一下，名称修改一下

5、备库使用pfile启动

[oracle@dg ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 17 17:07:43 2023

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/home/oracle/rac.ora';
ORACLE instance started.

Total System Global Area 2499805184 bytes
Fixed Size                  2927480 bytes
Variable Size             687867016 bytes
Database Buffers         1795162112 bytes
Redo Buffers               13848576 bytes
SQL>

六、开始创建备库

1、使用RMAN的连接主库和备库，分别输入主库和备库sys口令

rman target sys@RACDB1 auxiliary sys@RACDBDG

2、duplicate命令创建备库

duplicate target database for standby from active database dorecover nofilenamecheck;

执行过程

[oracle@dg dbs]$ rman target sys/oracle@RACDB1 auxiliary sys/oracle@RACDBDG

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 21 09:47:38 2023

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RACDB (DBID=1142565450)
connected to auxiliary database: RACDB (not mounted)

RMAN> duplicate target database for standby from active database dorecover nofilenamecheck;

Starting Duplicate Db at 21-AUG-23
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=243 device type=DISK
current log archived

contents of Memory Script:
{
   backup as copy reuse
   targetfile  '+OCRDG/RACDB/PASSWORD/pwdracdb.276.1144948653' auxiliary format
 '/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwRACDBDG'   ;
}
executing Memory Script

Starting backup at 21-AUG-23
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=130 instance=RACDB1 device type=DISK
Finished backup at 21-AUG-23

contents of Memory Script:
{
   restore clone from service  'RACDB1' standby controlfile;
}
executing Memory Script

Starting restore at 21-AUG-23
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:05
output file name=/u01/app/oracle/fast_recovery_dest/current.277.1144948683
output file name=/u01/app/oracle/oradata/current.278.1144948683
Finished restore at 21-AUG-23

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for clone tempfile  1 to new;
   set newname for clone tempfile  2 to new;
   set newname for clone tempfile  3 to new;
   switch clone tempfile all;
   set newname for clone datafile  1 to new;
   set newname for clone datafile  2 to new;
   set newname for clone datafile  3 to new;
   set newname for clone datafile  4 to new;
   set newname for clone datafile  5 to new;
   set newname for clone datafile  6 to new;
   set newname for clone datafile  7 to new;
   set newname for clone datafile  8 to new;
   set newname for clone datafile  9 to new;
   set newname for clone datafile  10 to new;
   restore
   from service  'RACDB1'   clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 2 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_temp_%u_.tmp in control file
renamed tempfile 3 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_temp_%u_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 21-AUG-23
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_undotbs1_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_undotbs2_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:56
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/RACDB/datafile/o1_mf_users_%u_.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02
Finished restore at 21-AUG-23

sql statement: alter system archive log current
current log archived

contents of Memory Script:
{
   restore clone force from service  'RACDB1'
           archivelog from scn  2418267;
   switch clone datafile all;
}
executing Memory Script

Starting restore at 21-AUG-23
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=185
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=186
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:16
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=187
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=21
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:16
channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: using network backup set from service RACDB1
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=2 sequence=22
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 21-AUG-23

datafile 1 switched to datafile copy
input datafile copy RECID=11 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_lg5jok3k_.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=12 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_lg5jpz09_.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=13 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_lg5jqh5t_.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=14 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_lg5jrlyj_.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=15 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_undotbs1_lg5jsf1k_.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=16 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_undotbs2_lg5jtv02_.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=17 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_users_lg5jv2v0_.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=18 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_system_lg5jv4q9_.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=19 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_sysaux_lg5jw8pj_.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=20 STAMP=1145440717 file name=/u01/app/oracle/oradata/RACDB/datafile/o1_mf_users_lg5jy0mv_.dbf

contents of Memory Script:
{
   set until scn  2419139;
   recover
   standby
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 21-AUG-23
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 186 is already on disk as file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch1_186_1144948682.dbf
archived log for thread 1 with sequence 187 is already on disk as file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch1_187_1144948682.dbf
archived log for thread 2 with sequence 21 is already on disk as file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch2_21_1144948682.dbf
archived log for thread 2 with sequence 22 is already on disk as file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch2_22_1144948682.dbf
archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch1_186_1144948682.dbf thread=1 sequence=186
archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch2_21_1144948682.dbf thread=2 sequence=21
archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch1_187_1144948682.dbf thread=1 sequence=187
archived log file name=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch2_22_1144948682.dbf thread=2 sequence=22
media recovery complete, elapsed time: 00:01:48
Finished recover at 21-AUG-23
Finished Duplicate Db at 21-AUG-23

RMAN>

duplicate操作完成后，备库已经启动到mount状态。

3、启动数据库并启动日志应用服务。

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

Database altered.
SQL> alter pluggable database pdb open read only;

Pluggable database altered.

SQL> alter database recover managed standby database using current logfile disconnect;

Database altered.

墨力计划 oracle dg

最后修改时间：2023-08-21 14:46:20

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者