Re: media recovery [message #50041] |
Mon, 25 February 2002 07:42 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
HI Madhu,
You need to change the database archivelog mode to NOArchive log mode.Then open the database.
Regards
Raj
|
|
|
Re: media recovery [message #50117 is a reply to message #50041] |
Fri, 01 March 2002 07:47 |
C konda Reddy
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Hi friends,
I have the same problem in SCO UNIXWARE 7.0 with ORACLE 8.0. i also got the same message that asking for the archive log file which does not have.
we are not keeping the system in archive mode.
my system is in NOARCHIVE LOG MODE only..but still it is giving same errors what Mr. Madhu mentioned..
it is a live project system.
Pl help me the same..
with regards,
reddy
|
|
|
Re: media recovery [message #50573 is a reply to message #50041] |
Fri, 22 March 2002 01:55 |
Radim
Messages: 5 Registered: March 2002
|
Junior Member |
|
|
Hi,
I had the same situation, fortunately on my test DB.
I did following;
1. alter database noarchivelog;
2. alter database open resetlogs;
3. shutdown immediate;
4. startup mount;
5. alter database archivelog;
6. alter database open;
Nowdays, my test DB works and I'm gonna make another disasters ;)))
Radim
|
|
|