Media Recovery
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Media Recovery

  1. #1
    Join Date
    Feb 2003
    Posts
    24

    Media Recovery

    Hi all,
    I need your help here.

    I need to move the datafile from one disk to another disk.
    So, this is what i did:
    1. Bring the tablespace offline
    2. Move the physical file
    3. Alter tablespace users rename datafile 'disk1/users01.dbf'
    to 'disk2/users01.dbf'
    4. Bring up the tablespace - HERE i got error - require media recovery .

    Can somebody tell me what should i do..

    Please help

    Thanks
    Robby

  2. #2
    Join Date
    Aug 2002
    Posts
    115
    between 3 & 4

    3: Alter tablespace users rename file 'disk1/users01.dbf'
    3.a . RECOVER DATAFILE 'disk1/users01.dbf'
    4.ALTER DATABASE DATAFILE 'disk1/users01.dbf' ONLINE;

    HTH

  3. #3
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    I know these things can be done while DB is up and runing,But it would be fine to do this by MOUNTING the DB and then opening the DB.While opening the DB, oracle will automatically do the RECOVERY and things would be more smooth.

    regards
    anandkl
    anandkl

  4. #4
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    what is the logic of step

    3.a . RECOVER DATAFILE 'disk1/users01.dbf'

  5. #5
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    i did

    alter database rename datafile ....

    instead of

    Alter tablespace users rename datafile 'disk1/users01.dbf'


    it did not ask for media recovery.


    -Raja

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    probably,
    he must be mentioning of
    alter database recover datafile 'datafile name';

    regards
    anandkl
    anandkl

  7. #7
    Originally posted by aspdba
    between 3 & 4

    3: Alter tablespace users rename file 'disk1/users01.dbf'
    3.a . RECOVER DATAFILE 'disk1/users01.dbf'
    4.ALTER DATABASE DATAFILE 'disk1/users01.dbf' ONLINE;

    HTH
    Hi,
    This is wrong.
    Please look at the documentation. It is not needed.
    ALter tablespace offline and move datafiles and online tablespace is ok. Unless he used offline immediate etc.

    Regards
    www.cnoug.org

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width