Real Application Testing - Expert Oracle RAC Performance Diagnostics and Tuning - page 129

2. Verify against transport_set_Violations if there are errors.

SQL> SELECT * FROM TRANSPORT_SET_VIOLATIONS;

3. Convert the tablespace to be transported to read only.

SQL> ALTER TABLESPACE RAPTEST READ ONLY;

4. Verify if the change made to the tablespace in the previous step has been completed

successfully.

SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM DBA_TABLESPACES WHERE TABLESPACE_
NAME ='RAPTEST';
TABLESPACE_NAME STATUS CONTENTS
------------------------------ --------- ---------
RAPTEST READ ONLY PERMANENT

5. Create a directory where all data pump related files are stored. this step is optional; you

could use the default DATA_PUMP_DIR instead.

CREATE DIRECTORY TTS_DIR AS '+OBITST_DATA';

6. Verify the parameter change.

SQL> COL OWNER FORMAT A10
SQL> COL DIRECTORY_NAME FORMAT A12
SQL> COL DIRECTORY_PATH FORMAT A35
SQL> SELECT * FROM DBA_DIRECTORIES;

7. invoke the oracle Data pump export utility as user system and specify the tablespaces in the

transportable set.

SQL>host bash-3.2$ expdp system dumpfile=expdat.dmp directory=TTS_DIR transport_
tablespaces=raptest transport_full_check=y logfile=tts_export.log

8. Using rMan, convert the datafile and store it into asM. although we don't have any real

conversion required, this is the method to create a new datafile in the same database or a
different database.

bash-3.2$ rman target/
RMAN> convert tablespace raptest format '+OBITST_DATA/obitst/datafile/raptest01.dbf';
Starting conversion at source at 07-MAR-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile conversion
input datafile file number=00038 name=+OBITST_DATA/obitst/datafile/
raptest.321.70739082 7
converted datafile=+OBITST_DATA/obitst/datafile/raptest01.dbf
channel ORA_DISK_1: datafile conversion complete, elapsed time: 00:07:45
Finished conversion at source at 07-MAR-11
RMAN> exit
bash-3.2$ exit (return to SQL plus)