Friday, 24 July 2015

Duplicate database fail with RMAN-04014 ORA-01127: database name '/SIDDEVLOP' exceeds size limit of 8 characters

During cloning of Oracle DB using rman auxilary command got below error.

ERROR:
connected to auxiliary database (not started)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/24/2015 01:43:21
RMAN-06403: could not obtain a fully authorized session
RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-01127: database name '/SIDDEVLOP' exceeds size limit of 8 characters
RMAN-04017: startup error description: ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

Solution:
Step1: Create text control file trace and edit as per requirement.
Step2: Edit init.ora with proper SID.
Step3: Startnomont,create controlfile and open database in resetlogs.

++ startup mount the db create text controlfile.
alter database backup controlfile to trace as '/tmp/controlSIDDEVLOP.txt';

edit initSIDDEVLOP.ora of db_name and db_unique_name

++Take out the block of 
 CREATE CONTROLFILE REUSE DATABASE "SIDDEVLOP" RESETLOGS NOARCHIVELOG
....
....
to 
CHARACTER SET WE8MSWIN1252
/

++ Edit the file as below.
 CREATE CONTROLFILE SET DATABASE "SIDDEVLOP" RESETLOGS NOARCHIVELOG
   MAXLOGFILES 192
     MAXLOGMEMBERS 3
     MAXDATAFILES 1024
     MAXINSTANCES 32
     MAXLOGHISTORY 5840
 LOGFILE
  GROUP 1 (
......
......
DATAFILE
  '+ASM_DATA01
....
....
CHARACTER SET WE8MSWIN1252
;

++ Now,Stop the DB and nomount the DB.
Then using above create controlfile command create the control file.
SQL>shut immediate
SQL> statup nomount

SQL> CREATE CONTROLFILE SET DATABASE "SIDDEVLOP" RESETLOGS NOARCHIVELOG
   MAXLOGFILES 192
     MAXLOGMEMBERS 3
     MAXDATAFILES 1024
     MAXINSTANCES 32
     MAXLOGHISTORY 5840
 LOGFILE
  GROUP 1 (
......
......
DATAFILE
  '+ASM_DATA01
....
....
CHARACTER SET WE8MSWIN1252
;

Control file created.

SQL>  alter database open resetlogs;

Database altered.

Ref: Manual Completion of a Failed RMAN Backup based Duplicate (Doc ID 360962.1)

No comments: