| No ARCHIVE LOGS and no REDO LOGS.. Can I recover DB? [message #54813] |
Fri, 06 December 2002 09:10  |
sticky72
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
|
This is a variation of the question I asked a few days ago. Lets say I have a 9i database that is in ARCHIVELOG MODE, I have all the datafiles, the control files and the database was shutdown correctly. I DO NOT however have any of the REDO LOG files or the ARCHIVE LOG files. Is it possible to open or recover this database without these log files?
|
|
|
|
| Re: No ARCHIVE LOGS and no REDO LOGS.. Can I recover DB? [message #54817 is a reply to message #54813] |
Fri, 06 December 2002 17:06  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Yes. It's possible.
First, if you shutdown "correctly" (means normal or immediate), you don't need to recover this database. You will be only opening it.
Second, what is in the REDO LOGS?? Commited transactions, right? So if you shutdown immediate your database, there will be no uncommited transactions, right? So why do you think you need the redo logs? Nothing to be read from there. Even Oracle recommends, not to backup the redo logs. However, you will have to create an empty redo log group members, as the control file says:
CREATE CONTROLFILE REUSE DATABASE "DB46" NORESETLOGS ARCHIVELOG
MAXLOGFILES 64
MAXLOGMEMBERS 4
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'C:ORACLEORADATADB46REDO01.LOG',
'E:ORACLEORADATADB46REDO02.LOG'
) SIZE 32M,
GROUP 2 (
'C:ORACLEORADATADB46REDO03.LOG',
'E:ORACLEORADATADB46REDO04.LOG'
) SIZE 32M,
GROUP 3 (
'C:ORACLEORADATADB46REDO05.LOG',
'E:ORACLEORADATADB46REDO06.LOG'
) SIZE 32M,
GROUP 4 (
'C:ORACLEORADATADB46REDO07.LOG',
'E:ORACLEORADATADB46REDO08.LOG'
) SIZE 32M
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
