备案控制台
探索云世界
开发者社区 数据库 文章 正文

oracle-排查dg环境文件不开Auto同步导致的错误

2022-07-26 89
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：

故障：

主库表空间添加文件，备库同步挂了。

排查

主库alert log:

ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move276.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:04:44 2022
Thread 1 cannot allocate new log, sequence 248280
Private strand flush not complete
  Current log# 4 seq# 248279 mem# 0: /oradata01/orcl/redo04.log
Thread 1 advanced to log sequence 248280 (LGWR switch)
  Current log# 1 seq# 248280 mem# 0: /oradata01/orcl/redo01.log
Tue Jul 26 12:04:48 2022
LNS: Standby redo logfile selected for thread 1 sequence 248280 for destination LOG_ARCHIVE_DEST_2
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move276.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move277.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:04:55 2022
Archived Log entry 316646 added for thread 1 sequence 248279 ID 0xfffffffff4ad5d16 dest 1:
Tue Jul 26 12:04:57 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move277.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move278.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move278.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move279.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:05:09 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move279.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move280.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move280.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:07:13 2022
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move281.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move281.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move282.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:07:24 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move282.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move283.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move283.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move284.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move284.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move285.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:07:38 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move285.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:09:58 2022
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move286.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move286.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move287.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move287.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move288.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:10:12 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move288.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move289.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move289.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move290.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:10:23 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move290.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:11:44 2022
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move291.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move291.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move292.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:11:54 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move292.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move293.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move293.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move294.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:12:05 2022
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move294.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move295.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Completed: ALTER TABLESPACE orcl_move ADD DATAFILE '/datalv4/db/oradata/orcl/orcl_move295.dbf' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE 30G
Tue Jul 26 12:13:35 2022

备库

alert log

Media Recovery Waiting for thread 1 sequence 248280 (in transit)
Recovery of Online Redo Log: Thread 1 Group 5 Seq 248280 Reading mem 0
  Mem# 0: /data01/redo_log/orcl/stdredo01.log
Tue Jul 26 12:04:58 2022
Archived Log entry 498722 added for thread 1 sequence 248279 ID 0xfffffffff4ad5d16 dest 1:
File #321 added to control file as 'UNNAMED00321' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /data01/u01/app/oracle/diag/rdbms/orclp/orcl/trace/orcl_pr00_10158200.trc:
ORA-01274: cannot add datafile '/datalv4/db/oradata/orcl/orcl_move276.dbf' - file could not be created
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 12258879621859
Tue Jul 26 12:05:02 2022
MRP0: Background Media Recovery process shutdown (orcl)
Tue Jul 26 12:13:48 2022

原来是STANDBY_FILE_MANAGEMENT设成了manual导致路径不对

查看数据文件，发现有个文件路径不对

SQL>  select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/data01/oradata01/orcl/orcl_move264.dbf
/data01/oradata01/orcl/orcl_move265.dbf
/data01/oradata01/orcl/orcl_move266.dbf
/data01/oradata01/orcl/orcl_move267.dbf
/data01/oradata01/orcl/orcl_move268.dbf
/data01/oradata01/orcl/orcl_move269.dbf
/data01/oradata01/orcl/orcl_move270.dbf
/data01/oradata01/orcl/orcl_move271.dbf
/data01/oradata01/orcl/orcl_move272.dbf
/data01/oradata01/orcl/orcl_move273.dbf
/data01/oradata01/orcl/orcl_move274.dbf

NAME
--------------------------------------------------------------------------------
/data01/oradata01/orcl/orcl_move275.dbf
/data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321

321 rows selected.

查看dg参数设置

SQL> show parameter conver;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      /oradata01/orcl/, /data01/
                                                 oradata01/orcl/, /datalv3/
                                                 db/oradata/orcl/, /data01/
                                                 oradata01/orcl/, /datalv4/
                                                 db/oradata/orcl/, /data01/
                                                 oradata01/orcl/
log_file_name_convert                string      /oradata01/orcl/, /data01/
                                                 redo_log/orcl/
SQL> 
/oradata01/orcl/, /data01/oradata01/orcl/, 
/datalv3/db/oradata/orcl/, /data01/oradata01/orcl/, 
/datalv4/db/oradata/orcl/, /data01/oradata01/orcl/

SQL> show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      MANUAL
SQL>

于是修改路径有问题的这个文件

alter database create datafile '/data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321' as '/data01/oradata01/orcl/orcl_move276.dbf';
alert log 
Tue Jul 26 12:39:05 2022
alter database create datafile '/data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321' as '/data01/oradata01/orcl/orcl_move276.dbf'
Completed: alter database create datafile '/data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321' as '/data01/oradata01/orcl/orcl_move276.dbf'
查看文件 
$ ls -ltr /data01/oradata01/orcl/orcl_move276.dbf
-rw-r-----    1 oracle   oinstall 1073750016 Jul 26 12:39 /data01/oradata01/orcl/orcl_move276.dbf
$ ls -ltr /data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321
ls: 0653-341 The file /data01/u01/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00321 does not exist.
$ 


select name from v$datafile ;
NAME
------------------------------------------------------------
/data01/oradata01/orcl/orcl_move272.dbf
/data01/oradata01/orcl/orcl_move273.dbf
/data01/oradata01/orcl/orcl_move274.dbf
/data01/oradata01/orcl/orcl_move275.dbf
/data01/oradata01/orcl/orcl_move276.dbf

269 rows selected.

SQL>

修改文件同步参数，开启同步

SQL> alter system set standby_file_management=auto scope=both;

System altered.

SQL> show parameter standby_file_management

NAME                                 TYPE       VALUE
------------------------------------ ---------- ------------------------------
standby_file_management              string     AUTO
SQL> 

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

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

SQL>

dg正常了，文件是同步过来了，但发现新问题：文件前都带了空格

select name from v$datafile ;
/data01/oradata01/orcl/orcl_move273.dbf
/data01/oradata01/orcl/orcl_move274.dbf
/data01/oradata01/orcl/orcl_move275.dbf
/data01/oradata01/orcl/orcl_move276.dbf
/data01/oradata01/orcl/ orcl_move277.dbf
/data01/oradata01/orcl/ orcl_move278.dbf
/data01/oradata01/orcl/ orcl_move279.dbf
/data01/oradata01/orcl/ orcl_move280.dbf
/data01/oradata01/orcl/ orcl_move281.dbf
/data01/oradata01/orcl/ orcl_move282.dbf
/data01/oradata01/orcl/ orcl_move283.dbf
/data01/oradata01/orcl/ orcl_move284.dbf
/data01/oradata01/orcl/ orcl_move285.dbf
/data01/oradata01/orcl/ orcl_move286.dbf
/data01/oradata01/orcl/ orcl_move287.dbf
/data01/oradata01/orcl/ orcl_move288.dbf
/data01/oradata01/orcl/ orcl_move289.dbf
/data01/oradata01/orcl/ orcl_move290.dbf
/data01/oradata01/orcl/ orcl_move291.dbf
/data01/oradata01/orcl/ orcl_move292.dbf
/data01/oradata01/orcl/ orcl_move293.dbf
/data01/oradata01/orcl/ orcl_move294.dbf
/data01/oradata01/orcl/ orcl_move295.dbf
应该是db_file_name_convert配置有问题，但show parameter db_file_name_convert看不出有空格，于是生成pfile查看,果然是有空间 
db_file_name_convert='/oradata01/orcl/','/data01/oradata01/orcl/','/datalv3/db/oradata/orcl/','/data01/oradata01/orcl/','/datalv4/db/oradata/orcl/','/data01/oradata01/orcl/ '

于是，修改文件路径。。。

先把同步停了，文件同步参数改成manual

alter database recover managed standby database cancel;
 alter system set standby_file_management=MANUAL scope=both;
 
 SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY

SQL>  show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      MANUAL
SQL>

修改db_file_name_convert参数，需要重启生效。

SQL> alter system  set db_file_name_convert='/oradata01/orcl/','/data01/oradata01/orcl/','/datalv3/db/oradata/orcl/','/data01/oradata01/orcl/','/datalv4/db/oradata/orcl/','/data01/oradata01/orcl/' scope=spfile;
System altered.

rename数据文件也需要重启到mount状态才行，于是重启数据库。

SQL> startup mount force;
ORACLE instance started.

Total System Global Area 1.4965E+11 bytes
Fixed Size                  2254176 bytes
Variable Size            2.2549E+10 bytes
Database Buffers         1.2670E+11 bytes
Redo Buffers              400384000 bytes
Database mounted.
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

rename 数据文件

alter database rename file '/data01/oradata01/orcl/ orcl_move277.dbf' to '/data01/oradata01/orcl/orcl_move277.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move278.dbf' to '/data01/oradata01/orcl/orcl_move278.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move279.dbf' to '/data01/oradata01/orcl/orcl_move279.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move280.dbf' to '/data01/oradata01/orcl/orcl_move280.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move281.dbf' to '/data01/oradata01/orcl/orcl_move281.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move282.dbf' to '/data01/oradata01/orcl/orcl_move282.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move283.dbf' to '/data01/oradata01/orcl/orcl_move283.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move284.dbf' to '/data01/oradata01/orcl/orcl_move284.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move285.dbf' to '/data01/oradata01/orcl/orcl_move285.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move286.dbf' to '/data01/oradata01/orcl/orcl_move286.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move287.dbf' to '/data01/oradata01/orcl/orcl_move287.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move288.dbf' to '/data01/oradata01/orcl/orcl_move288.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move289.dbf' to '/data01/oradata01/orcl/orcl_move289.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move290.dbf' to '/data01/oradata01/orcl/orcl_move290.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move291.dbf' to '/data01/oradata01/orcl/orcl_move291.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move292.dbf' to '/data01/oradata01/orcl/orcl_move292.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move293.dbf' to '/data01/oradata01/orcl/orcl_move293.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move294.dbf' to '/data01/oradata01/orcl/orcl_move294.dbf';
alter database rename file '/data01/oradata01/orcl/ orcl_move295.dbf' to '/data01/oradata01/orcl/orcl_move295.dbf';

查看Rename成功

select name from v$datafile;

/data01/oradata01/orcl/orcl_move277.dbf
/data01/oradata01/orcl/orcl_move278.dbf
/data01/oradata01/orcl/orcl_move279.dbf
/data01/oradata01/orcl/orcl_move280.dbf
/data01/oradata01/orcl/orcl_move281.dbf
/data01/oradata01/orcl/orcl_move282.dbf
/data01/oradata01/orcl/orcl_move283.dbf
/data01/oradata01/orcl/orcl_move284.dbf
/data01/oradata01/orcl/orcl_move285.dbf

NAME
--------------------------------------------------------------------------------
/data01/oradata01/orcl/orcl_move286.dbf
/data01/oradata01/orcl/orcl_move287.dbf
/data01/oradata01/orcl/orcl_move288.dbf
/data01/oradata01/orcl/orcl_move289.dbf
/data01/oradata01/orcl/orcl_move290.dbf
/data01/oradata01/orcl/orcl_move291.dbf
/data01/oradata01/orcl/orcl_move292.dbf
/data01/oradata01/orcl/orcl_move293.dbf
/data01/oradata01/orcl/orcl_move294.dbf
/data01/oradata01/orcl/orcl_move295.dbf

到os数据文件所在目录下，mv一下带空格的数据文件

mv " orcl_move277.dbf"  "orcl_move277.dbf"
mv " orcl_move278.dbf"  "orcl_move278.dbf"
mv " orcl_move279.dbf"  "orcl_move279.dbf"
mv " orcl_move280.dbf"  "orcl_move280.dbf"
mv " orcl_move281.dbf"  "orcl_move281.dbf"
mv " orcl_move282.dbf"  "orcl_move282.dbf"
mv " orcl_move283.dbf"  "orcl_move283.dbf"
mv " orcl_move284.dbf"  "orcl_move284.dbf"
mv " orcl_move285.dbf"  "orcl_move285.dbf"
mv " orcl_move286.dbf"  "orcl_move286.dbf"
mv " orcl_move287.dbf"  "orcl_move287.dbf"
mv " orcl_move288.dbf"  "orcl_move288.dbf"
mv " orcl_move289.dbf"  "orcl_move289.dbf"
mv " orcl_move290.dbf"  "orcl_move290.dbf"
mv " orcl_move291.dbf"  "orcl_move291.dbf"
mv " orcl_move292.dbf"  "orcl_move292.dbf"
mv " orcl_move293.dbf"  "orcl_move293.dbf"
mv " orcl_move294.dbf"  "orcl_move294.dbf"
mv " orcl_move295.dbf"  "orcl_move295.dbf"

修改文件同步参数，启动数据库到readonly，打开实时同步

SQL> alter system set standby_file_management=auto scope=both;

System altered.

SQL> show parameter standby_file_management

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_file_management              string      AUTO
SQL> alter database open;

Database altered.

SQL> select open_mode from v$database; 

OPEN_MODE
--------------------
READ ONLY

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

Database altered.

SQL> select open_mode from v$database; 

OPEN_MODE
--------------------
READ ONLY WITH APPLY

SQL>

检查同步是否正常

主库查，no gap 
SQL> set line 300
SQL> col DB_UNIQUE_NAME for a20
SQL> col DEST_NAME for a20
col DESTINATION for a20
col DATABASE_MODE for a20
col recovery_mode for a25
col destination for a25
col gap_status for a10
SQL> SQL> SQL> SQL> SQL> SQL> col type for a10
SQL> col status for a10
select dest_id,dest_name,status,type,database_mode,recovery_mode,destination,db_unique_name,gap_status from v$archive_dest_status where status='VALID';
SQL> 
   DEST_ID DEST_NAME            STATUS     TYPE       DATABASE_MODE        RECOVERY_MODE             DESTINATION               DB_UNIQUE_NAME       GAP_STATUS
---------- -------------------- ---------- ---------- -------------------- ------------------------- ------------------------- -------------------- ----------
         1 LOG_ARCHIVE_DEST_1   VALID      LOCAL      OPEN                 IDLE                      /arch01/orcl/         NONE
         2 LOG_ARCHIVE_DEST_2   VALID      PHYSICAL   OPEN_READ-ONLY       MANAGED REAL TIME APPLY   orclp                 orclp            NO GAP

SQL> 
SQL> select thread#, sequence# from v$thread;

   THREAD#  SEQUENCE#
---------- ----------
         1     248290

SQL>
备库： 
SQL> select process, status, thread#, sequence# from v$managed_standby where process='MRP0';

PROCESS   STATUS          THREAD#  SEQUENCE#
--------- ------------ ---------- ----------
MRP0      APPLYING_LOG          1     248290

SQL>
文章标签：
数据库备份
数据库
关键词：
Oracle数据库一键上云同步
Oracle数据库一键上云排查
Oracle数据库一键上云文件
Oracle数据库一键上云环境
Oracle数据库一键上云文件同步
lemotree
目录
相关文章
_长银_
|
2月前
|
存储 Oracle NoSQL
Oracle 表空间、数据文件、schema的关系
Oracle 表空间、数据文件、schema的关系
_长银_
32 2
穆雄雄.
|
30天前
|
XML Java 数据库连接
struts+hibernate+oracle+easyui实现lazyout组件的简单案例——hibernate的config文件（hibernate.cfg.xml）
struts+hibernate+oracle+easyui实现lazyout组件的简单案例——hibernate的config文件（hibernate.cfg.xml）
穆雄雄.
10 0
小周sir
|
4月前
|
分布式计算 Oracle 关系型数据库
oracle自动同步maxcomputejava.lang.NullPointerException
oracle自动同步maxcomputejava.lang.NullPointerException
小周sir
37 1
瓴羊Dataphin
|
29天前
|
监控 Oracle 关系型数据库
Dataphin实时集成Oracle CDC相关问题排查
本文档提供了Dataphin平台Oracle CDC实时集成相关问题排查指南，覆盖了权限等常见问题，旨在帮助快速定位和解决Oracle数据库变更数据捕获（CDC）集成过程中所可能遇到的技术难题，确保数据的实时、准确同步。
瓴羊Dataphin
44 1
三分钟热度的鱼
|
2月前
|
Oracle 关系型数据库 Apache
Flink cdc报错问题之同步oracle报错如何解决
Flink CDC报错指的是使用Apache Flink的Change Data Capture（CDC）组件时遇到的错误和异常；本合集将汇总Flink CDC常见的报错情况，并提供相应的诊断和解决方法，帮助用户快速恢复数据处理任务的正常运行。
三分钟热度的鱼
97 0
疯狂的猿
|
3月前
|
SQL 存储 Oracle
oracle如何定期备份数据库sql文件
【1月更文挑战第7天】oracle如何定期备份数据库sql文件
疯狂的猿
58 8
飞翔的佩奇
|
3月前
|
SQL Oracle 关系型数据库
Linux环境下oracle切换用户并查询数据库命令
Linux环境下oracle切换用户并查询数据库命令
飞翔的佩奇
49 0
小周sir
|
4月前
|
SQL Oracle 关系型数据库
用flink sql同步数据到oracle吗？
用flink sql同步数据到oracle吗？
小周sir
70 0
vohelon
|
4月前
|
Oracle 关系型数据库 数据库
这个问题可能是由于Flink在尝试获取Oracle的预览数据时，没有找到启动标志文件
这个问题可能是由于Flink在尝试获取Oracle的预览数据时，没有找到启动标志文件
vohelon
43 1
Star时光
|
4月前
|
Oracle 关系型数据库 Java
oracle自动同步maxcomputejava.lang.NullPointerException
oracle自动同步maxcomputejava.lang.NullPointerException
Star时光
22 0

热门文章

最新文章

  • 1
    Oracle 面试题及答案整理，最新面试题
  • 2
    Seata常见问题之oracle 数据库 报 just support mysql如何解决
  • 3
    PolarDB常见问题之PolarDB(Oracle兼容版) 执行命令报错如何解决
  • 4
    Dataphin实时集成Oracle CDC相关问题排查
  • 5
    【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
  • 6
    【Oracle】玩转Oracle数据库（二）：体系结构、存储结构与各类参数
  • 7
    【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
  • 8
    struts+hibernate+oracle+easyui实现lazyout组件的简单案例——Emp实体类和对应的配置信息
  • 9
    oracle基本笔记整理及案例分析1
  • 10
    struts+hibernate+oracle+easyui实现lazyout组件的简单案例——EmpDao层代码
  • 1
    服务器Centos7 静默安装Oracle Database 12.2
    71
  • 2
    SpringBoot整合Mybatis连接Oracle数据库
    52
  • 3
    避坑，Oracle中rownum与order by的执行顺序
    25
  • 4
    避坑，Oracle中left join 与 (+) 的区别
    19
  • 5
    Oracle临时表详解
    17
  • 6
    Oracle insert数据时字符串中有‘单引号问题
    25
  • 7
    【Bug记录】Oracle中小数点前面的0不显示的问题
    37
  • 8
    Oracle中merge Into的用法
    17
  • 9
    Flink CDC产品常见问题之使用cdc-Oracle连接器报错如何解决
    48
  • 10
    Oracle系列十八：Oracle RAC
    47

    • 相关电子书

    更多
  • PostgresChina2018_樊文凯_ORACLE数据库和应用异构迁移最佳实践
  • PostgresChina2018_王帅_从Oracle到PostgreSQL的数据迁移
  • Oracle云上最佳实践

    • 相关实验场景

    更多
  • PolarDB的Online DDL功能验证实验

    • 推荐镜像

    更多
  • oracle
  • arch4edu
  • debian-archive
    • 下一篇
    阿里云oss简介和使用流程