Database Reference
In-Depth Information
USER_DATA_FNO-6_3RJRNU8G
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:01
Finished conversion at source at 21-OCT-13
RMAN>
At this point you can exit from RMAN and return to SQL*Plus; you have a transportable
set that consists of the export dump file and the converted tablespace data file on the local
source system. You can exit to SQL*Plus and return the tablespaces in the transportable set
to read-write mode:
SQL>alter tablespace user_data read write;
Tablespace altered.
SQL>
Step 4: Transport the Tablespace Set
Now you will need to copy the export dump file and data files in the tablespace set to the
target system. If the data files didn't need endian conversion or if you converted the data
files using RMAN on the source system, copy the data files from the source to the target
destination using an operating-system copy utility or FTP binary mode, RMAN, or the
DBMS_FILE_TRANSFER
package. If the files require target-side conversion, copy the files into
the temporary staging directory on the target.
Once you have copied the data files from the source system, you can return to SQL*Plus
on the source and return the tablespaces in the transportable set to read-write mode:
SQL>alter tablespace user_data read write;
Tablespace altered.
SQL>
If the files do not need conversion, move on to step 5 at this time. If the data files require
target-side endian conversion, invoke RMAN to perform the conversion, as in this example:
RMAN> CONVERT DATAFILE
'/orastage/user_data01.dbf'
TO PLATFORM="Solaris[tm] OE (32-bit)"
FROM PLATFORM="Microsoft Windows IA (32-bit)"
DB_FILE_NAME_CONVERT="/oracle/oradata/LNEB/";
Now that the data files are converted locally and in the correct target destination, you
can move on to step 5.
Step 5: Import the Tablespace Set
As mentioned in an earlier note, either the transportable tablespace's block size must match
the standard block size of the target database or the target database must have a cache con-
figured for the same block size as the transportable set.
Search WWH ::
Custom Search