| Unable to create physical standby database using RMAN [message #481632] |
Thu, 04 November 2010 14:50  |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
Can someone tell why RMAN is unable to create physical standby database ?
-------------------------------------------------------
RMAN> connect auxiliary sys/system@DGREPL
connected to auxiliary database: DGREPL (not mounted)
RMAN> connect target sys/system@REPL
connected to target database: REPL (DBID=2730563515)
RMAN> run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'REPL','DGREPL'
set db_file_name_convert='/REPL/','/DGREPL/'
set log_file_name_convert='/REPL/','/DGREPL/'
set 'db_unique_name'='DGREPL'
set control_files='/u01/app/oracle/oradata/DGREPL/control01.ctl','/u01/app/oracle/flash_recovery_area/DGREPL/control02.ctl'
set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
set DB_RECOVERY_FILE_DEST_SIZE='4977M'
nofilenamecheck;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=125 device type=DISK
allocated channel: prmy2
channel prmy2: SID=146 device type=DISK
allocated channel: prmy3
channel prmy3: SID=22 device type=DISK
allocated channel: prmy4
channel prmy4: SID=14 device type=DISK
allocated channel: prmy5
channel prmy5: SID=144 device type=DISK
allocated channel: stby1
channel stby1: SID=19 device type=DISK
Starting Duplicate Db at 04-NOV-10
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwREPL' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwDGREPL' targetfile
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileREPL.ora' auxiliary format
'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileDGREPL.ora' ;
sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileDGREPL.ora''";
}
executing Memory Script
Starting backup at 04-NOV-10
Finished backup at 04-NOV-10
sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileDGREPL.ora''
contents of Memory Script:
{
sql clone "alter system set audit_file_dest =
''/u01/app/oracle/admin/DGREPL/adump'' comment=
'''' scope=spfile";
sql clone "alter system set dispatchers =
''(PROTOCOL=TCP) (SERVICE=DGREPLXDB)'' comment=
'''' scope=spfile";
sql clone "alter system set db_file_name_convert =
''/REPL/'', ''/DGREPL/'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''/REPL/'', ''/DGREPL/'' comment=
'''' scope=spfile";
sql clone "alter system set db_unique_name =
''DGREPL'' comment=
'''' scope=spfile";
sql clone "alter system set control_files =
''/u01/app/oracle/oradata/DGREPL/control01.ctl'', ''/u01/app/oracle/flash_recovery_area/DGREPL/control02.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set db_recovery_file_dest =
''/u01/app/oracle/flash_recovery_area'' comment=
'''' scope=spfile";
sql clone "alter system set DB_RECOVERY_FILE_DEST_SIZE =
4977M comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/DGREPL/adump'' comment= '''' scope=spfile
sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=DGREPLXDB)'' comment= '''' scope=spfile
sql statement: alter system set db_file_name_convert = ''/REPL/'', ''/DGREPL/'' comment= '''' scope=spfile
sql statement: alter system set log_file_name_convert = ''/REPL/'', ''/DGREPL/'' comment= '''' scope=spfile
sql statement: alter system set db_unique_name = ''DGREPL'' comment= '''' scope=spfile
sql statement: alter system set control_files = ''/u01/app/oracle/oradata/DGREPL/control01.ctl'', ''/u01/app/oracle/flash_recovery_area/DGREPL/control02.ctl'' comment= '''' scope=spfile
sql statement: alter system set db_recovery_file_dest = ''/u01/app/oracle/flash_recovery_area'' comment= '''' scope=spfile
sql statement: alter system set DB_RECOVERY_FILE_DEST_SIZE = 4977M comment= '''' scope=spfile
Oracle instance shut down
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: prmy5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/04/2010 15:31:06
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
-------------------------------------------------------
|
|
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #481635 is a reply to message #481633] |
Thu, 04 November 2010 15:06  |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
Yes, database become down because of following command by Memory script.
*************************
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount;
}
*************************
See everything is fine at the start. RMAN is connecting successfully from both target and auxiliary database successfully via oracle net server.
The problem is, RMAN is unable to continue database duplication with next command i.e 'startup clone nomount;' Any reason for it ??? and how to create duplicate database via RMAN ?
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #481636 is a reply to message #481634] |
Thu, 04 November 2010 15:12 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
Here is my listner.ora on standby host. What else need to statically register the auxiliary database ??
---------------------------------------------------------
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
DGREPL =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.xxx.com)(PORT = 1521))
)
)
SID_LIST_DGREPL =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DGREPL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = DGREPL)
)
)
ADR_BASE_REPL = /u01/app/oracle
---------------------------------------------------------
|
|
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #481641 is a reply to message #481639] |
Thu, 04 November 2010 15:56 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
$./lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-NOV-2010 16:55:16
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 04-NOV-2010 16:39:47
Uptime 0 days 0 hr. 15 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/dbhome_1/log/diag/tnslsnr/oracle/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.xxx.com)(PORT=1521)))
The listener supports no services
The command completed successfully
---------------------------------------
$ ./lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-NOV-2010 16:55:20
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The listener supports no services
The command completed successfully
|
|
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #481661 is a reply to message #481644] |
Fri, 05 November 2010 01:54 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
Perhaps I see the problem: your listener.ora that has the standby instance statically registered is in your database home, but you are running 11.2 where (if you are using the Grid Infrastructure) your listener will be running off the Grid home. Have you edited the correct file?
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #483126 is a reply to message #482595] |
Thu, 18 November 2010 10:49 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
@watson - i am not using grid infra-structure. its a simple single instance db.
@gentlebabu - i am using this command on standby database. i have already set the oracle_sid
$ echo $ORACLE_SID
DGREPL
connection identifier is used to connect both databases (target/auxiliary) via net service to make RMAN work. See error while running command not using identifier 'RMAN-06217: not connected to auxiliary database with a net service name'
--------------------------------------------------------
$ ./rman target sys/system@REPL auxiliary /
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Nov 18 21:40:48 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: REPL (DBID=2731504761)
connected to auxiliary database: DGREPL (not mounted)
RMAN> run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
allocate channel prmy5 type disk;
allocate auxiliary channel stby1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'REPL','DGREPL'
set db_file_name_convert='/REPL/','/DGREPL/'
set log_file_name_convert='/REPL/','/DGREPL/'
set 'db_unique_name'='DGREPL'
set control_files='/u01/app/oracle/oradata/DGREPL/control01.ctl','/u01/app/oracle/flash_recovery_area/DGREPL/control02.ctl'
set db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
set DB_RECOVERY_FILE_DEST_SIZE='4977M'
nofilenamecheck;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18>
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=39 device type=DISK
allocated channel: prmy2
channel prmy2: SID=49 device type=DISK
allocated channel: prmy3
channel prmy3: SID=45 device type=DISK
allocated channel: prmy4
channel prmy4: SID=41 device type=DISK
allocated channel: prmy5
channel prmy5: SID=47 device type=DISK
allocated channel: stby1
channel stby1: SID=19 device type=DISK
Starting Duplicate Db at 18-NOV-10
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: prmy5
released channel: stby1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/18/2010 21:43:49
RMAN-06217: not connected to auxiliary database with a net service name
--------------------------------------------------------
Any other thoughts to make me out of problem. I have also tested Centos 5.5 on both primary and standby database but problem is same for fedora 12 and centos 5.5.
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #483158 is a reply to message #481644] |
Thu, 18 November 2010 15:06 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
@blackswan - by replacing your listner file its producing the same error which is given from my very first post.
....
Oracle instance shut down
released channel: prmy1
released channel: prmy2
released channel: prmy3
released channel: prmy4
released channel: prmy5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/18/2010 22:12:57
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #483186 is a reply to message #483160] |
Fri, 19 November 2010 00:46 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
$ ls -ltr $ORACLE_HOME/dbs
total 24
-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.ora
-rw-r--r-- 1 oracle oinstall 15 Nov 19 10:58 initDGREPL.ora
drwx------ 2 oracle oinstall 4096 Nov 19 11:31 peshm_DGREPL_0
-rw-r----- 1 oracle oinstall 1536 Nov 19 11:40 orapwDGREPL
-rw-r----- 1 oracle oinstall 3584 Nov 19 11:41 spfileDGREPL.ora
-rw-rw---- 1 oracle oinstall 1544 Nov 19 11:41 hc_DGREPL.dat
|
|
|
|
|
|
| Re: Unable to create physical standby database using RMAN [message #483191 is a reply to message #483187] |
Fri, 19 November 2010 01:02 |
mateenaslam
Messages: 21
Registered: November 2010
Location: Islamabad, Pakistan
|
Junior Member |
|
|
Here is what i have in listner log file while executing above command:-
---------------------------------------------------------------------------
<msg time='2010-11-19T11:55:34.583+05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='oracle.xxxx.com'
host_addr='192.168.122.87'>
<txt>19-NOV-2010 11:55:34 * service_update * DGREPL * 0
</txt>
</msg>
<msg time='2010-11-19T11:55:35.270+05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='oracle.xxxx.com'
host_addr='192.168.122.87'>
<txt>19-NOV-2010 11:55:35 * service_died * DGREPL * 12537
</txt>
</msg>
<msg time='2010-11-19T11:55:37.462+05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='oracle.xxxx.com'
host_addr='192.168.122.87'>
<txt>19-NOV-2010 11:55:37 * (CONNECT_DATA=(SERVICE_NAME=DGREPL)(UR=A)(CID=(PROGRAM=rman)(HOST=oracle.xxxx.com)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.122.87)(PORT=49504)) * establish * DGREPL * 12514
</txt>
</msg>
<msg time='2010-11-19T11:55:37.462+05:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='oracle.xxxx.com'
host_addr='192.168.122.87'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
