Levicorp's WebNote Moving into http://levicorp.com

Just another web note

  • Hear This

    Radio Rodja 756 AM
  • October 2009
    M T W T F S S
    « Jul   Apr »
     1234
    567891011
    12131415161718
    19202122232425
    262728293031  
  • Advertisements

Move or Rename the Datafile in Oracle

Posted by Admin on October 12, 2009

Sorry, I am moving into http://levicorp.com/2009/10/12/move-or-rename-the-datafile/

Advertisements

3 Responses to “Move or Rename the Datafile in Oracle”

  1. Nick said

    Hello
    i have a question about last point when i put only the datafile offline and after the rename i have to do the recovery of datafile.
    what happens if in the meanwhile there is a switch of logfile ? i think that the recovery looks for the redo log online….and if it switches and go in offline redolog.how it brings the information for the recovery? is it a wrong question? let me know
    thanks
    Nick

    • levicorp said

      Hi Nick,
      Sorry for late reply. Thanks for your question. Remember, before you do datafile offline, your database should be in Archievelog mode. You can recover that datafile even the redolog switch many times.

  2. dbametrix said

    Hi,

    Very interesting. Nice article and discussion.
    Thanks a lot for same.

    Regards,
    Gitesh Trivedi
    http://www.dbametrix.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

 
%d bloggers like this: