在DG備庫備份資料庫並恢復到一個主機上,報錯RMAN-06820

lhrbest發表於2020-07-27

在DG備庫備份資料庫並恢復到一個主機上,報錯RMAN-06820


12C dataguard備庫備份archivelog出現報錯

 

Problem Description

---------------------------------------------------

SQL> select * from product_component_version ;

 

PRODUCT                                  VERSION    STATUS

---------------------------------------- ---------- ----------------------------------------

NLSRTL                                   12.1.0.2.0 Production

Oracle Database 12c Enterprise Edition   12.1.0.2.0 64bit Production

PL/SQL                                   12.1.0.2.0 Production

TNS for  Linux:                           12.1.0.2.0 Production

 

備庫的狀態

SQL> select OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE from v$database;

 

OPEN_MODE            PROTECTION_MODE      DATABASE_ROLE

-------------------- -------------------- ----------------

READ ONLY WITH APPLY MAXIMUM PERFORMANCE  PHYSICAL STANDBY

 

SQL> select THREAD# ,SEQUENCE#,APPLIED from  v$archived_log where APPLIED='NO' ;

 

no rows selected

 

在standby(備庫)備份archivelog時會報RMAN-06820,ORA-17629,ORA-17627的錯,但是最後歸檔還是備份成功了。

 

[oracle@localhost ~]$rman target /

 

RMAN> backup archivelog all;

 

Starting backup at 02-OCT-15

using target database control file instead of recovery catalog

RMAN-06820: WARNING: failed to archive current log at primary database

ORACLE error from target database:  

ORA-17629: Cannot connect to the remote database server

ORA-17627: ORA-00942: table or view does not exist

 

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1156 device type=DISK

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

input archived log thread=2 sequence=132 RECID=135 STAMP=891367439

input archived log thread=1 sequence=172 RECID=134 STAMP=891367438

......

piece handle=/opt/oracle/oradata/MXCNSTB/backupset/2015_10_02/o1_mf_annnn_TAG20151002T144942_c0wbbdw1_.bkp tag=TAG20151002T144942 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

Finished backup at 02-OCT-15

 

 

解決方法:

在備庫上以sys使用者登入

rman target sys/password

 

可以參考以下文件:

RMAN-06820 ORA-17629 ORA-17627 ORA-01034 ORA-27101 During Backup of a Standby Database ( Doc ID 2042148.1  )

RMAN-06820 ORA-17629 During Backup at Standby Site ( Doc ID 1616074.1  )

RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database ( Doc ID 2025142.1  )



     Dataguard Standby備份報錯RMAN-06820 ORA-17629解決



Oracle Dataguard 是官方重要HA 架構的組成部分。通過只讀的Standby 資料庫,可以在確保高可用的基礎上,將一部分報表、備份負載從主庫上分離出來,提高主庫效能。

根據Oracle 最佳實踐,主庫Primary 是可以不進行直接的備份,核心備份操作可以放在Standby 端進行操作,這樣不僅可以節省備份資源,還可以有效的將備份的效能消耗轉移到Standby 端進行。

本文記錄了筆者在Physical Standby 端進行RMAN 備份的時候,遇到錯誤資訊的問題解決。記錄下來,留待需要的朋友待查。

 

1 、環境說明

 

筆者使用Oracle 11gR2 進行測試,具體版本為11.2.0.4 Data Guard Primary Standby 採用的版本完全相同。

 

 

SQL> select * from v$version;

 

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE     11.2.0.4.0     Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 – Production

 

 

Standby 端,是採用Active Data Guard 只讀應用狀態。

 

 

SQL> select open_mode, database_role from v$database;

 

OPEN_MODE            DATABASE_ROLE

-------------------- ----------------

READ ONLY WITH APPLY PHYSICAL STANDBY

 

 

2 、問題故障

 

standby 端,使用RMAN 進行備份動作。進行全庫備份和歸檔日誌備份,備份之後嘗試刪除掉已經備份的日誌檔案。

 

 

[oracle@vLIFE-URE-OT-DB-STANDBY trace]$ rman nocatalog

 

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 18 13:44:54 2015

 

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

 

RMAN>  connect target /

 

connected to target database: VLIFE (DBID=4207470439)

using target database control file instead of recovery catalog

 

 

進行RMAN 備份。

 

 

 

RMAN> backup database plus archivelog delete input;

 

 

Starting backup at 18-OCT-15

RMAN-06820: WARNING: failed to archive current log at primary database

ORACLE error from target database:

ORA-17629: Cannot connect to the remote database server

ORA-17627: ORA-00942: table or view does not exist

 

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=204 device type=DISK

specification does not match any archived log in the repository

backup cancelled because there are no files to backup

Finished backup at 18-OCT-15

 

Starting backup at 18-OCT-15

(篇幅原因,有省略 ……

handle=/u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893423697_c26dj5nb_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 18-OCT-15

 

 

在備份過程中出現錯誤,錯誤提示上好像是要訪問Primary 端資料庫,之後由於許可權問題沒有能夠訪問。其他備份動作看似正常,備份集合顯示正確。

 

 

RMAN> list backup;

 

 

List of Backup Sets

===================

 

 

BS Key  Size       Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

6       27.46M     DISK        00:00:00     18-OCT-15     

        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20151018T133946

        Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/backupset/2015_10_18/o1_mf_annnn_TAG20151018T133946_c26d52kd_.bkp

 

  List of Archived Logs in backup set 6

  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time

  ---- ------- ---------- --------- ---------- ---------

  1    22      1290925    18-OCT-15 1298642    18-OCT-15

  1    23      1298642    18-OCT-15 1298901    18-OCT-15

  1    24      1298901    18-OCT-15 1299107    18-OCT-15

  1    25      1299107    18-OCT-15 1299528    18-OCT-15

  1    26      1299528    18-OCT-15 1301585    18-OCT-15

  1    27      1301585    18-OCT-15 1301853    18-OCT-15

  1    28      1301853    18-OCT-15 1302226    18-OCT-15

  1    29      1302226    18-OCT-15 1303310    18-OCT-15

  1    30      1303310    18-OCT-15 1303858    18-OCT-15

  1    31      1303858    18-OCT-15 1308314    18-OCT-15

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

11      Full    1.11G      DISK        00:00:08     18-OCT-15     

        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20151018T134526

        Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/backupset/2015_10_18/o1_mf_nnndf_TAG20151018T134526_c26dhpdf_.bkp

  List of Datafiles in backup set 11

  File LV Type Ckp SCN    Ckp Time  Name

  ---- -- ---- ---------- --------- ----

  1       Full 1308778    18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_system_c2613wz5_.dbf

  2       Full 1308778    18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_sysaux_c2613x03_.dbf

  3       Full 1308778    18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_undotbs1_c2613x07_.dbf

  4       Full 1308778    18-OCT-15 /u01/app/oracle/oradata/VLIFESB/datafile/o1_mf_users_c2613x0d_.dbf

 

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

12      Full    9.36M      DISK        00:00:00     18-OCT-15     

        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20151018T134541

        Piece Name: /u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893423697_c26dj5nb_.bkp

  SPFILE Included: Modification time: 18-OCT-15

  SPFILE db_unique_name: VLIFESB

  Standby Control File Included: Ckp SCN: 1310511      Ckp time: 18-OCT-15

 

 

3 、問題分析解決

 

這個問題很不合理,看似應該是Oracle Bug 之類的情況。查詢MOS ,發現了對應的Bug 資訊:RMAN-06820 ORA-17629 During Backup at Standby Site ( 文件 ID 1616074.1)

根據文章資訊,該問題Oracle 一個未釋出的bug ,編號為Bug 8740124 。當Oracle 嘗試訪問主庫過程中,需要連帶將全部的standby log 獲取到。當連線失敗的時候,就會發生報錯。

要解決該問題,Oracle 提供了一個變通的辦法,就是不要使用target / 匿名方式登入,而是使用sysdba 使用者的使用者名稱和密碼資訊進行直接連線。

實驗如下:

 

 

[oracle@vLIFE-URE-OT-DB-STANDBY trace]$ rman nocatalog

 

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Oct 18 13:49:56 2015

 

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

 

RMAN>  connect target sys/oracle@vlifesb

 

connected to target database: VLIFE (DBID=4207470439)

using target database control file instead of recovery catalog

 

RMAN> backup database plus archivelog delete input;

 

Starting backup at 18-OCT-15

current log archived at primary database

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=204 device type=DISK

channel ORA_DISK_1: starting archived log backup set

channel ORA_DISK_1: specifying archived log(s) in backup set

(篇幅原因,有省略 ……

handle=/u01/app/oracle/fast_recovery_area/VLIFESB/autobackup/2015_10_18/o1_mf_s_893425827_c26dssbt_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 18-OCT-15

 

 

沒有出現報錯資訊,問題解決。

 

4 、結論

 

筆者思考一下,這個變通策略還是利用了主庫和備庫在sysdba 使用者的密碼相同這個策略。在備份的時候,將顯示記錄的sysdba 使用者密碼輸入進去,用於進行遠端Primary 登入和獲取。




RMAN-06820 ORA-17629 During Backup at Standby Site (Doc ID 1616074.1) To Bottom To Bottom




In this Document

Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

SYMPTOMS

RMAN archivelog backup at the standby site is throws the following errors at the start of the job:


Starting backup at 15-JAN-2014 13:44:46
RMAN-06820: WARNING: failed to archive current log at primary database
ORACLE error from target database:
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01017: invalid username/password; logon denied 
ORA-17629: Cannot connect to the remote database server

 

But the rest of the backup actually complete successfully:

 

skipping archived log of thread 1 with sequence 607; already backed up
skipping archived log of thread 1 with sequence 614; already backed up
channel t1: starting archived log backup set
channel t1: specifying archived log(s) in backup set
input archived log thread=1 sequence=678 RECID=290 STAMP=836919086
input archived log thread=1 sequence=679 RECID=291 STAMP=836919369
input archived log thread=1 sequence=680 RECID=292 STAMP=836919706
input archived log thread=1 sequence=681 RECID=293 STAMP=836919873
channel t1: starting piece 1 at 15-JAN-2014 13:44:52
channel t1: finished piece 1 at 15-JAN-2014 13:46:17
piece handle=LOG_THMDB_20140115_171228_1_1 tag=LOG_TWMDB comment=API Version 2.0,MMS Version 5.4.1.0
channel t1: backup set complete, elapsed time: 00:01:25
Finished backup at 15-JAN-2014 13:46:17

 

 

CHANGES

 Database was upgraded to 11.2.0.4

CAUSE

Change in 11.2.0.4 onward

Per 'unpublished' Bug 8740124, as of 11.2.0.4, we now include the current standby redo log as part of an RMAN archivelog backup at the standby site. This is achieved by forcing a log switch at the primary site.

However, the connection to the primary failed when attempting to do so.


This is due to this bug:
Bug 17580082 - ACTIVE STANDBY - RMAN-06820: WARNING: FAILED TO ARCHIVE CURRENT LOG AT PRIMARY
Status: 32 - Not a Bug. To Filer


 

SOLUTION

Workaround

Do not use operating system authentication to login with RMAN. Use a username and password.

That is, do not use just the "/" (operating system authentication) connect to the standby database:

$ rman target /

Connecting as 'rman target /' 

# it gets the sys user but not the password and so, it does NOT mean it is being explicitly 
# specified to connect as sysdba.

Instead put in the username and password for the SYSDBA user:

$ rman target sys/password@stby

Connecting as 'rman target sysdba_user/password@stby'

Note:  The password, within the password file, for the primary and standby should be identical.  


# This is an explicit connection as sysdba

 

Note from Bug: 17580082

As for having ability to connect from standby to primary, there are few options 
.
(Option 1) is to connect as SYSDBA, like: 'rman target sysdba_user/password@stby'
 (Option 2) is to setup wallets using which authentication can be done (more details can be obtained from SECURITY team here), 
 (Option 3) use CONNECT command inside the command file supplied to RMAN. For example: RMAN> connect target sysdba_user/password@stby
.

 Currently only SYSDBA  is allowed to connect for switch or resync operation.

Enhancement Request/Bug 18070699 allows for the use of other user/password apart from sys password to connect to remote database for RMAN operation.

  Bug 18070699:  ALLOW NON-SYS USERNAME GRANTED SYSDBA TO RESYNC DB_UNIQUE_NAME ALL

Patches are available for this issue by searching bug 21476308 for patch name or number.  

 

REFERENCES


BUG:17580082 - ACTIVE STANDBY - RMAN-6820: WARNING: FAILED TO ARCHIVE CURRENT LOG AT PRIMARY
NOTE:8740124.8 - Bug 8740124 - Current standby redo log group should be included in the database backup by RMAN
NOTE:1301769.1 - ORA-17629 : RMAN Resync Catalog from db_unique_name all fails
RMAN-06820 ORA-17629 ORA-12154 During Backup of a Standby Database (Doc ID 2025142.1) To Bottom To Bottom

In this Document

Symptoms
Changes
Cause
Solution
References


APPLIES TO:

Enterprise Manager for Oracle Database - Version 11.2.0.4 and later
Information in this document applies to any platform.

SYMPTOMS

While taking the backup from standby db, the below error is returned:
 

RMAN> connect target sys/passwd@tns_standby

RMAN-06009: using target database control file instead of recovery catalogRMAN-08030: allocated channel: ch1

RMAN-08500: channel ch1: SID=70 device type=SBT_TAPE
RMAN-08526: channel ch1: CommVault Systems for Oracle: Version 9.0.0(BUILD84)


RMAN-03090: Starting backup at 25-JUN-15
RMAN-06820: WARNING: failed to archive current log at primary database
RMAN-06003: ORACLE error from target database: 
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

CHANGES

Sqlnet configuration has been modified. For example, entries in the tnsnames.ora file were removed in the standby server.  

CAUSE

Sqlnet configuration modifications preventing RMAN from connecting to the primary database to switch online logs.  This is new functionality in 11.2.0.4 and beyond.   

In this example, a removal of TNS entry in the standby used by RMAN is missing.

SOLUTION

1. Generate RMAN trace as below:

$ rman target sys/passwd@tns_standby debug trace=/tmp/rmanDebug_new.trc log=/tmp/rmanLog_new.txt

RMA
N> Run the backup script

The debug output will show something like:
 

Rman trace file:

============

DBGMISC: EXITED krmkgconf [09:51:57.558] elapsed time [00:00:00:00.016]
DBGMISC: remote_resync=0, for_dbuname=chlbbkof2; source_cs=; dest_cs=null [09:51:57.558] (krmkgetconnids)

DBGSQL: TARGET> begin :lprimary_db_cs := sys.dbms_backup_restore.get_connect_identifier (dbuname=> :primary_dbuname); end; 
DBGSQL: sqlcode = 0
DBGSQL: B :lprimary_db_cs = <service name 2>
DBGSQL: B :primary_dbuname = 
  DBGRCVMAN: getConfig: configurations exists for this site
DBGSQL: ENTERED krmkosqlerr

DBGSQL: TARGET> declare null_retVal varchar2(1); begin null_retVal := sys.dbms_backup_restore.remoteSQLExecute( source_dbuname=> :primary_dbuname, source_cs => :lprimary_db_cs, stmt => 'alter system archive log current'); end; 
DBGSQL: sqlcode = 17629
DBGSQL: B :primary_dbuname = chlbbkof2
DBGSQL: B :lprimary_db_cs = <service_name2> =============================> RMAN is using the service name "<service_name2>" to connect to the primary database to perform the log switch.
DBGSQL: error: ORA-17629: Cannot connect to the remote database server (krmkosqlerr)
DBGSQL: ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified (krmkosqlerr)
DBGSQL: ORA-17629: Cannot connect to the remote database server (krmkosqlerr)
DBGSQL: ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 7812 (krmkosqlerr)
DBGSQL: ORA-06512: at line 1 (krmkosqlerr)
DBGSQL: (krmkosqlerr)
DBGSQL: EXITED krmkosqlerr
RMAN-06820: WARNING: failed to archive current log at primary database
DBGMISC: ENTERED krmkursr [09:56:05.681]

 

2. Search for the string " lprimary_db_cs" in the trace file:

DBGSQL:             B :lprimary_db_cs = <service_name2>

 

3. Add the corresponding entry in the tnsnames.ora file of standby database which should be able to ping to primary as below:

service_name2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = chbkofdb2.primary_host.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME =service_name2)
    )
  )

4.  If entry exists, test the connection.  From standby server, execute:

$  sqlplus 'sys/password@<service name found in #2> as sysdba' 

 

NOTE: Below procedure describes how RMAN determines the primary database connect string identifier to perform primary log switch when archive backup is started on standby.

1. First, it checks primary's DB_UNIQUE_NAME with below query:

SQL> select PRIMARY_DB_UNIQUE_NAME from V$DATABASE;

PRIMARY_DB_UNIQUE_NAME
------------------------------
PRIMARY

2. Then, it checks RMAN configuration to see if any CONNECT IDENTIFIER is defined for that particular DB_UNIQUE_NAME:

RMAN> show all;

RMAN configuration parameters for database with db_unique_name STANDBY1 are:
...
CONFIGURE DB_UNIQUE_NAME 'PRIMARY' CONNECT IDENTIFIER 'TestConnection';
... 

In this example, since CONNECT IDENTIFIER is defined for DB_UNIQUE_NAME 'PRIMARY', RMAN will use the same i.e. 'TestConnection'

3. If, CONNECT IDENTIFIER is NOT defined in RMAN configuration for this particular DB_UNIQUE_NAME, RMAN will next check if any remote log archive destination is configured for this DB_UNIQUE_NAME:

SQL> select DEST_ID,DESTINATION from V$ARCHIVE_DEST where DB_UNIQUE_NAME='PRIMARY' and TARGET='REMOTE';

DEST_ID DESTINATION
---------- --------------------
2 PRIMARYCONNECT

In this example, RMAN will use connect identifier PRIMARYCONNECT for primary connection (This is valid when there is NO RMAN configuration to specify CONNECT IDENTIFIER for DB_UNIQUE_NAME 'PRIMARY')

 

REFERENCES

NOTE:1419923.1 - Howto make a consistent RMAN backup in an Standby database in Active DataGuard mode
NOTE:1616074.1 - RMAN-06820 ORA-17629 During Backup at Standby Site






About Me

........................................................................................................................

● 本文作者:小麥苗,部分內容整理自網路,若有侵權請聯絡小麥苗刪除

● 本文在個人微 信公眾號( DB寶)上有同步更新

● QQ群號: 230161599 、618766405,微信群私聊

● 個人QQ號(646634621),微 訊號(db_bao),註明新增緣由

● 於 2020年7月 在西安完成

● 最新修改時間:2020年7月

● 版權所有,歡迎分享本文,轉載請保留出處

........................................................................................................................

小麥苗的微店https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

● 小麥苗出版的資料庫類叢書: http://blog.itpub.net/26736162/viewspace-2142121/

小麥苗OCP、OCM、高可用、DBA學習班http://blog.itpub.net/26736162/viewspace-2148098/

● 資料庫筆試面試題庫及解答: http://blog.itpub.net/26736162/viewspace-2134706/

........................................................................................................................

請掃描下面的二維碼來關注小麥苗的微 信公眾號( DB寶)及QQ群(230161599、618766405)、新增小麥苗微 信(db_bao), 學習最實用的資料庫技術。

........................................................................................................................

 

 



來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26736162/viewspace-2707187/,如需轉載,請註明出處,否則將追究法律責任。

相關文章