http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [70]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [200]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [18]
MySQL [41]
DB2 [79]
ORACLE [2953]
PSQL [132]
기타정보 [155]
운영체제 [591]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: ORACLE

 회원가입

Error 12541 received logging on to the standby
최길호 [LIST]   2023-05-20 16:39:36, 조회 : 5


*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(TNG,arch)'
*.LOG_ARCHIVE_DEST_2='SERVICE=arch OPTIONAL ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) REOPEN=10 TEMPLATE=/backup/arch/tng.%t_%s_%r.arc DB_UNIQUE_NAME=arch'

standby 서버 부팅

Sat May 20 13:43:54 KST 2023
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
Error 12541 received logging on to the standby
Check whether the listener is up and running.
ARC0: Error 12541 attaching to RFS for reconnect
PING[ARC0]: Error 3113 when pinging standby arch.
Sat May 20 13:44:54 KST 2023
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Sat May 20 13:44:54 KST 2023
Errors in file /oracle/product/10.2/admin/TNG/bdump/tng_arc0_17715.trc:
ORA-12541: TNS:no listener
PING[ARC0]: Heartbeat failed to connect to standby 'arch'. Error is 12541.
Sat May 20 13:45:54 KST 2023
Error 12541 received logging on to the standby
Check whether the listener is up and running.
Sat May 20 13:47:50 KST 2023
Errors in file /oracle/product/10.2/admin/TNG/bdump/tng_arc0_17715.trc:
ORA-12541: TNS:no listener
FAL[server, ARC0]: Error 12541 creating remote archivelog file 'arch'
FAL[server, ARC0]: FAL archive failed, see trace file.
Sat May 20 13:47:50 KST 2023
Errors in file /oracle/product/10.2/admin/TNG/bdump/tng_arc0_17715.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sat May 20 13:47:50 KST 2023
ORACLE Instance TNG - Archival Error. Archiver continuing.
Sat May 20 13:58:25 KST 2023
Errors in file /oracle/product/10.2/admin/TNG/bdump/tng_arc0_17715.trc:
ORA-12560: TNS:protocol adapter error
PING[ARC0]: Heartbeat failed to connect to standby 'arch'. Error is 12560.
Sat May 20 13:59:28 KST 2023
Error 12560 received logging on to the standby
Sat May 20 14:02:05 KST 2023
Using STANDBY_ARCHIVE_DEST parameter default value as /backup/arch/
Sat May 20 14:02:05 KST 2023
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=MEMORY;


완료후
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY;

Sun May 21 00:46:22 KST 2023
Thread 1 advanced to log sequence 135926 (LGWR switch)
  Current log# 5 seq# 135926 mem# 0: /TNG/oradata/redo05.log
  Current log# 5 seq# 135926 mem# 1: /backup/oradata/redo15.log
Sun May 21 00:46:38 KST 2023
Using STANDBY_ARCHIVE_DEST parameter default value as /backup/arch/
Sun May 21 00:46:38 KST 2023
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=MEMORY;
Sun May 21 00:51:22 KST 2023
Thread 1 advanced to log sequence 135927 (LGWR switch)
  Current log# 2 seq# 135927 mem# 0: /TNG/oradata/redo02.log
  Current log# 2 seq# 135927 mem# 1: /backup/oradata/redo12.log


STANDBY log
Sun May 21 00:47:25 KST 2023
Using STANDBY_ARCHIVE_DEST parameter default value as /backup/arch/
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 30867
RFS[1]: Identified database type as 'repository'
RFS[1]: Identified database type as 'repository'
Sun May 21 00:47:25 KST 2023
RFS LogMiner: Client enabled and ready for notification
Sun May 21 00:47:26 KST 2023
RFS LogMiner: RFS id [30867] assigned as thread [1] PING handler
Sun May 21 00:51:22 KST 2023
RFS[1]: Archived Log: '/backup/arch/tng.1_135926_947188237.arc'
Sun May 21 00:56:23 KST 2023
RFS[1]: Archived Log: '/backup/arch/tng.1_135927_947188237.arc'

들어온 파일
-rw-r----- 1 oracle dba 7690240 May 20 13:42 tng.1_135800_947188237.arc
-rw-r----- 1 oracle dba 2986496 May 21 00:51 tng.1_135926_947188237.arc
-rw-r----- 1 oracle dba 1244160 May 21 00:56 tng.1_135927_947188237.arc
3.235.40.122


  LIST

제목 작성자 작성일 조회
Admin  [ 공지 ] 😃 서비스 시간 08:00 ~ 23:00 / 안되면 나중에 다시 방문 해주세요~.😅    최길호 2008/11/26 113
Admin  [ 필요 하신게 있으시면 쪽지 또는 gilho.kr@gmail.com 메일 주세요~ ]    최길호 2006/07/14 134
Install and Config  ORA-19504: failed to create file "+DATA" ORA-17502: ksfdcre:4 Failed to create file +DATA ORA-28040: No matching authentication protocol    최길호 2023/06/01 0
Troubleshoot  SEVERE: Inventory does not exist.    최길호 2023/05/31 1
Troubleshoot  ora.LISTENER.lsnr status: INTERMEDIATE / Not All Endpoints Registered,STABLE    최길호 2023/05/28 5
Admin  [INS-30515] Insufficient space available in the selected disks. 12.2 MGMT 제외 설치    최길호 2023/05/25 2
Admin  Error 12541 received logging on to the standby    최길호 2023/05/20 5
Admin  SQL 기초 교육 [ pdf ppt ]     최길호 2023/05/11 14
Admin  java delete [ java archvie log delete source ] 파일 개수 유지 [ ORACLE SQL> 실행 ] PLS-00311: the declaration of    최길호 2023/04/17 14
Install and Config  create user MDSYS / INSERT INTO MDSYS.CS_SRS 지리정보체계(GIS) 공간정보 /    최길호 2023/04/05 19
Admin  ORA-00279 ORA-279 signalled during: alter database recover if needed    최길호 2023/04/04 18
Admin  Java (1.7) could not be located. OPatch cannot proceed! / OPatch returns with error code = 1    최길호 2023/03/14 9
Admin  EXP-00111: Table CREATE$JAVA$LOB$TABLE resides in an Encrypted Tablespace / ORA-39189: unable to decrypt dump file set    최길호 2023/03/10 9
Admin  ORA-02292 ORA-02298    최길호 2023/02/28 16

    목록보기   다음페이지 1 [2][3][4][5][6][7][8][9][10]..[148]   [다음 10개]
       

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
2021/06/30
윈도우 서버에서 sqlplus .... ORA-...
by 최길호
2021/06/30
ORA-28500: connection from O...
by 최길호
2019/05/02
pkg 확인 SELECT * FROM AL...
by 최길호
최근 게시물
06/01
[ORACLE]
ORA-19504: failed to create fi....
by 최길호
05/31
[ORACLE]
SEVERE: Inventory does not exi....
by 최길호
04/26
[운영체제]
콜 매니저 [ 공부,운동,집중,취침등 전화 오면....
by 최길호