-
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
-
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
-
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
-
what is the logic of step
3.a . RECOVER DATAFILE 'disk1/users01.dbf'
-
i did
alter database rename datafile ....
instead of
Alter tablespace users rename datafile 'disk1/users01.dbf'
it did not ask for media recovery.
-Raja
-
probably,
he must be mentioning of
alter database recover datafile 'datafile name';
regards
anandkl
anandkl
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|