on 08-30-2008 8:08 AM
Hello All,
We are currently performing homogenous system copy and the environment were as follows:
SAP: R/3 4.7
OS: Windows 2003 Server
DB: Oracle
The following were the activities that we have performed in below mentioned sequence for the system copy from Target system PRD to Source System DEV
1. DEV system details were collected in transport copies. These details includes user profiles, RFC connections, printer definition, license files, user directories, developer access key and login group.
2.Created control file in the PRD system using command alter database backup controlfile to trace;
3.Changed the value PRD to DEV in the control file and also deleted unwanted lines.
4.The backup from PRD is online backup to the external disk and is copied to the DEV system
5.Copied the log file xxxxxxxx.fnd from PRD system to DEV system and placed it under the folder G:\oracle\DEV\sapbackup. This log file is identified using DB12 transaction code from the source system.
6.The log file is edited and made necessary changes for starting the BR Restore with command Brrestore u2013c force u2013b xxxxxxxx.fnd -m full. Later the restoration completed successfully.
7.Later executed the command show parameter control_files in the source system to identify the location of the control files and placed the control file in the target system (in all the locations that were returned after executing above said command)
8.Then executed the control file by connecting to oracle using command @DEV.sql
But the following error occurs
SQL> @DEV.sql
Oracle instance started.
Total System Global Area 312025000 bytes
Fixed Size 454568 bytes
Variable Size 176160768 bytes
Database Buffers 134217728 bytes
Redo Buffers 1191936 bytes
ORA-00205 : error in identifying controlfile, check alert log for more info
Control file created
As i have searched through SDN and other forums it suggested that we need to copy the control files to all the locations which will be returned when we execute the command show parameter control_files. In my case both in source system and target system the values were same. Hope i have explained the scenario in detail. Is that anything that i am missing or somewhere i am going wrong? Kindly enlighten me.
Regards,
Anand
Hello Karan,
Thanks for your help. The issue is resolved.
Regards,
Anand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There are three control files,one is in sapdata1 file,2nd is in Orrilog A & the third is in saparch .& also please check the permission of control files & owner .Than again run @DEV.sql.
If it did not work than paste the last few lines from back<sid>.log file.You can find this file in backup folder.
karan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
if yoy are using the backup restore method than you have no need to repalce the control file because the control fils over written during restore.& than run the generated control file DEV.sql in the target system.please replce the controlfile which generated after the restore & than run the DEV.sql .
If problem did not solve than paste few last line from alert files.
You can find alert file from the following location
/oracle/<sid>/saptrace/background/alert_sid.log
And also please check the location of control file in init<sid>.sap file
And also refer to the following note:-546006
[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=546006]
Edited by: karan Singh on Aug 30, 2008 11:19 AM
Hello Karan,
Yes we were using backup restore method. The control file is generated after restore and placed in the following locations. These values were returned after executing the command show parameter control_files;
G:\oracle\FRD\origlogA\cntrl\cntrlDEV.dbf
G:\oracle\FRD\saparch\cntrl\cntrlDEV.dbf
K:\ORACLE\dev\sapdata1\system_1\cntrl\cntrlDEV.dbf
backFRD.log file:
bdyqhjvw fnd 2008-08-21 20.00.52 2008-08-22 16.12.11 5 ............... 69 68 0 4332 460011246 0 0 FULL online disk -
c 6.40 (45)
bdyqtmbj dbv 2008-08-24 07.00.59 2008-08-24 10.24.32 1 ............... 69 68 0 4336 461776335 0 0 ALL online null -
dc 6.40 (45)
bdyreplc and 2008-08-26 13.21.16 2008-08-26 22.03.38 1 ............... 69 68 0 4338 466999117 4340 468314572 ALL online disk -
c 6.40 (45)
bdyrjfpx and 2008-08-27 11.55.21 2008-08-27 19.35.50 1 ............... 69 68 0 4340 468314572 4342 468605075 ALL online disk -
c 6.40 (45)
Also there was file restDEV.log
rdyrprah rsb 2008-08-28 19.21.23 2008-08-28 19.21.23 3 0 0 0 ............ .......... ............ .... 6.40 (45)
rdyrprgl rsb 2008-08-28 19.24.03 2008-08-28 19.24.05 3 85 0 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
rdyrprrh rsb 2008-08-28 19.28.45 2008-08-28 19.28.46 3 85 0 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
rdyrpseg rsb 2008-08-28 19.34.22 2008-08-28 19.34.24 3 85 0 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
rdyrpsns rsb 2008-08-28 19.38.28 2008-08-28 19.38.31 3 85 0 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
rdyrpszr rsb 2008-08-28 19.43.39 2008-08-28 19.43.40 1 85 0 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
rdyrptrk rsb 2008-08-28 19.51.20 2008-08-29 11.57.06 1 85 84 0 FULL disk bdyqnyfh.fnd ---c 6.40 (45)
Regards,
Anand
Hello Karan,
The path in the control file remains same as in the source system. There is no difference between these parameters. Herewith i have also attached the log file.
-
Fri Aug 29 22:16:39 2008
ORA-205 signalled during: ALTER DATABASE MOUNT...
Fri Aug 29 22:16:39 2008
CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 4537
LOGFILE
GROUP 1 (
'G:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF',
'H:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'G:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF',
'H:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF'
) SIZE 50M,
GROUP 3 (
'G:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF',
'H:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF'
) SIZE 50M,
GROUP 4 (
'G:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF',
'H:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
'K:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV_1\DEV.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV_2\DEV.DATA2',
'K:\ORACLE\DEV\SAPDATA1\DEV_3\DEV.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV_4\DEV.DATA4',
'K:\ORACLE\DEV\SAPDATA1\DEV_5\DEV.DATA5',
'K:\ORACLE\DEV\SAPDATA1\DEV_6\DEV.DATA6',
'K:\ORACLE\DEV\SAPDATA1\DEV_7\DEV.DATA7',
'K:\ORACLE\DEV\SAPDATA1\DEV_8\DEV.DATA8',
'K:\ORACLE\DEV\SAPDATA1\DEV_9\DEV.DATA9',
'K:\ORACLE\DEV\SAPDATA1\DEV_10\DEV.DATA10',
'K:\ORACLE\DEV\SAPDATA1\DEV_11\DEV.DATA11',
'K:\ORACLE\DEV\SAPDATA1\DEV_12\DEV.DATA12',
'K:\ORACLE\DEV\SAPDATA1\DEV_13\DEV.DATA13',
'K:\ORACLE\DEV\SAPDATA1\DEV_14\DEV.DATA14',
'K:\ORACLE\DEV\SAPDATA1\DEV_15\DEV.DATA15',
'K:\ORACLE\DEV\SAPDATA1\DEV_16\DEV.DATA16',
'K:\ORACLE\DEV\SAPDATA1\DEV_17\DEV.DATA17',
'K:\ORACLE\DEV\SAPDATA1\DEV_18\DEV.DATA18',
'K:\ORACLE\DEV\SAPDATA1\DEV_19\DEV.DATA19',
'K:\ORACLE\DEV\SAPDATA1\DEV_20\DEV.DATA20',
'K:\ORACLE\DEV\SAPDATA1\DEV_21\DEV.DATA21',
'K:\ORACLE\DEV\SAPDATA1\DEV_22\DEV.DATA22',
'K:\ORACLE\DEV\SAPDATA1\DEV_23\DEV.DATA23',
'K:\ORACLE\DEV\SAPDATA1\DEV_24\DEV.DATA24',
'K:\ORACLE\DEV\SAPDATA1\DEV_25\DEV.DATA25',
'K:\ORACLE\DEV\SAPDATA1\DEV_26\DEV.DATA26',
'K:\ORACLE\DEV\SAPDATA1\DEV_27\DEV.DATA27',
'K:\ORACLE\DEV\SAPDATA1\DEV_28\DEV.DATA28',
'K:\ORACLE\DEV\SAPDATA1\DEV_29\DEV.DATA29',
'K:\ORACLE\DEV\SAPDATA1\DEV_30\DEV.DATA30',
'K:\ORACLE\DEV\SAPDATA1\DEV_31\DEV.DATA31',
'K:\ORACLE\DEV\SAPDATA1\DEV_32\DEV.DATA32',
'K:\ORACLE\DEV\SAPDATA1\DEV_33\DEV.DATA33',
'K:\ORACLE\DEV\SAPDATA1\DEV_34\DEV.DATA34',
'K:\ORACLE\DEV\SAPDATA1\DEV_35\DEV.DATA35',
'K:\ORACLE\DEV\SAPDATA1\DEV_36\DEV.DATA36',
'K:\ORACLE\DEV\SAPDATA1\DEV_37\DEV.DATA37',
'K:\ORACLE\DEV\SAPDATA1\DEV_38\DEV.DATA38',
'K:\ORACLE\DEV\SAPDATA1\DEV_39\DEV.DATA39',
'K:\ORACLE\DEV\SAPDATA1\DEV_40\DEV.DATA40',
'K:\ORACLE\DEV\SAPDATA1\DEV_41\DEV.DATA41',
'K:\ORACLE\DEV\SAPDATA1\DEV_42\DEV.DATA42',
'K:\ORACLE\DEV\SAPDATA1\DEV_43\DEV.DATA43',
'K:\ORACLE\DEV\SAPDATA1\DEV_44\DEV.DATA44',
'K:\ORACLE\DEV\SAPDATA1\DEV_45\DEV.DATA45',
'K:\ORACLE\DEV\SAPDATA1\DEV_46\DEV.DATA46',
'K:\ORACLE\DEV\SAPDATA1\DEV_47\DEV.DATA47',
'K:\ORACLE\DEV\SAPDATA1\DEV_48\DEV.DATA48',
'K:\ORACLE\DEV\SAPDATA1\DEV_49\DEV.DATA49',
'K:\ORACLE\DEV\SAPDATA1\DEV_50\DEV.DATA50',
'K:\ORACLE\DEV\SAPDATA1\DEV_51\DEV.DATA51',
'K:\ORACLE\DEV\SAPDATA1\DEV_52\DEV.DATA52',
'K:\ORACLE\DEV\SAPDATA1\DEV_53\DEV.DATA53',
'K:\ORACLE\DEV\SAPDATA1\DEV_54\DEV.DATA54',
'K:\ORACLE\DEV\SAPDATA1\DEV_55\DEV.DATA55',
'K:\ORACLE\DEV\SAPDATA1\DEV_56\DEV.DATA56',
'K:\ORACLE\DEV\SAPDATA1\DEV_57\DEV.DATA57',
'K:\ORACLE\DEV\SAPDATA1\DEV_58\DEV.DATA58',
'K:\ORACLE\DEV\SAPDATA1\DEV620_1\DEV620.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV620_2\DEV620.DATA2',
'K:\ORACLE\DEV\SAPDATA1\DEV620_3\DEV620.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV620_4\DEV620.DATA4',
'K:\ORACLE\DEV\SAPDATA1\DEV620_5\DEV620.DATA5',
'K:\ORACLE\DEV\SAPDATA1\DEV620_6\DEV620.DATA6',
'K:\ORACLE\DEV\SAPDATA1\DEV620_7\DEV620.DATA7',
'K:\ORACLE\DEV\SAPDATA1\DEVUSR_1\DEVUSR.DATA1',
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_2\SYSTEM.DATA2',
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_3\SYSTEM.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV_59\DEV.DATA59',
'K:\ORACLE\DEV\SAPDATA1\DEV_60\DEV.DATA60',
'K:\ORACLE\DEV\SAPDATA1\DEV_61\DEV.DATA61',
'K:\ORACLE\DEV\SAPDATA1\DEV_62\DEV.DATA62',
'K:\ORACLE\DEV\SAPDATA1\DEV620_8\DEV620.DATA8',
'K:\ORACLE\DEV\SAPDATA1\DEV620_9\DEV620.DATA9',
'K:\ORACLE\DEV\SAPDATA1\DEV_63\DEV.DATA63',
'K:\ORACLE\DEV\SAPDATA1\DEV_64\DEV.DATA64',
'K:\ORACLE\DEV\SAPDATA1\DEV_65\DEV.DATA65',
'K:\ORACLE\DEV\SAPDATA1\DEV_66\DEV.DATA66',
'K:\ORACLE\DEV\SAPDATA1\DEV_67\DEV.DATA67',
'K:\ORACLE\DEV\SAPDATA1\DEV_68\DEV.DATA68',
'K:\ORACLE\DEV\SAPDATA1\DEV_69\DEV.DATA69',
'K:\ORACLE\DEV\SAPDATA1\DEV_70\DEV.DATA70'
CHARACTER SET WE8DEC
Fri Aug 29 22:16:42 2008
Successful mount of redo thread 1, with mount id 3987559623.
Fri Aug 29 22:16:42 2008
Completed: CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETL
-
Hello Karan,
Thanks again for your time and reply.
Could you let me know how to check the control file state (i.e.)online or not.
Also i have deleted all the lines after the ; and attached the control file here for verifying the same.
-
STARTUP MOUNT
CREATE CONTROLFILE REUSE SET DATABASE "DEV" RESETLOGS ARCHIVELOG
-- SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 4537
LOGFILE
GROUP 1 (
'G:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF',
'H:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF'
) SIZE 50M,
GROUP 2 (
'G:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF',
'H:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF'
) SIZE 50M,
GROUP 3 (
'G:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF',
'H:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF'
) SIZE 50M,
GROUP 4 (
'G:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF',
'H:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
'K:\ORACLE\DEV\SAPDATA1\UNDO_1\UNDO.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV_1\DEV.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV_2\DEV.DATA2',
'K:\ORACLE\DEV\SAPDATA1\DEV_3\DEV.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV_4\DEV.DATA4',
'K:\ORACLE\DEV\SAPDATA1\DEV_5\DEV.DATA5',
'K:\ORACLE\DEV\SAPDATA1\DEV_6\DEV.DATA6',
'K:\ORACLE\DEV\SAPDATA1\DEV_7\DEV.DATA7',
'K:\ORACLE\DEV\SAPDATA1\DEV_8\DEV.DATA8',
'K:\ORACLE\DEV\SAPDATA1\DEV_9\DEV.DATA9',
'K:\ORACLE\DEV\SAPDATA1\DEV_10\DEV.DATA10',
'K:\ORACLE\DEV\SAPDATA1\DEV_11\DEV.DATA11',
'K:\ORACLE\DEV\SAPDATA1\DEV_12\DEV.DATA12',
'K:\ORACLE\DEV\SAPDATA1\DEV_13\DEV.DATA13',
'K:\ORACLE\DEV\SAPDATA1\DEV_14\DEV.DATA14',
'K:\ORACLE\DEV\SAPDATA1\DEV_15\DEV.DATA15',
'K:\ORACLE\DEV\SAPDATA1\DEV_16\DEV.DATA16',
'K:\ORACLE\DEV\SAPDATA1\DEV_17\DEV.DATA17',
'K:\ORACLE\DEV\SAPDATA1\DEV_18\DEV.DATA18',
'K:\ORACLE\DEV\SAPDATA1\DEV_19\DEV.DATA19',
'K:\ORACLE\DEV\SAPDATA1\DEV_20\DEV.DATA20',
'K:\ORACLE\DEV\SAPDATA1\DEV_21\DEV.DATA21',
'K:\ORACLE\DEV\SAPDATA1\DEV_22\DEV.DATA22',
'K:\ORACLE\DEV\SAPDATA1\DEV_23\DEV.DATA23',
'K:\ORACLE\DEV\SAPDATA1\DEV_24\DEV.DATA24',
'K:\ORACLE\DEV\SAPDATA1\DEV_25\DEV.DATA25',
'K:\ORACLE\DEV\SAPDATA1\DEV_26\DEV.DATA26',
'K:\ORACLE\DEV\SAPDATA1\DEV_27\DEV.DATA27',
'K:\ORACLE\DEV\SAPDATA1\DEV_28\DEV.DATA28',
'K:\ORACLE\DEV\SAPDATA1\DEV_29\DEV.DATA29',
'K:\ORACLE\DEV\SAPDATA1\DEV_30\DEV.DATA30',
'K:\ORACLE\DEV\SAPDATA1\DEV_31\DEV.DATA31',
'K:\ORACLE\DEV\SAPDATA1\DEV_32\DEV.DATA32',
'K:\ORACLE\DEV\SAPDATA1\DEV_33\DEV.DATA33',
'K:\ORACLE\DEV\SAPDATA1\DEV_34\DEV.DATA34',
'K:\ORACLE\DEV\SAPDATA1\DEV_35\DEV.DATA35',
'K:\ORACLE\DEV\SAPDATA1\DEV_36\DEV.DATA36',
'K:\ORACLE\DEV\SAPDATA1\DEV_37\DEV.DATA37',
'K:\ORACLE\DEV\SAPDATA1\DEV_38\DEV.DATA38',
'K:\ORACLE\DEV\SAPDATA1\DEV_39\DEV.DATA39',
'K:\ORACLE\DEV\SAPDATA1\DEV_40\DEV.DATA40',
'K:\ORACLE\DEV\SAPDATA1\DEV_41\DEV.DATA41',
'K:\ORACLE\DEV\SAPDATA1\DEV_42\DEV.DATA42',
'K:\ORACLE\DEV\SAPDATA1\DEV_43\DEV.DATA43',
'K:\ORACLE\DEV\SAPDATA1\DEV_44\DEV.DATA44',
'K:\ORACLE\DEV\SAPDATA1\DEV_45\DEV.DATA45',
'K:\ORACLE\DEV\SAPDATA1\DEV_46\DEV.DATA46',
'K:\ORACLE\DEV\SAPDATA1\DEV_47\DEV.DATA47',
'K:\ORACLE\DEV\SAPDATA1\DEV_48\DEV.DATA48',
'K:\ORACLE\DEV\SAPDATA1\DEV_49\DEV.DATA49',
'K:\ORACLE\DEV\SAPDATA1\DEV_50\DEV.DATA50',
'K:\ORACLE\DEV\SAPDATA1\DEV_51\DEV.DATA51',
'K:\ORACLE\DEV\SAPDATA1\DEV_52\DEV.DATA52',
'K:\ORACLE\DEV\SAPDATA1\DEV_53\DEV.DATA53',
'K:\ORACLE\DEV\SAPDATA1\DEV_54\DEV.DATA54',
'K:\ORACLE\DEV\SAPDATA1\DEV_55\DEV.DATA55',
'K:\ORACLE\DEV\SAPDATA1\DEV_56\DEV.DATA56',
'K:\ORACLE\DEV\SAPDATA1\DEV_57\DEV.DATA57',
'K:\ORACLE\DEV\SAPDATA1\DEV_58\DEV.DATA58',
'K:\ORACLE\DEV\SAPDATA1\DEV620_1\DEV620.DATA1',
'K:\ORACLE\DEV\SAPDATA1\DEV620_2\DEV620.DATA2',
'K:\ORACLE\DEV\SAPDATA1\DEV620_3\DEV620.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV620_4\DEV620.DATA4',
'K:\ORACLE\DEV\SAPDATA1\DEV620_5\DEV620.DATA5',
'K:\ORACLE\DEV\SAPDATA1\DEV620_6\DEV620.DATA6',
'K:\ORACLE\DEV\SAPDATA1\DEV620_7\DEV620.DATA7',
'K:\ORACLE\DEV\SAPDATA1\DEVUSR_1\DEVUSR.DATA1',
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_2\SYSTEM.DATA2',
'K:\ORACLE\DEV\SAPDATA1\SYSTEM_3\SYSTEM.DATA3',
'K:\ORACLE\DEV\SAPDATA1\DEV_59\DEV.DATA59',
'K:\ORACLE\DEV\SAPDATA1\DEV_60\DEV.DATA60',
'K:\ORACLE\DEV\SAPDATA1\DEV_61\DEV.DATA61',
'K:\ORACLE\DEV\SAPDATA1\DEV_62\DEV.DATA62',
'K:\ORACLE\DEV\SAPDATA1\DEV620_8\DEV620.DATA8',
'K:\ORACLE\DEV\SAPDATA1\DEV620_9\DEV620.DATA9',
'K:\ORACLE\DEV\SAPDATA1\DEV_63\DEV.DATA63',
'K:\ORACLE\DEV\SAPDATA1\DEV_64\DEV.DATA64',
'K:\ORACLE\DEV\SAPDATA1\DEV_65\DEV.DATA65',
'K:\ORACLE\DEV\SAPDATA1\DEV_66\DEV.DATA66',
'K:\ORACLE\DEV\SAPDATA1\DEV_67\DEV.DATA67',
'K:\ORACLE\DEV\SAPDATA1\DEV_68\DEV.DATA68',
'K:\ORACLE\DEV\SAPDATA1\DEV_69\DEV.DATA69',
'K:\ORACLE\DEV\SAPDATA1\DEV_70\DEV.DATA70'
CHARACTER SET WE8DEC
;
Ok than you create again a control file in your source system.
1:_Create a controlfile template for target system on source system
-> go to oracle ( Production System)
-> alter database backup controlfile to trace resetlogs;
-> you will get this trace control file in the directory /oracle/<SID>/saptrace/usertrace
-> rename this trace file to control.sql
-> open this control.sql with notepad and remove alll these lines above from STARTUP NOMOUNT and change this "REUSE" to "SET" ( if the
source and target SIDs are different)
CREATE CONTROLFILE SET DATABASE <SID> ( Target system SID) RESETLOGS ARCHIVELOG
Remove all the lines after ";"
2:_go to oracle into the DEV and execute this @control.sql
3:-After completing you have to open the oracle database with this command "alter database open restlogs;"
Follow the aove step .
karan
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.