Updating spfile

This can also be used in conjunction with other parameters in the pfile, i.e.you may specify the location of the spfile and add some more parameters to the pfile.In version 12c now RMAN doesn’t change only the DB_NAME, but also the DB_UNIQUE_NAME and here is the trick! SQL alter system set db_unique_name='TOTO' scope=spfile; alter system set db_unique_name='TOTO' scope=spfile * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists SQL As we can see after setting the database in NOMOUNT, the cluster resource remains stopped as it is disabled.While working in a cluster environment (Oracle Restart, RAC One Node, RAC, ODA…) the database is defined as a cluster resource based on its DB_UNIQUE_NAME [[email protected] bin]# ./crsctl stat res ora.dbtest_site1-t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.dbtest_site11 ONLINE ONLINE dbioda1 Open, STABLE --------------------------------------------------------------------------------sql statement: alter system set db_name = ''DBPROD'' comment= ''Modified by RMAN duplicate'' scope=spfile sql statement: alter system set db_unique_name = ''DBTEST_SITE1'' comment= ''Modified by RMAN duplicate'' scope=spfile RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 09/03/2015 RMAN-04014: startup failed: ORA-00304: requested INSTANCE_NUMBER is busy RMAN-03015: error occurred in stored script Memory Script RMAN-03009: failure of sql command on clone_default channel at 09/03/2015 RMAN-11003: failure during parse/execution of SQL statement: alter system set db_unique_name = 'DBTEST_SITE1' comment= 'Modified by RMAN duplicate' scope=spfile ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists startup nomount ORACLE instance started. SQL alter system set db_unique_name='TOTO' scope=spfile; alter system set db_unique_name='TOTO' scope=spfile * ERROR at line 1: ORA-32017: failure in updating SPFILE ORA-65500: could not modify DB_UNIQUE_NAME, resource exists [email protected]:/home/oracle/ [DBTEST] srvctl status database -db DBTEST_SITE1 Instance DBTEST is running on node dbioda1 [email protected]:/home/oracle/ [DBTEST] srvctl stop database -db DBTEST_SITE1 [email protected]:/home/oracle/ [DBTEST] srvctl disable database -db DBTEST_SITE1 [email protected]:/home/oracle/ [DBTEST] sqh SQL*Plus: Release 12.1.0.2.0 Production on Thu Sep 3 2015 Copyright (c) 1982, 2014, Oracle. But even so we are not allowed to change the DB_UNIQUE_NAME Thefore the only solution I could found so far is first to remove the resource from the cluster, run the duplicate and then add the resource back in the cluster with a command like: srvctl add database -db DBTEST_SITE1 -oraclehome $ORACLE_HOME -dbtype SINGLE -role PRIMARY -spfile /u02/app/oracle/oradata/datastore/.I'm still working on this feature and will be posting updates soon.RAC (Real Application Server) in Oracle9i is the upgraded term of OPS (Oracle Parallel Server) in Oracle8i.Basically up to 12c when RMAN was doing a duplicate, it was changing the auxiliary spfile to set the DB_NAME at the value of the target database.

Look at the following scenario: You set specified in the pfile which takes precedence.However, there is a workaround here comments added on the same line of the parameter are not omitted.Look at the following example: The spfile, being a server-side parameter file, cannot be placed on a client machine and make use of it.For those who do not have an idea about parallel servers: Normally, one database has one instance associated to it.In parallel servers, one database is associated with more than one instance (i.e.

Leave a Reply

  1. zagadki wszechswiata z morganem freemanem online dating 17-Mar-2016 16:29

    There are several Starčevo sites in and around Belgrade, including the eponymous site of Starčevo.

  2. ncis los angeles season 3 episode 22 online dating 07-Jul-2016 01:02

    It is not affiliated in any way with the goods or services that may be parodied.

  3. picyou online dating 13-Jun-2016 11:41

    Simply click the banners at the top of the page to find live sex in that category: Want to narrow your search even further?

  4. wanninger sparkauf online dating 12-Nov-2016 23:08

  5. many member dating site 23-Aug-2016 23:02

    If you are looking for a particular type of bride Ukraine free, use Advanced search in the Gallery of Ladies.