OraFAQ Forum: Backup & Recovery » RAC Database duplication using RMAN

Home » RDBMS Server » Backup & Recovery » RAC Database duplication using RMAN (Oracle 10g R2, Oracle Enterprise Linux 4 update 6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC Database duplication using RMAN [message #490781]

Thu, 27 January 2011 05:59

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

I have done many duplication before in sinlge instance databases using a backup tool and rman catalog. At the moment i was trying to do a RAC database duplication and facing some issues. For this i was doing a testing on my 1-node RAC. Primary and duplicated database is on the same Host and oracle version is 10.2.0.3. I perfomed following steps:

1.Created a DUPL database using DBCA.
2.Created a pfile using spfile.
3.Dropped all the datafiles, controlfiles and redo log files.
4.Started the database in nomount using pfile.
5.Disable cluster related parameters in pfile.
6.Took a full backup of the MAIN database with archivelog on disk.
6.Duplicate the database and it is done successfully.
7.Shutdown the instance and enabled cluster parameters.
8.Start instance using SRVCTL fails with error CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'

But if start the instance using sqlplus it comes up nicely. There is not much information in alert log files. Can you please highlight what i am missing here?

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490782 is a reply to message #490781]

Thu, 27 January 2011 06:04

knight
Messages: 111
Registered: January 2009

Senior Member

did you check in crs logs for any messages/errors?

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490783 is a reply to message #490781]

Thu, 27 January 2011 06:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Post the output of

crs_stat -t

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490786 is a reply to message #490783]

Thu, 27 January 2011 06:17

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

NAME=ora.DUPL.DUPL1.inst
TYPE=application
TARGET=ONLINE
STATE=ONLINE on cpbttodevorra001

NAME=ora.DUPL.db
TYPE=application
TARGET=ONLINE
STATE=ONLINE on cpbttodevorra001

It shows online here. And when i start the resource by srvctl start resources ora.DUPL.DUPL1.inst , it starts fine. But when i start the database (srvctl start database -d DUPL) it fails.

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490788 is a reply to message #490786]

Thu, 27 January 2011 06:26

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

I just turn the trace on for for srvctl command (export SRVM_TRACE=TRUE)and here is the log file attached.

Attachment: DUPL.log
(Size: 33.50KB, Downloaded 1978 times)

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490794 is a reply to message #490781]

Thu, 27 January 2011 07:01

knight
Messages: 111
Registered: January 2009

Senior Member

post o/p of

srvctl status database -d DUPL

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490795 is a reply to message #490794]

Thu, 27 January 2011 07:10

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

BLUE1-> srvctl status database -d DUPL
Instance DUPL1 is not running on node cpbttodevorra001

BLUE1-> srvctl start database -d DUPL
PRKP-1001 : Error starting instance DUPL1 on node cpbttodevorra001
CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'.

BLUE1-> su - root
Password:
[root@CPBTTODEVORRA001 ~]# pwd
/root
[root@CPBTTODEVORRA001 ~]# cd /u01/oracle/crs/bin/
[root@CPBTTODEVORRA001 bin]# ./crsctl start resources ora.DUPL.DUPL1.inst
Starting resources.
Successfully started CRS resources

[root@CPBTTODEVORRA001 bin]# ./srvctl start database -d DUPL
PRKP-1001 : Error starting instance DUPL1 on node cpbttodevorra001
CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'.

[root@CPBTTODEVORRA001 bin]# ./srvctl status database -d DUPL
Instance DUPL1 is not running on node cpbttodevorra001

[root@CPBTTODEVORRA001 bin]#

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490803 is a reply to message #490795]

Thu, 27 January 2011 07:44

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Seems your spfile has issues.
After duplication,
check for valid spfile with valid cluster settings.

Report message to a moderator

Re: RAC Database duplication using RMAN [message #490807 is a reply to message #490803]

Thu, 27 January 2011 07:57

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Mahesh, i created spfile from pfile after duplication. so both file are identicle. Below is the pfile:

DUPL1.__db_cache_size=1207959552
DUPL1.__java_pool_size=16777216
DUPL1.__large_pool_size=16777216
DUPL1.__shared_pool_size=352321536
DUPL1.__streams_pool_size=0
*.audit_file_dest='/u01/oracle/admin/DUPL/adump'
*.background_dump_dest='/u01/oracle/admin/DUPL/bdump'
*.cluster_database_instances=1
*.cluster_database=true
*.compatible='10.2.0.3.0'
*.control_files='+DATA/dupl/controlfile/controlfile001.dbf','+FLASH/dupl/controlfile/controlfile002.dbf'
*.DB_FILE_NAME_CONVERT=+DATA,+DATA
*.LOG_FILE_NAME_CONVERT=+DATA,+DATA
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=8
*.db_name='DUPL'
#*.DB_UNIQUE_NAME='DUPL'
*.db_recovery_file_dest='+FLASH'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DUPLXDB)'
DUPL1.instance_number=1
*.job_queue_processes=10
*.nls_language='ENGLISH'
*.nls_territory='UNITED KINGDOM'
*.open_cursors=300
*.pga_aggregate_target=839909376
*.processes=150
*.remote_listener='LISTENERS_DUPL'
*.remote_login_passwordfile='exclusive'
*.sga_target=1610612736
DUPL1.thread=1
*.undo_management='AUTO'
DUPL1.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/oracle/admin/DUPL/udump'

Report message to a moderator

Re: RAC Database duplication using RMAN [message #492388 is a reply to message #490807]

Sun, 30 January 2011 15:20

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

well have you checked DUPL1 instance alert log?

- Babu

Report message to a moderator

Re: RAC Database duplication using RMAN [message #492593 is a reply to message #492388]

Tue, 01 February 2011 06:27

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Hi,

Below are the entries of the alert log file of the database.

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=17, OS id=1869
Tue Jan 25 13:54:46 2011
starting up 1 shared server(s) ...
USER: terminating instance due to error 29760
Tue Jan 25 13:54:46 2011
Errors in file /u01/oracle/admin/DUPL/bdump/dupl_pmon_1807.trc:
ORA-29760: Message 29760 not found; No message file for product=RDBMS, facility=ORA
Instance terminated by USER, pid = 1638
-bash-3.00$ more /u01/oracle/admin/DUPL/bdump/dupl_pmon_1807.trc
/u01/oracle/admin/DUPL/bdump/dupl_pmon_1807.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /u01/oracle/10g
System name: Linux
Node name: CPBTTODEVORRA001.21CP.LOCAL
Release: 2.6.9-42.ELsmp
Version: #1 SMP Wed Jul 12 23:27:17 EDT 2006
Machine: i686
Instance name: DUPL
Redo thread mounted by this instance: 0 <none>
Oracle process number: 2
Unix process pid: 1807, image: oracle@CPBTTODEVORRA001.21CP.LOCAL (PMON)

*** SERVICE NAME:() 2011-01-25 13:54:46.056
*** SESSION ID:(170.1) 2011-01-25 13:54:46.056
error 29760 detected in background process
ORA-29760: Message 29760 not found; No message file for product=RDBMS, facility=ORA
-bash-3.00$

In Some google thread, the error pointer is the instance_number parameter in the parameter file, though i have specified this parameter in the init file.

Thanks

Report message to a moderator

Re: RAC Database duplication using RMAN [message #492598 is a reply to message #492593]

Tue, 01 February 2011 06:45

dbanukesh
Messages: 96
Registered: November 2008
Location: London

Member

Hi All,

This problem is resolved now. It was instance name case sensitiveness of the instance name in the OCR/spfile.

https://support.oracle.com/CSP/ui/flash.html#tab=KBHome (page=KBHome&id=()),(page=KBNavigator&id=(bmDocID=749515.1&bmDocTitle='ORA-29760:%20instance_number%20parameter%20not%20s pecified'%20When%20Starting%20the%20Database%20with%20Srvctl&from=BOOKMARK&bmDocType=PROBLEM&viewingMode=1143&bmDocDs rc=KB))

Interesting issue though:-)

Thanks for all your inputs through out the course of this issue. Much appreciated.

cheers
Nukesh

Report message to a moderator