on 11-16-2011 5:38 AM
Dear Experts,
we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.
when i startup my database getting error.
SQL> startup mount
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 306185108 bytes
Database Buffers 222298112 bytes
Redo Buffers 5844992 bytes
ORA-00205: error in identifying control file, check alert log for more info
when i checked initSID.ora then found old location of control file.
1)/oracle/SID/sapdata1/cntrl
2)/oracle/SID/origlogA/cntrl
3)/oracle/SID/origlogB/cntrl
i have manually changed location of control file.
1)/oracle/SID/sapdata10/cntrl
2)/oracle/SID/origlogA/cntrl
3)/oracle/SID/origlogB/cntrl
SQL> Create Pfile from Spfile;
File Created.
i would like to mount my database from Pfile plese help me i execute scripts below.
SQL> STARTUP MOUNT=/oracle/SID/ORACLE_HOME/dbs/initSID.ora
invalid startup option.
or suggest me some other way so that i can startup my Database.
with Regards
Hi,
Can you re-create your controlfile so that it has updated information post movement of datafiles.
Post this try to start your database.
Steps:
1) Startup database in mount state
2) SQL> alter system backup controlfile to trace
3) check whether the path of each datafile is correct in the trace file or not. If required modify the same.
4) Create a control.sql file using the updated trace file
5) create new controlfiles using control.sql script.
In case you want to start your database using pfile use the command
STARTUP MOUNT pf=/oracle/SID/ORACLE_HOME/dbs/initSID.ora
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi User,
As per you question below :
Dear Experts,
connected to idle instance
changed in location of control file in INITSID.ORA
SQL> startup pfile='/oracle/SID/oracle_home/dbs/initSID.ora';
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 306185108 bytes
Database Buffers 222298112 bytes
Redo Buffers 5844992 bytes
ORA-00214: control file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3253
inconsistent with file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3218
please suggest what should do
regards
It seems that you have control files of different version in the location specified.
This may happen if you have restored your database due to which one of the controlfiles have been modified (eg. /oracle/SID/sapdata1/cntrl/cntrlPRD.dbf) but the other controlfile locations are untouched. (eg. /oracle/SID/saparch/cntrlPRD.dbf)
Also, in such cases after you make changes (copy the new version on control files) please ensure that the old version is renamed or deleted.
Hope this helps.
Regards,
Nilesh J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL> show parameter control_file;
NAME TYPE
-
-
VALUE
-
control_file_record_keep_time integer
30
control_files string
/oracle/PRD/origlogA/cntrl/cntrlPRD.dbf,
/oracle/PRD/origlogB/cntrl/cntrlPRD.dbf,
/oracle/PRD/sapdata10/cntrl/cntrlPRD.dbf
SQL> startup pfile='/oracle/PRD/102_64/dbs/initPRD.ora';
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> STARTUP PFILE='/oracle/PRD/102_64/dbs/initPRD.ora';
ORACLE instance started.
Total System Global Area 1191182336 bytes
Fixed Size 2083496 bytes
Variable Size 603981144 bytes
Database Buffers 570425344 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/oracle/PRD/sapdata10/system_1/system.data1'
ORA-01207: file is more recent than control file - old control file
SQL>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
ORA-01207: ORA-01207 file is more recent than controlfile - old controlfile
Cause: The control file change sequence number in the datafile is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.
Action: Use the current control file or do BACKUP CONTROLFILE RECOVERY to make the control file current. Be sure to follow all restrictions on doing a BACKUP CONTROLFILE RECOVERY.
You must run the RECOVER command after restoring a backup control file, even if no datafiles have been restored.
You must open the database with the RESETLOGS option after performing either complete or point-in-time recovery with a backup control file.
Hope this helps.
Regards,
Deepak Kori
Thanks Marius.Burger
i have followed same steps as u mentioned Earlier.
checked INITSID.ora file all correct location mentioned of controlfile.
SQL> startup mount
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 306185108 bytes
Database Buffers 222298112 bytes
Redo Buffers 5844992 bytes
ORA-00205: error in identifying control file, check alert log for more info
when i checked initSID.ora then found old location of control file
Pls suggest.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Experts,
connected to idle instance
changed in location of control file in INITSID.ORA
SQL> startup pfile='/oracle/SID/oracle_home/dbs/initSID.ora';
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 306185108 bytes
Database Buffers 222298112 bytes
Redo Buffers 5844992 bytes
ORA-00214: control file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3253
inconsistent with file '/oracle/SID/origlogA/cntrl/cntrlPRD.dbf' version 3218
please suggest what should do
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Furher Log
ALTER DATABASE MOUNT
MMNL started with pid=12, OS id=4432
Wed Nov 16 18:49:19 2011
ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Nov 16 18:49:19 2011
ORA-205 signalled during: ALTER DATABASE MOUNT...
Wed Nov 16 18:49:27 2011
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 4433
Wed Nov 16 18:55:40 2011
Starting ORACLE instance (normal)
Wed Nov 16 18:55:40 2011
Specified value of sga_max_size is too small, bumping to 1191182336
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
Version: 10.2.0.4.0.
ALTER DATABASE MOUNT
Wed Nov 16 18:26:27 2011
ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Wed Nov 16 18:26:27 2011
ORA-205 signalled during: ALTER DATABASE MOUNT...
Wed Nov 16 18:27:46 2011
Shutting down instance (abort)
License high water mark = 1
Instance terminated by USER, pid = 4328
Wed Nov 16 18:49:18 2011
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Wed Nov 16 18:49:19 2011
> ORA-00202: control file: '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf'
> ORA-27037: unable to obtain file status
> Linux-x86_64 Error: 2: No such file or directory
> Additional information: 3
Does control file present at location '/oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf' ?
Thanks
Sunny
Thanks,LOG of alert_SID.log control_files = /oracle/PRD/origlogA/cntrl/cntrlPRD.dbf, /oracle/PRD/origlogB/cntrl/cntrlPRD.dbf, /oracle/PRD/sapdata1/cntrl/cntrlPRD.dbf, control_file_record_keep_time= 30, Mon Nov 14 08:24:52 2011
CREATE DATABASE PRD CONTROLFILE REUSE MAXLOGFILES 255 MAXLOGMEMBERS 3 MAXLOGHISTORY 1000 MAXDATAFILES 254 MAXINSTANCES 50 NOARCHIVELOG CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 DATAFILE '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M EXTENT MANAGEMENT LOCAL DEFAULT TEMPORARY TABLESPACE PSAPTEMP TEMPFILE '/oracle/PRD/sapdata1/temp_1/temp.data1' SIZE 570M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M SYSAUX DATAFILE '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
LOGFILE GROUP 1 ('/oracle/PRD/origlogA/log_g11m1.dbf',
'/oracle/PRD/mirrlogA/log_g11m2.dbf') SIZE 50M REUSE ,GROUP 2 ('/oracle/PRD/origlogB/log_g12m1.dbf',
'/oracle/PRD/mirrlogB/log_g12m2.dbf') SIZE 50M REUSE ,GROUP 3 ('/oracle/PRD/origlogA/log_g13m1.dbf',
'/oracle/PRD/mirrlogA/log_g13m2.dbf') SIZE 50M REUSE ,GROUP 4 ('/oracle/PRD/origlogB/log_g14m1.dbf',
'/oracle/PRD/mirrlogB/log_g14m2.dbf') SIZE 50M REUSEMon Nov 14 08:24:53 2011Database mounted in Exclusive Mode
Mon Nov 14 08:25:06 2011Successful mount of redo thread 1, with mount id 1830841300
Assigning activation ID 1830841300 (0x6d206bd4) Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /oracle/PRD/origlogA/log_g11m1.dbf
Current log# 1 seq# 1 mem# 1: /oracle/PRD/mirrlogA/log_g11m2.dbf,m Successful open of redo thread 1
Mon Nov 14 08:25:06 2011 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Nov 14 08:25:06 2011 SMON: enabling cache recovery
Mon Nov 14 08:25:06 2011
create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL online
Mon Nov 14 08:25:09 2011
Incremental checkpoint up to RBA [0x1.3.0], current log tail at RBA [0x1.3.0]
Mon Nov 14 08:25:15 2011
Completed: create tablespace SYSTEM datafile '/oracle/PRD/sapdata1/system_1/system.data1' SIZE 350M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL online
Mon Nov 14 08:25:15 2011
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Mon Nov 14 08:25:19 2011
CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Mon Nov 14 08:25:36 2011
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE PSAPUNDO DATAFILE '/oracle/PRD/sapdata1/undo_1/undo.data1' SIZE 700M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
Mon Nov 14 08:25:36 2011
create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
Completed: create tablespace SYSAUX datafile '/oracle/PRD/sapdata1/sysaux_1/sysaux.data1' SIZE 200M REUSE AUTOEXTEND ON NEXT 20M MAXSIZE 10000M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO online
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Deepak for Reply
Earlier
i have startup database in Mount state
SQL> alter system backup controlfile to trace
checked path of each datafile is correct in the trace file.
I have converted sapdata1 to sapdata10 and checked in InitSID.ora file first location of control file is picking old sapdata file.
rest of the 2 control file location is correct.
Steps to Create Control file
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "QAS" NORESETLOGS ARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 3
MAXDATAFILES 254
MAXINSTANCES 50
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ('/oracle/SID/origlogA/log_g11m1.dbf','/oracle/QAS/mirrlogA/log_g11m2.dbf') SIZE 75M,
STANDBY LOGFILE
DATAFILE
'/oracle/SID/sapdata10/system_1/system.data1'
'/oracle/SID/sapdata10/undo_1/undo.data1'
'/oracle/SID/sapdata10/sysaux_1/sysaux.data1'
'/oracle/SID/sapdata20/sr3_1/sr3.data1'
'/oracle/SID/sapdata20/sr3_2/sr3.data2'
'/oracle/SID/sapdata20/sr3_3/sr3.data3'
'/oracle/SID/sapdata20/sr3_4/sr3.data4'
'/oracle/SID/sapdata20/sr3_5/sr3.data5'
'/oracle/SID/sapdata20/sr3_6/sr3.data6'
'/oracle/SID/sapdata20/sr3_7/sr3.data7'
'/oracle/SID/sapdata20/sr3_8/sr3.data8'
'/oracle/SID/sapdata20/sr3_9/sr3.data9'
'/oracle/SID/sapdata20/sr3_10/sr3.data10'
'/oracle/SID/sapdata30/sr3701_1/sr3701.data1'
'/oracle/SID/sapdata30/sr3701_2/sr3701.data2'
'/oracle/SID/sapdata30/sr3701_3/sr3701.data3'
'/oracle/SID/sapdata30/sr3701_4/sr3701.data4'
'/oracle/SID/sapdata40/sr3usr_1/sr3usr.data1'
'/oracle/SID/sapdata40/sr3db_1/sr3db.data1'
'/oracle/SID/sapdata40/sr3db_2/sr3db.data2'
'/oracle/SID/sapdata40/sr3db_3/sr3db.data3'
CHARACTER SET UTF8
;
i execute these steps same as way to create control file or some changes in that.
Please suggest correct way to create control file.
With Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
>> we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.
How did you performed this operation? You should do this operation with "alter database rename file" command. So, if you didn't execute this command, relocate the datafiles and controlfiles to the old location. Then, open the database respectfully and move datafiles by using the statement, below. After that, shutdown the database again and copy the files physically to the new location. Under this circumstance, if you are able to open the database with the current control files, you don't need to re-create them.
alter database rename file '<source_datafile_full_path>' to '<destination_datafile_full_path>';
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Experts,
>
> we are using Oracle 10g on RHEL5.4 64Bit ecc 6.0 with eph 4 i have moved all my sap data files along with Temp file.
>
> when i startup my database getting error.
You should not move any files manually because control file has location of all files. If you move it manually then control file will not recognize it. This process is not supported.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.