Oracle 12C 搭建 RAC dg 单机
步骤概要
一：备库安装数据库软件
二：配置DG
1.主库需要开启归档模式
2.主库force logging
3.主库创建 standby redo log文件
4.修改RAC参数，并生成pfile与密码文件一起传输到备库
5.备库创建监听
6.配置 tnsnames.ora
7.备库创建目录
8.备库修改pfile并启动到nomount
9. 备库进行duplicate
10.启动备库并应用MRP
11.dg数据保护模式切换（可选）
12.验证同步
备库信息：
DG备库（单实例）
Hostname： orcldg
IP ：192.168.1.36
Instance_name: orcldg
DB_name: orcl
Version:12.2.0.1
此处搭建的是Physical Standby，生成当中多数都是Physical Standby
一：备库安装数据库软件
安装配置过程省略
PS：只安装软件不创建数据库
1.设置oracle用户环境变量
vi .bash_profile
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcldg; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
2.修改主机名及hosts文件
[root@ORCLRDG ~]# hostname orclrdg #临时修改
[root@ORCLRDG ~]#vi /etc/sysconfig/network #永久修改
hostname=orclrdg
[root@ORCLRDG ~]#vi /etc/hosts
192.168.1.16 orclrdg1
192.168.1.11 orcl1
192.168.1.12 orcl2
192.168.1.13 orcl1-vip
192.168.1.14 orcl2-vip
192.168.1.15 orcl-scan
10.0.0.11 orcl1-priv
10.0.0.12 orcl2-priv
二：配置DG
1.主库需要归档模式
RAC归档目录的设置及开启/关闭
SQL>alter diskgroup ARH add directory '+ARCH/orcl';
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+ARCH/orcl' SCOPE=SPFILE SID='1';
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+ARCH/orcl' SCOPE=SPFILE SID='2';
关闭RACDB资源
[grid@orcl1 ~]$ srvctl stop database -d orcl -o immediate
SQL>startup mount;
SQL>alter database archivelog;(开启)/ alter database noarchivelog;(关闭)
SQL>alter database open;
SYS@orcl1>archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +ARCH/orcl
Oldest online log sequence 1771
Next log sequence to archive 1772
Current log sequence 1772
手动切换归档
SQL> alter system switch logfile;
SYS@orcl1>show parameter db_recover
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 5727M
需要时可以扩大下UNDO表空间，以避免快照过旧
SQL> alter tablespace UNDOTBS1 add datafile '+DATA/ORCL/DATAFILE/undotbs02.dbf' size 32000M;
SQL> alter tablespace UNDOTBS1 add datafile '+DATA/ORCL/DATAFILE/undotbs03.dbf' size 32000M;
SQL> alter tablespace UNDOTBS1 add datafile '+DATA/ORCL/DATAFILE/undotbs04.dbf' size 32000M;
完成后可以缩小数据文件，避免空间浪费
SQL>alter database datafile '+DATA/ORCL/DATAFILE/undotbs02.dbf' resize 100M;
SQL>alter database datafile '+DATA/ORCL/DATAFILE/undotbs03.dbf' resize 100M;
SQL>alter database datafile '+DATA/ORCL/DATAFILE/undotbs04.dbf' resize 100M;
2. 主库force logging
SQL>alter database force logging;
Database altered.
SQL>select FORCE_LOGGING from v$database;
FORCE_
------
YES
3.主库创建 standby redo log文件
RAC上多节点，多redo thread 。
创建规则：每个 thread 都需要创建，standby redo log 比 redo log 多一组,大小相同
查看当前redo log：
SQL>select a.thread#,a.group#,a.bytes/1024/1024,b.member from v$log a,v$logfile b where a.group#=b.group#;
THREAD# GROUP# A.BYTES/1024/1024 MEMBER
---------- ---------- ----------------- ---------------------------------------------------------------------------------------------------
1 1 500 +DATA/orcl/onlinelog/group1_1
1 1 500 +FRA/orcl /onlinelog/group1_2
1 2 500 +DATA/orcl /onlinelog/group2_1
1 2 500 +FRA/orcl /onlinelog/group2_2
2 3 500 +DATA/orcl/onlinelog/group3_1
2 3 500 +FRA/orcl/onlinelog/group3_2
2 4 500 +DATA/orcl/onlinelog/group4_1
2 4 500 +FRA/orcl/onlinelog/group4_2
8 rows selected.
添加standby redo （我这里位置全部选择 +DATA）
SQL> alter database add standby logfile thread 1 group 5 ('+DATA/ORCL/ONLINELOG/group5_1') size 1024m;
Database altered.
SQL> alter database add standby logfile thread 1 group 6 ('+DATA/ORCL/ONLINELOG/group6_1') size 1024m;
Database altered.
SQL> alter database add standby logfile thread 1 group 7 ('+DATA/ORCL/ONLINELOG/group7_1') size 1024m;
Database altered.
SQL> alter database add standby logfile thread 2 group 8 ('+DATA/ORCL/ONLINELOG/group8_1') size 1024m;
Database altered.
SQL> alter database add standby logfile thread 2 group 9 ('+DATA/ORCL/ONLINELOG/group9_1') size 1024m;
Database altered.
SQL> alter database add standby logfile thread 2 group 10 ('+DATA/ORCL/ONLINELOG/group10_1') size 1024m;
Database altered.
SQL>select group#,type,member from v$logfile order by 2;
GROUP# TYPE MEMBER
---------- -------------- ---------------------------------------------------------------------------------------------------
1 ONLINE +DATA/orcl/onlinelog/group1_1
1 ONLINE +FRA/orcl /onlinelog/group1_2
2 ONLINE +DATA/orcl /onlinelog/group2_1
2 ONLINE +FRA/orcl /onlinelog/group2_2
3 ONLINE +DATA/orcl/onlinelog/group3_1
3 ONLINE +FRA/orcl/onlinelog/group3_2
4 ONLINE +DATA/orcl/onlinelog/group4_1
4 ONLINE +FRA/orcl/onlinelog/group4_2
5 STANDBY +DATA/orcl/onlinelog/group5_1
6 STANDBY +DATA/orcl/onlinelog/group6_1
7 STANDBY +DATA/orcl/onlinelog/group7_1
8 STANDBY +DATA/orcl/onlinelog/group8_1
9 STANDBY +DATA/orcl/onlinelog/group9_1
10 STANDBY +DATA/orcl/onlinelog/group10_1
14 rows selected.
4.修改RAC参数，并生成pfile与密码文件一起传输到备库
SQL>alter system set log_archive_config='DG_CONFIG=(orcl,orcldg)' scope=spfile sid='*';
System altered.
SQL>alter system set log_archive_dest_1='location=+arch/orcl valid_for=(all_logfiles,all_roles) db_unique_name=orcl' scope=spfile sid='*';
System altered.
SQL>alter system set log_archive_dest_2='service=orcldg LGWR ASYNC NOAFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=orcldg' scope=spfile sid='*';
System altered.
SQL> alter system set standby_file_management=auto scope=both sid='*';
System altered.
SYS@orcl1>alter system set db_file_name_convert='+DATA/ORCL/DATAFILE','/oradata/orcldg','+DATA/ORCL/TEMPFILE','/oradata/orcldg' scope=spfile sid='*';
System altered.
SYS@orcl1> alter system set log_file_name_convert='+DATA/ORCL/ONLINELOG','/oradata/orcldg' scope=spfile sid='*';
System altered.
SYS@orcl1> alter system set fal_client='orcl' scope=both sid='*';
System altered.
SYS@orcl1> alter system set fal_server='orcldg' scope=both sid='*';
System altered.
SYS@orcl1> alter system set dg_broker_start=true scope=both sid='*';
System altered.
重启rac
[grid@orcl1 ~]$ srvctl stop database -d orcl -o immediate
[grid@orcl1 ~]$ srvctl start database -d orcl -o open
创建pfile及传到备库
SYS@orcl1>create pfile='/home/oracle/orcldg.ora' from spfile;
File created.
[oracle@ orcl1 ~]$ scp -r orcldg.ora 192.168.1.16:/home/oracle/orcldg.ora
[root@orcl1 ~]#su – grid
[grid@orcl1 ~]$asmcmd
ASMCMD>cp +data/orcl/PASSWORD/pwdorcl.256.102343445 /tmp/orapwd
[oracle@orcl1 ~]$ scp -r /tmp/orapwd 10.2.3.36:/tmp/orapwd
[oracle@orclrdg ~]$ cp /tmp/orapwd $ORACLE_HOME/dbs/orapworcldg
5.备库创建监听
[oracle@ORCLRDG ~]$ cat $ORACLE_HOME /network/admin/listener.ora
# listener.ora Network Configuration File: $ORACLE_HOME/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORCLDG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = orclrdg)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcldg)
(ORACLE_HOME = /app/oracle/product/12.2.0/db_1)
(SID_NAME = orcldg)
)
)
ADR_BASE_LISTENER = /app/oracle
[oracle@orclrdg ~]$ lsnrctl start
6.配置 tnsnames.ora
所有rac节点 和 DG备库都需要配置,添加内容一样(都是$ORACLE_HOME/network/admin目录下)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.15)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
ORCLDG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.16)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcldg)
)
)
7.备库创建目录
[oracle@orclrdg ~]$ mkdir -pv /oradata/orcldg/
[oracle@orclrdg ~]$ mkdir -pv /app/oracle/admin/orcl/adump
[oracle@orclrdg ~]$ mkdir -pv /arch
8.备库修改pfile并启动到nomount
ps:注意oracle 环境变量指定的SID
修改后的pfile内容
[oracle@orclrdg dbs]$ cat initorcldg.ora
*.audit_file_dest='/app/oracle/admin/orcl/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='/oradata/orcldg/control01.ctl','/oradata/orcldg/control02.ctl'
*.db_create_file_dest='/oradata/orcldg'
*.db_block_size=8192
*.db_domain=''
*.db_file_name_convert='+DATA/ORCL/DATAFILE','/oradata/orcldg','+DATA/ORCL/TEMPFILE','/oradata/orcldg'
*.db_name='orcl'
#*.db_recovery_file_dest_size=6005194752
*.dg_broker_start=TRUE
*.diagnostic_dest='/app/oracle' #$ORACLE_BASE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.fal_client='orcldg'
*.fal_server='orcl'
family:dw_helper.instance_mode='read-only'
*.log_archive_config='DG_CONFIG=(orcl,orcldg)'
*.log_archive_dest_1='location=/arh valid_for=(all_logfiles,all_roles) db_unique_name=orcldg' *.log_archive_dest_2='service=orcl LGWR ASYNC NOAFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=orcldg' *.log_archive_format='%t_%s_%r.dbf'
*.log_file_name_convert='+DATA/ORCL/ONLINELOG','/oradata/orcldg'
*.open_cursors=30000
*.pga_aggregate_target=16211m
*.processes=10000
*.remote_login_passwordfile='exclusive'
*.sga_target=18630m
*.standby_file_management='AUTO'
*.db_unique_name='orcldg'
*.service_names='orcldg'
*.undo_tablespace='UNDOTBS1'
9.修改备库bash_profile文件
ORACLE_BASE= /app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcldg; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
10.创建spfile 启动到nomount
[oracle@orcldg dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1 Production on Fri Jun 8 16:50:50 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2253784 bytes
Variable Size 469765160 bytes
Database Buffers 1174405120 bytes
Redo Buffers 7094272 bytes
9. 备库进行duplicate
[oracle@orclrdg dbs]$ rman target sys/oracle@orcl auxiliary sys/oracle@orcldg
Recovery Manager: Release12.2.0.1 - Production on Fri Jun 8 16:56:03 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: orcl (DBID=3094661074)
connected to auxiliary database: orcl (not mounted)
RMAN> duplicate target database for standby from active database nofilenamecheck;
Starting Duplicate Db at 2019:07:08 16:56:04
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=10 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwbrac2' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwbracdg' ;
}
executing Memory Script
Starting backup at 2018:06:08 16:56:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=158 instance=brac2 device type=DISK
Finished backup at 2018:06:08 16:56:16
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/bracdg/control01.ctl';
restore clone controlfile to '/u01/app/oracle/fast_recovery_area/bracdg/control02.ctl' from
'/u01/app/oracle/oradata/bracdg/control01.ctl';
}
executing Memory Script
Starting backup at 2018:06:08 16:56:16
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_brac2.f tag=TAG20180608T165615 RECID=1 STAMP=978281776
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2018:06:08 16:56:18
Starting restore at 2018:06:08 16:56:18
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 2018:06:08 16:56:19
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 tempfile 1 to
"/oradata/orcldg/temp.262.977014053";
switch clone tempfile all;
set newname for datafile 1 to
"/oradata/orcldg/system.259.977014041";
set newname for datafile 2 to
"/oradata/orcldg/sysaux.260.977014047";
set newname for datafile 3 to
"/oradata/orcldg/undotbs1.261.977014051";
set newname for datafile 4 to
"/oradata/orcldg/undotbs2.263.977014059";
set newname for datafile 5 to
"/oradata/orcldg/users.264.977014059";
backup as copy reuse
datafile 1 auxiliary format
"/oradata/orcldg/system.259.977014041" datafile
2 auxiliary format
"/oradata/orcldg/sysaux.260.977014047" datafile
3 auxiliary format
"/oradata/orcldg/undotbs1.261.977014051" datafile
4 auxiliary format
"/oradata/orcldg/undotbs2.263.977014059" datafile
5 auxiliary format
"/oradata/orcldg/users.264.977014059" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /oradata/orcldg/temp.262.977014053 in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 2019:07:08 16:56:15
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.261.977014051
output file name=/oradata/orcldg/undotbs1.261.977014051 tag=TAG20180608T165624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/orcl/datafile/system.259.977014041
output file name=/oradata/orcldg/system.259.977014041 tag=TAG20180608T165624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.260.977014047
output file name=/oradata/orcldg/sysaux.260.977014047 tag=TAG20180608T165624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=+DATA/orcl/datafile/undotbs2.263.977014059
output file name=/oradata/orcldg/undotbs2.263.977014059 tag=TAG20180608T165624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=+DATA/orcl/datafile/users.264.977014059
output file name=/oradata/orcldg/users.264.977014059 tag=TAG20180608T165624
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 2019:07:08 16:57:18
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=978281851 file name=/oradata/orcldg/system.259.977014041
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=978281851 file name=/oradata/orcldg/sysaux.260.977014047
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=978281851 file name=/oradata/orcldg/undotbs1.261.977014051
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=978281851 file name=/oradata/orcldg/undotbs2.263.977014059
datafile 5 switched to datafile copy
input datafile copy RECID=5 STAMP=978281851 file name=/oradata/orcldg/users.264.977014059
Finished Duplicate Db at 2018:06:08 16:57:35
Orcldg 自动起到mount
RMAN>
10.启动备库并应用MRP
SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;
DBID NAME OPEN_MODE DATABASE_ROLE
---------- ------------------ ---------------------------------------- --------------------------------
3094661074 ORCL MOUNTED PHYSICAL STANDBY
SQL> alter database open read only;
Database altered.
SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;
DBID NAME OPEN_MODE DATABASE_ROLE
---------- ------------------ ---------------------------------------- --------------------------------
3094661074 ORCL READ ONLY PHYSICAL STANDBY
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL> select DBID,NAME,OPEN_MODE,DATABASE_ROLE from v$database;
DBID NAME OPEN_MODE DATABASE_ROLE
---------- ------------------ ---------------------------------------- --------------------------------
3094661074 ORCL READ ONLY WITH APPLY PHYSICAL STANDBY
12.数据保护模式切换至最高可用模式（Maximum Availability）默认最高性能（Maximum Performance）
（1） 查看数据库当前保护模式：最高性能模式
select database_role,protection_mode,protection_level from
v$database;
主库 Primary :
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
物理备库 Physical Standby
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
（2）主库修改主库日志传输模式
alter system set log_archive_dest_2='service=orcldg LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role) db_unique_name=orcldg' scope=spfile sid='*';
（3）主库切换数据保护模式为最高可用
alter database set standby database to maximize availability;
查看当前主、备库数据保护模式，已经是最高可用模式。
select database_role,protection_mode,protection_level from v$database;
DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
---------------- -------------------- --------------------
PHYSICAL STANDBY MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
11.验证同步
SYS@orcl1>create table test1 as select * from dba_objects;
Table created.
SYS@orcl2>create table dg_test2 as select * from dba_objects;
Table created.
SYS@orcl2>create tablespace test_tablespace datafile '+DATA' size 100m;
Tablespace created.
SYS@orcl2>select TABLESPACE_NAME,FILE_NAME from dba_data_files where tablespace_name='DG_TEST_TABLESPACE';
TABLESPACE_NAME FILE_NAME
-------------------- ---------------------------------------------------------------------------------------------------
DG_TEST_TABLESPACE +DATA/orcl/datafile/test_tablespace.268.978282989
备库查看
SQL> show parameter db_unique
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_unique_name string orcldg
SQL> select count(*) from test1;
COUNT(*)
----------
86297
SQL> select count(*) from test2;
COUNT(*)
----------
86298
SQL> select TABLESPACE_NAME,FILE_NAME from dba_data_files where tablespace_name='DG_TEST_TABLESPACE';
TABLESPACE_NAME FILE_NAME
---------------------------------------- ---------------------------------------------------------------------------------------------------
DG_TEST_TABLESPACE /oradata/orcldg/test_tablespace.268.978282989
查看未应用的日志
select sequence#,applied,first_time,next_time from v$archived_log;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
3976 YES 05-JUN-19 05-JUN-19
3975 YES 05-JUN-19 05-JUN-19
7574 YES 05-JUN-19 05-JUN-19
7575 YES 05-JUN-19 05-JUN-19
3977 YES 05-JUN-19 05-JUN-19
3978 YES 05-JUN-19 05-JUN-19
7576 YES 05-JUN-19 05-JUN-19
7577 YES 05-JUN-19 05-JUN-19
7578 YES 05-JUN-19 05-JUN-19
3979 IN-MEMORY 05-JUN-19 05-JUN-19
查看SCN号
select current_scn from v$database;
SQL> select dbms_flashback.get_system_change_number from dual;
GET_SYSTEM_CHANGE_NUMBER
------------------------
170357596
查询数据文件头SCN，在控制文件中、数据文件头
SQL> select name,checkpoint_change# from v$datafile_header;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------------------------------------------------
/oradata/orcldg/system.287.1005026849 170280943
日志中所含SCN范围
select GROUP#,sequence#,STATUS,FIRST_CHANGE#,to_char(FIRST_TIME,'yyyy/mm/dd:hh24:mi:ss') firsttime,NEXT_CHANGE#,to_char(NEXT_TIME,'yyyy/mm/dd:hh24:mi:ss') nexttime from v$log;
GROUP# SEQUENCE# STATUS FIRST_CHANGE# FIRSTTIME NEXT_CHANGE# NEXTTIME
------------ ------------------- ------------------------------------------------------------------------------------------------
1 0 UNUSED 97302350 2019/11/22:01:00:09 97463038 2019/11/22:14:42:52
2 0 UNUSED 97463038 2019/11/22:14:42:52 1.8447E+19
3 0 UNUSED 97302299 2019/11/22:01:00:07 97463167 2019/11/22:14:42:57
4 0 UNUSED 97463167 2019/11/22:14:42:57 1.8447E+19
浙公网安备 33010602011771号