not connected to auxiliary database with a net service name

Version imprimable

Bonjour,

Au moment de la réinitialisation rman de dataguard, j'ai:

Code:

1
2
3
4
5
6
RMAN-00571: ==================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================
RMAN-03002: failure of Duplicate Db command at 
RMAN-05501: aborting duplication of target database
RMAN-06217: not connected to auxiliary database with a net service name

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
[oracle]$ rman
Recovery Manager: Release 11.2.0.3.0 - Production 
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
RMAN> connect target sys/*****@PRDTST
connected to target database: PRODTST (DBID=3445454)
RMAN> connect auxiliary sys/******
connected to auxiliary database: PRODTST (not mounted)
RMAN> run
2> {
3> duplicate target database for standby from active database
4> spfile
5> parameter_value_convert 'PRODTST','PRDSTBY'
6> set db_unique_name='PRDSTBY'
7> set fal_client='PRDSTBY'
8> set fal_server='PRODTST'
9> set standby_file_management='auto'
10> set log_archive_config='dg_config=(PRODTST,PRDSTBY)'
11> set log_archive_dest_2='service=PRODTST async valid_for=(online_logfile, primary_role) db_unique_name=PRODTST'
12> set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server)(PORT=1541))))';
13> }
Starting Duplicate 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command 
RMAN-05501: aborting duplication of target database
RMAN-06217: not connected to auxiliary database with a net service name
 
 [oracle]$ tnsping PRDSTBY
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on  15:46:51
Copyright (c) 1997, 2011, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
………..
 (CONNECT_DATA = (SERVICE_NAME = PRDSTBY)))
OK (0 msec)
[oracle]$ tnsping PRODTST
 
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 
 
Copyright (c) 1997, 2011, Oracle.  All rights reserved.
 
Used parameter files:
Used TNSNAMES adapter to resolve the alias
…………..
 (CONNECT_DATA = (SERVICE_NAME = PRODTST)))
OK (0 msec)

Le server Oracle est sur un Linux.
Comment verifier si le transfert de fichier entre mes 2 servers se passe bien ?

Merci.

19/05/2013, 12h55
Pomalaix

On n'a pas le choix, il faut respecter les exigences d'Oracle comme indiqué dans le message d'erreur :

Citation:

RMAN-06217: NOT connected TO auxiliary DATABASE WITH a net service name

Donc au lieu de faire

Code:

connect auxiliary sys/******

, il faut utiliser

Code:

connect auxiliary sys/******@nom_tnsnames

D'ailleurs la connexion peut se faire aux deux bases en une seule étape :

Code:

rman target sys/xxx@base_primaire auxiliary sys/xxx@base_secours
22/05/2013, 14h28
agdid04

Bonjour et Merci.

Peu imorte le serveur (Primaire ou Backup) pour déclencher la duplication ?

Code:

rman target sys/xxx@base_primaire auxiliary sys/xxx@base_secours

@+

Citation:

Envoyé par agdid04

Bonjour et Merci.

Peu imorte le serveur (Primaire ou Backup) pour déclencher la duplication ?

Code:

rman target sys/xxx@base_primaire auxiliary sys/xxx@base_secours

La DUP ...LICATION ne démarre pas ! ai je oublié un ou +ieurs params ?

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
$  rman target sys/****@TEST auxiliary sys/****@TESTBY
Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 22 15:41:34 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TEST (DBID=455778885)
connected to auxiliary database: TEST (not mounted)
 
RMAN> duplicate target database for standby from active database
2> spfile
3> parameter_value_convert 'TEST','TESTBY'
4> set db_file_name_convert= '/data01/oradata/TEST','/data01/oradata/TESTBY'
5> set db_file_name_convert= '/data02/oradata/TEST','/data02/oradata/TESTBY'
6> set log_file_name_convert= '/data01/oradata/TEST','/data01/oradata/TESTBY'
7> set log_file_name_convert= '/data02/oradata/TEST','/data02/oradata/TESTBY'
8> set control_files='/data01/oradata/TESTBY/standby_01.ctl','/data02/oradata/TESTBY/standby_02.ctl'
9> SET FAL_CLIENT="TESTBY"
10> SET FAL_SERVER="TEST"
11> SET LOG_ARCHIVE_DEST_2="service=TEST ASYNC REGISTER VALID_FOR=(online_logfile,primary_role)"
12> set db_unique_name 'TESTBY'
13> set log_archive_config='dg_config=(TEST,TESTBY)
14> nofilenamecheck;
15>

Merci.

Bonjour,

J'ai créé ma DG comme en 10g: charger le fichier init recuperer un backup rman puis:
Code:

1 2 3 4 5 6 7 $ rman target sys/****@TEST auxiliary sys/****@TESTBY Recovery Manager: Release 11.2.0.3.0 - Production on Wed May 22 15:41:34 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: TEST (DBID=455778885) connected to auxiliary database: TEST (not mounted) RMAN> duplicate target database for standby;
Une question avant de clore cette conversation:

L'Active DG est payante ? est ce qu'on peut savoir si on a l'option ADG dans une vue ou pas ?

Merci.
@+