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
++ startup mount the db create text controlfile.
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.
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:
Post a Comment