Databases Reference
In-Depth Information
SQL> alter tablespace users read only;
Tablespace altered.
SQL> alter tablespace example read only;
Tablespace altered.
SQL>
3.
Create a directory to store the converted data files. You'll specify this directory with the
format
command in the next step when you convert the data files.
$ mkdir /tmp/transport_Solaris
4.
Connect to the source database as the target from RMAN and run the
convert tablespace
command to convert the data files that belong to the two tablespaces (
users
and
example
)
into the endian format of the destination host.
RMAN> convert tablespace users,example
2> to platform 'Solaris[tm] OE (64-bit)'
3> format '/tmp/transport_Solaris/%U';
Starting conversion at source at 25-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=54 device type=DISK
channel ORA_DISK_1: starting datafile conversion
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/example01.dbf
converted datafile=/tmp/transport_Solaris/data_D-ORCL_I-1316762630_TS-EXAMPLE_FNO-2_9dnokrhi
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile conversion
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/users01.dbf
converted datafile=/tmp/transport_Solaris/data_D-ORCL_I-1316762630_TS-USERS_FNO-6_9enokrj1
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:00:03
Finished conversion at source at 25-NOV-12
RMAN>
You now have the set of converted data files in the
/tmp/transport_Solaris
directory. The data will be in the
correct endian format for the Solaris (64-bit) platform.
5.
On the source database, use Data Pump to create the dump file for the two tablespaces:
users
and
example
.
6.
Using an OS utility, move the converted data files and the export dump file to a directory
on the destination server.
7.
Use Data Pump import to plug the new tablespaces into the destination database.
8.
Place the transported tablespaces into the read/write mode.
