Home » RDBMS Server » Backup & Recovery » Media Recovery
Media Recovery [message #258181] Fri, 10 August 2007 08:48 Go to next message
balaji1482
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??

Regards,
Balaji

[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
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
use command
recover database ;
or
recover database until cancel
cancel
Previous Topic: block recovery
Next Topic: backup strategy
Goto Forum:
  


Current Time: Tue May 14 22:16:59 CDT 2024