| ORA-00313, ORA-00312 & ORA-07360 [message #62803] |
Mon, 16 August 2004 04:02  |
Martin Marchant
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
Help!
I am trying to load an oracle db that hasn't been used in ages. When I load it I get the errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/prod/orardo1/lynxtr1/log1a.rdo'
ORA-07360: sfifi: stat error, unable to obtain information about file.
NCR System 3000 Error: 2: No such file or directory
I have checked and the files do not exist anymore. They are also not backed up. How can I recreate them? I don't care about the data in this oracle db as once the system is open/up i'm going to import the data from another system export.
We are on Oracle 7.3.2.2.0
Any help would be much appreciated as i've got to get this system up asap.
Ta v much, Martin
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62807 is a reply to message #62803] |
Mon, 16 August 2004 20:50  |
satyajit das
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
hi
first tell me do u have multiplexed the log files ??. i think since the logfile is named as log1a.rdo there may be some other logfiles named as log1b.rdo or something else ??? please make a copy of u'r existing logfile and rename it as log1a.rdo and place it in /prod/orardo1/lynxtr1 directory.
after that do the following steps:
1. startup mount
2. recover database
3. alter database open
4. alter database resetlogs
this should work for u
thanxs
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62809 is a reply to message #62807] |
Mon, 16 August 2004 22:51 |
Martin Marchant
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
Hi Satyajit
I don't use Oracle enough to be an expert but we should have four files (log1a.rdo, log1b.rdo, log1c.rdo & log1d.rdo). They cycle round every half an hour. All four logs are missing.
I 'borrowed' the four logs from another of our systems to see if could use them but when I do the recover database I get the error:
ORA-00283: Recovery session canceled due to errors
ORA-00305: log 1 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 1 thread 1: '/prod/orardo1/lynxtr1/log1a.rdo'
Cheers
Martin
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62810 is a reply to message #62809] |
Mon, 16 August 2004 23:33 |
satyajit das
Messages: 12
Registered: August 2004
|
Junior Member |
|
|
hi martin
do one thing
1. at first start the databse in nomount mode using this command
sql > startup nomount
2. then backup the control file using
sql> alter database backup controlfile to trace;
3. this will generate a trace file in udump directory. edit that trace file . i am giving u a sample file. u will also get this file in udump directory.
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "<database_name>" RESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 1000
MAXINSTANCES 2
MAXLOGHISTORY 226
-- here u define the path of all u'r redolog files
LOGFILE
GROUP 1 '<redologfile path>' SIZE <user_defined>,
-- here u define the path of all datafile
DATAFILE
'<datfile path>'
CHARACTER SET US7ASCII
;
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE
# Database can now be opened normally.
ALTER DATABASE OPEN;
# No tempfile entries found to add.
try to match u'r trace file with this sample file
4. after that save this file with .sql extension i,e. ctrl.sql
5. after that run this file from svrmgrl prompt... this will recreate u'r database as well as u'r redologs... this should help u out
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62815 is a reply to message #62810] |
Tue, 17 August 2004 03:52 |
Martin Marchant
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
Thanks for that Satyajit but afraid i'm still getting problems.
The startup nomount works fine but when i try the alter database backup controlfile to trace command I get the error 'ORA-01507: database not mounted'.
If I try to use sqlplus I get the error 'ORA-01033: ORACLE initialisation or shutdown in progress' when I try to login.
Any thoughts?
Cheers
Martin
|
|
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62835 is a reply to message #62824] |
Wed, 18 August 2004 07:27 |
Martin Marchant
Messages: 9
Registered: August 2004
|
Junior Member |
|
|
Hi Satyajit
Thanks for your help.
It still didn't work so I got frustrated and used the create database command to completely trash the old system and set up a new.
I'm now trying to do a full database export from another oracle system into my new blank db and I am now getting all sorts of errors to do with tablespaces/users not being available. I understood that a full database export would have all the necessary stuff in it to repopulate my new database.
Maybe not??!
Martin
|
|
|
|
| Re: ORA-00313, ORA-00312 & ORA-07360 [message #62836 is a reply to message #62835] |
Wed, 18 August 2004 08:08 |
Jagdeep
Messages: 15
Registered: August 2004
|
Junior Member |
|
|
In fact, we should have looked at the v$log table in the begining and could have dropped the concerned logs,make a new one while database was in good condition.
But anyways, I don't think u need to trash the database now. If you were able to open the database, then only think you must be missing is the temporary files which were assigned to set of users before you made the new database.
You need to make temporary tablespace manually with "create tablespace" command and assign it to users.
I hope this should help.
Thanks
Jagdeep.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
