-- Set user and ORACLE_SID
su - oracle
set ORACLE_SID=TARGETDB
sqlplus / as sysdba
SQL> shutdown abort
-- open host terminal
host
-- remove all database fiels (include redo and controlfiles)
rm -rf /ORACLE_DATA/*
-- exit to sql
exit
SQL> startup nomount
rman target sys/password@SOURCEDB catalog rman/rman@rman_catalog AUXILIARY sys/password log /tmp/dupl_src_trg_date.log
RUN
{
ALLOCATE AUXILIARY CHANNEL newdb1 DEVICE TYPE sbt;
DUPLICATE TARGET DATABASE TO TARGETDB UNTIL TIME "TO_DATE('20.12.2012 15:00:00','DD.MM.YYYY HH24:MI:SS')"
DB_FILE_NAME_CONVERT=('/ORACLE_DATA/SOURCEDB/','/ORACLE_DATA/TARGETDB/')
LOGFILE
GROUP 1 ('/ORACLE_DATA/TARGETDB/log1a.rdo',
'/ORACLE_DATA/TARGETDB/log1b.rdo') SIZE 100M,
GROUP 2 ('/ORACLE_DATA/TARGETDB/log2a.rdo',
'/ORACLE_DATA/TARGETDB/log2b.rdo') SIZE 100M,
GROUP 3 ('/ORACLE_DATA/TARGETDB/log3a.rdo',
'/ORACLE_DATA/TARGETDB/log3b.rdo') SIZE 100M,
GROUP 4 ('/ORACLE_DATA/TARGETDB/log4a.rdo',
'/ORACLE_DATA/TARGETDB/log4b.rdo') SIZE 100M;
}
ALTER TABLESPACE TEMP ADD TEMPFILE ''/ORACLE_DATA/TARGETDB/temp.dbf' SIZE 1000M REUSE AUTOEXTEND OFF;