Home » RDBMS Server » Backup & Recovery » RAC Database duplication using RMAN (Oracle 10g R2, Oracle Enterprise Linux 4 update 6)
RAC Database duplication using RMAN [message #490781] Thu, 27 January 2011 05:59 Go to next message
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?
Re: RAC Database duplication using RMAN [message #490782 is a reply to message #490781] Thu, 27 January 2011 06:04 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
did you check in crs logs for any messages/errors?
Re: RAC Database duplication using RMAN [message #490783 is a reply to message #490781] Thu, 27 January 2011 06:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Post the output of
crs_stat -t
Re: RAC Database duplication using RMAN [message #490786 is a reply to message #490783] Thu, 27 January 2011 06:17 Go to previous messageGo to next message
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.
Re: RAC Database duplication using RMAN [message #490788 is a reply to message #490786] Thu, 27 January 2011 06:26 Go to previous messageGo to next message
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 1516 times)
Re: RAC Database duplication using RMAN [message #490794 is a reply to message #490781] Thu, 27 January 2011 07:01 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
post o/p of
srvctl status database -d DUPL
Re: RAC Database duplication using RMAN [message #490795 is a reply to message #490794] Thu, 27 January 2011 07:10 Go to previous messageGo to next message
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]#
Re: RAC Database duplication using RMAN [message #490803 is a reply to message #490795] Thu, 27 January 2011 07:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator

Seems your spfile has issues.
After duplication,
check for valid spfile with valid cluster settings.
Re: RAC Database duplication using RMAN [message #490807 is a reply to message #490803] Thu, 27 January 2011 07:57 Go to previous messageGo to next message
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'
Re: RAC Database duplication using RMAN [message #492388 is a reply to message #490807] Sun, 30 January 2011 15:20 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

well have you checked DUPL1 instance alert log?

- Babu
Re: RAC Database duplication using RMAN [message #492593 is a reply to message #492388] Tue, 01 February 2011 06:27 Go to previous messageGo to next message
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
Re: RAC Database duplication using RMAN [message #492598 is a reply to message #492593] Tue, 01 February 2011 06:45 Go to previous messageGo to next message
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
Re: RAC Database duplication using RMAN [message #492600 is a reply to message #492598] Tue, 01 February 2011 06:46 Go to previous messageGo to next message
dbanukesh
Messages: 96
Registered: November 2008
Location: London
Member

Metalink Articke ID 749515.1

'ORA-29760: instance_number parameter not specified' When Starting the Database with Srvctl [ID 749515.1]
Re: RAC Database duplication using RMAN [message #492615 is a reply to message #492600] Tue, 01 February 2011 07:47 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

great to know you resolved your problem.

thanks for your feedback.

- babu
Previous Topic: error while copying database to new server.
Next Topic: restore incremental backup to new server
Goto Forum:
  


Current Time: Thu Mar 28 15:10:56 CDT 2024