RFS[18075]: No standby redo logfiles available for thread 1
来源:互联网 发布:xenomai编程笔记 编辑:程序博客网 时间:2024/04/30 20:35
rimary database is in MAXIMUM PERFORMANCE mode
RFS[18075]: Assigned to RFS process 27210
RFS[18075]: No standby redo logfiles available for thread 1
RFS[18075]: Opened log for thread 1 sequence 68369 dbid 809919918 branch 812303150
Thu Dec 12 09:32:32 2013
Archived Log entry 19674 added for thread 2 sequence 51723 rlc 812303150 ID 0x3045bbae dest 2:
Thu Dec 12 09:32:33 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_2_seq_51723.11845.833962885
Thu Dec 12 09:32:34 2013
Primary database is in MAXIMUM PERFORMANCE mode
Thu Dec 12 09:32:47 2013
RFS[18076]: Assigned to RFS process 27212
RFS[18076]: No standby redo logfiles available for thread 2
Thu Dec 12 09:32:47 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_1_seq_68367.11846.833964907
RFS[18076]: Opened log for thread 2 sequence 51724 dbid 809919918 branch 812303150
Thu Dec 12 09:33:30 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_1_seq_68368.11847.833966061
Thu Dec 12 09:33:58 2013
Media Recovery Waiting for thread 1 sequence 68369 (in transit)
Thu Dec 12 09:48:45 2013
1、FRIMARY SERVER:
在RAC PRIMARY 端,先关闭日志同步。
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=defer;
System altered.
2.暂停STANDBY
SQL> alter database recover managed standby database cancel;
3.修改模式:
SQL> alter system set standby_file_management=manual;
System altered.
删除归档,将所有的standby log组删除,然后再重建
SQL> alter database clear logfile group 5;
Database altered.
SQL> alter database drop logfile group 5;
Database altered.
。。。。。
增加standby 日志
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SIZE 50M;
。。。。。。
恢复到正常模式。
SQL> alter system set standby_file_management=auto;
System altered.
启动REDO实时应用日志(备库)
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT from session;
Database altered.
重启日志同步
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;
System altered.
RFS[18075]: Assigned to RFS process 27210
RFS[18075]: No standby redo logfiles available for thread 1
RFS[18075]: Opened log for thread 1 sequence 68369 dbid 809919918 branch 812303150
Thu Dec 12 09:32:32 2013
Archived Log entry 19674 added for thread 2 sequence 51723 rlc 812303150 ID 0x3045bbae dest 2:
Thu Dec 12 09:32:33 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_2_seq_51723.11845.833962885
Thu Dec 12 09:32:34 2013
Primary database is in MAXIMUM PERFORMANCE mode
Thu Dec 12 09:32:47 2013
RFS[18076]: Assigned to RFS process 27212
RFS[18076]: No standby redo logfiles available for thread 2
Thu Dec 12 09:32:47 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_1_seq_68367.11846.833964907
RFS[18076]: Opened log for thread 2 sequence 51724 dbid 809919918 branch 812303150
Thu Dec 12 09:33:30 2013
Media Recovery Log +RECOVERY/stbdb/archivelog/2013_12_12/thread_1_seq_68368.11847.833966061
Thu Dec 12 09:33:58 2013
Media Recovery Waiting for thread 1 sequence 68369 (in transit)
Thu Dec 12 09:48:45 2013
1、FRIMARY SERVER:
在RAC PRIMARY 端,先关闭日志同步。
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=defer;
System altered.
2.暂停STANDBY
SQL> alter database recover managed standby database cancel;
3.修改模式:
SQL> alter system set standby_file_management=manual;
System altered.
删除归档,将所有的standby log组删除,然后再重建
SQL> alter database clear logfile group 5;
Database altered.
SQL> alter database drop logfile group 5;
Database altered.
。。。。。
增加standby 日志
ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 SIZE 50M;
ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 SIZE 50M;
。。。。。。
恢复到正常模式。
SQL> alter system set standby_file_management=auto;
System altered.
启动REDO实时应用日志(备库)
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT from session;
Database altered.
重启日志同步
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=enable;
System altered.
0 0
- RFS[18075]: No standby redo logfiles available for thread 1
- 66. No EntityManager with actual transaction available for current thread
- 66. No EntityManager with actual transaction available for current thread
- No EntityManager with actual transaction available for current thread
- Springboot No EntityManager with actual transaction available for current thread
- Rfs[2]: no standby&nbs…
- ERROR OGG-00446 No valid log files for current redo sequence 20415, thread 1, error retrieving re
- Resize the Online Redo Logfiles
- 在线修改online redo logfiles size 大小
- Archived redo logfiles(归档重做日志)
- No TypeTag available for person
- 理解standby redo log
- 配置standby redo log
- Thread updates not available for selected client
- Frames not available for unsuspended thread
- 一步一步学DataGuard(20)Standby之Redo传输服务(1)
- SparkSQL: no typetag available for xxxx
- There are no packages available for installation
- 九度考研真题 浙大 2005-1浙大1013:开门人和关门人 排序
- Java加密技术(九)——单向认证
- squid for WIN + DNSPOD 搭建CDN服务器手记
- 数据结构_迷宫
- HTML+CSS面试技巧
- RFS[18075]: No standby redo logfiles available for thread 1
- eclipse安装ADT出错问题
- 九度考研真题 浙大 2005-2浙大1014:排名 多重排序
- 数据结构_括号匹配
- SimpleDateFormat并发问题解决方案
- VIII.1 INS-30510: Insufficient number of ASM disks selected.
- 九度考研真题 浙大 2005-3浙大1012:畅通工程
- 数据结构_数组
- java学习之浅谈多线程4--SwingWorker