Home » RDBMS Server » Backup & Recovery » Media Recovery
Media Recovery [message #258181] Fri, 10 August 2007 08:48 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

when i used startup command to up my database on oracle9i on windows i found this error,

ora-01589 : must use RESETLOGS or NORESETLOGS option for database open .

then i tried the following command

alter database open resetlogs

ora-01113: file 1 needs media recovery
ora-01110 : data file 1 : 'D:bala\data\system1.dbf'

kindly help me to up my database without error??


[Updated on: Fri, 10 August 2007 08:50]

Report message to a moderator

Re: Media Recovery [message #258210 is a reply to message #258181] Fri, 10 August 2007 10:16 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
use command
recover database ;
recover database until cancel
Previous Topic: block recovery
Next Topic: backup strategy
Goto Forum:

Current Time: Wed Jul 26 09:58:29 CDT 2017

Total time taken to generate the page: 0.24346 seconds