Databases Reference
In-Depth Information
Solution
You create a transportable tablespace set by executing the RMAN command
transport tablespace
. The following
example shows how to transport tablespaces between identical operating system platforms by utilizing RMAN
backups. Here are the steps you must follow to transport tablespaces from one database to another.
1.
Connect to the recovery catalog and to the target database.
RMAN> connect catalog rman@catdb
recovery catalog database Password:
connected to recovery catalog database
RMAN> connect target sysbackup
target database Password:
connected to target database: ORCL (DBID=1316762630)
Generate the transportable tablespace set by issuing the
transport tablespace
command. During a regular (non-RMAN) tablespace transport, you use an operating
system utility, such as the
scp
command, to copy the database files that belong to the
tablespaces in the transportable tablespace set. Here, however, since we're using RMAN to
transport the tablespaces, we use the RMAN backups for this purpose.
2.
RMAN> transport tablespace test2
2> tablespace destination '/u01/app/oracle/oradata/transportdest'
3> auxiliary destination '/u01/app/oracle/oradata/auxdest';
Creating automatic instance, with SID='nFya'
initialization parameters used for automatic instance:
db_name=ORCL
db_unique_name=nFya_pitr_ORCL
compatible=12.0.0.0.0
...
starting up automatic instance ORCL
Oracle instance started
Running TRANSPORT_SET_CHECK on recovery set tablespaces
TRANSPORT_SET_CHECK completed successfully
contents of Memory Script:
{
# set requested point in time
set until scn 2413098;
# restore the controlfile
restore clone controlfile;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log
sql 'alter system archive log current';
