Home » RDBMS Server » Server Administration » rename datafile needs media Recovery (oracle 10.2.0.2)
rename datafile needs media Recovery [message #386203] Fri, 13 February 2009 02:17 Go to next message
osiris
Messages: 3
Registered: February 2009
Location: Austria
Junior Member
Hi,

today i have copied(renamed a datafile with the following steps.
1.) shut down database
2.) copy with dd if= of= bs=1024
3.) startup mount
4.)rename datafile
5.) open database

Why do i need a media recovery on startup for this datfile?
When i startup the DB i get the message "datafile needs media recovery" Shocked
Can anybody tell me why ?

friendly regards

osiris

Re: rename datafile needs media Recovery [message #386204 is a reply to message #386203] Fri, 13 February 2009 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you didn't put it offline.
Just use "recover" and it will be instantaneous.

Regards
Michel
Re: rename datafile needs media Recovery [message #386205 is a reply to message #386203] Fri, 13 February 2009 02:22 Go to previous messageGo to next message
osiris
Messages: 3
Registered: February 2009
Location: Austria
Junior Member
Hi Michael,

do you know, does orace write any data to a datafile when DB is in state "mount" (change numbers or something)

regards

osiris
Re: rename datafile needs media Recovery [message #386215 is a reply to message #386205] Fri, 13 February 2009 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No, it does not.

Regards
Michel
Re: rename datafile needs media Recovery [message #386222 is a reply to message #386203] Fri, 13 February 2009 03:21 Go to previous messageGo to next message
osiris
Messages: 3
Registered: February 2009
Location: Austria
Junior Member
Hi Michel,

and why do i need the media recovery if oracle dosen`t write any data to the datafile in state mount.
I may be worng but i think i need a media recovery only if any thing has chaged between before copy and after copy.
Or whants oracle the media recovery only to be sure everything is consistent if you rename a file without taking the tablespace offline?

regards

osiris
Re: rename datafile needs media Recovery [message #386225 is a reply to message #386222] Fri, 13 February 2009 03:25 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Or whants oracle the media recovery only to be sure everything is consistent if you rename a file without taking the tablespace offline?

Correct.

Regards
Michel
Previous Topic: Why din I see warning threshold in my alert log
Next Topic: Oracle issue
Goto Forum:
  


Current Time: Fri Dec 09 06:05:35 CST 2016

Total time taken to generate the page: 0.11093 seconds