OraFAQ Forum: Server Administration » rename datafile needs media Recovery

Home » RDBMS Server » Server Administration » rename datafile needs media Recovery (oracle 10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rename datafile needs media Recovery [message #386203]

Fri, 13 February 2009 02:17

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

Report message to a moderator

Re: rename datafile needs media Recovery [message #386204 is a reply to message #386203]

Fri, 13 February 2009 02:19

Michel Cadot
Messages: 68666
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

Report message to a moderator

Re: rename datafile needs media Recovery [message #386205 is a reply to message #386203]

Fri, 13 February 2009 02:22

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

Report message to a moderator

Re: rename datafile needs media Recovery [message #386215 is a reply to message #386205]

Fri, 13 February 2009 03:00

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

No, it does not.

Regards
Michel

Report message to a moderator

Re: rename datafile needs media Recovery [message #386222 is a reply to message #386203]

Fri, 13 February 2009 03:21

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

Report message to a moderator

Re: rename datafile needs media Recovery [message #386225 is a reply to message #386222]

Fri, 13 February 2009 03:25

Michel Cadot
Messages: 68666
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 04:01:13 CDT 2024