Oracle11 tablespace dbf File migration, oracle11dbf

Oracle11 tablespace dbf File migration, oracle11dbf

When the disk space of the oracle data file is insufficient or the dbf file needs to be migrated to another location in other cases, the procedure is as follows:

1. sqlplus sys/sys as sysdba

2. shutdown immediate

3. copy the dbf file to a new location.

4. startup mount;

5. alter database rename file 'e: \ oracle \ oradata \ hqbi \ efmweb03.dbf' to 'G: \ oradata \ hqbi \ efmweb03.dbf ';

The first file is the dbf file of the original tablespace, and the second is the new location.

6. alter database open;

7. If the following error is reported:

Row 3 has an error:
ORA-01113: file 9 requires media recovery
ORA-01110: data file 9: 'G: \ ORADATA \ HQBI \ efmweb03.dbf'

Run the following statement:

Recover datafile 'G: \ oradata \ hqbi \ efmweb03.dbf ';

 

Done!

 

Oracle10g for importing tablespace data dbf Files

It is not possible to simply back up the physical files of a tablespace. It is best to back up the exported files or rman files.
If you back up all data files, control files, parameter files, and password files, you can restore them.

Oracle tablespace cold migration

Place the tablespace In the offline-> move the tablespace file-> rename the tablespace file to the new location-> recover tablespace-> put the tablespace online
If you do not know the commands for each step, you can ask me if I have been online for a long time.