Oracle creates a user-managed copy database on the same host
The following are some steps:
1. Back up all data files in the primary database (rau), and back up the control files to the tracking files. (Rau is the primary database ).
[Oracle @ source ~] $ Sqlplus/as sysdba
SQL> select instance_name from v $ instance;
INSTANCE_NAME
--------------------------------
Rau
SQL> select name from v $ datafile;
NAME
-------------------------------------------------------------------------
/Home/oracle/oradata/rau/system01.dbf
/Home/oracle/oradata/rau/undotbs01.dbf
/Home/oracle/oradata/rau/sysaux01.dbf
/Home/oracle/oradata/rau/users01.dbf
SQL> alter database begin backup;
Database altered.
SQL> host cp/home/oracle/oradata/rau/*. dbf/home/oracle/duplicate_backup/
SQL> host ls-l/home/oracle/duplicate_backup/
Total 768876
-Rw-r ----- 1 oracle oinstall 251666432 May 6 sysaux01.dbf
-Rw-r ----- 1 oracle oinstall 503324672 May 6 001 system01.dbf
-Rw-r ----- 1 oracle oinstall 20979712 May 6 001 temp01.dbf
-Rw-r ----- 1 oracle oinstall 26222592 May 6 001 undotbs01.dbf
-Rw-r ----- 1 oracle oinstall 5251072 May 6 001 users01.dbf
SQL> alter database end backup;
Database altered.
SQL> alter system archive log current;
System altered.
SQL> alter database backup controlfile to trace resetlogs;
Database altered.