Media Recovery

[robby]

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

[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

[anandkl]

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

[rajabalachandra]

what is the logic of step

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

[rajabalachandra]

i did

alter database rename datafile ....

instead of

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


it did not ask for media recovery.


-Raja

[anandkl]

probably,
he must be mentioning of
alter database recover datafile 'datafile name';

regards
anandkl

[chao_ping]

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