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 »
  • 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/


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

  1. Nick said

    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

    • 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


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

    Gitesh Trivedi

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 )

Connecting to %s

%d bloggers like this: