Oracle allows you to duplicate a database using specific tablespaces only, .
The command is same as the duplicate command
Mention the tablespace comma separated names (highlighted in bold)
Ofcourse temp, system,sysaux, undo will be duplicated along
rman
connect TARGET sys/passs@PROD;
connect AUXILIARY sys/pass@XDB1_STDBY;
run
{
set newname for database to '+FRA';
DUPLICATE TARGET DATABASE
TO XDB
FROM ACTIVE DATABASE
TABLESPACE users
NOFILENAMECHECK;
}
The command is same as the duplicate command
Mention the tablespace comma separated names (highlighted in bold)
Ofcourse temp, system,sysaux, undo will be duplicated along
- rman run at the new database site
- target is source
- auxiliary is the new db
- list of tablespaces is comma seperated.
- if you want to skip a specific tablespace use 'skip <tablespace_name>'
rman
connect TARGET sys/passs@PROD;
connect AUXILIARY sys/pass@XDB1_STDBY;
run
{
set newname for database to '+FRA';
DUPLICATE TARGET DATABASE
TO XDB
FROM ACTIVE DATABASE
TABLESPACE users
NOFILENAMECHECK;
}
The highlight here is that oracle will internally check during duplicate that if the tablespaces are linked (dependent) or not.
You will have to ensure that static entries is present for the new database in the listener, as it will need to be shut down and started by the rman.
No comments:
Write comments