Environment Description:
Source database: 192.168.0.10
Target Database: 192.168.0.11
Source database backup:
RMAN> run {
2> allocate channel c1 device type disk;
3> allocate channel c2 device type disk;
4> backup database format'/home/Oracle/full_database % U' include current controlfile;
5> SQL 'alter system archive log current ';
6> backup archivelog all format'/home/oracle/archivelog _ % U ';
7> crosscheck backup;
8> delete noprompt obsolete;
9> release channel c1;
10> release channel c2;
11>}
Copy the backup set to the slave database:
Scp/home/oracle/full * oracle@192.168.0.11:/home/oracle/target_bk/
Oracle@192.168.0.11:/home/oracle/archive *:/oracle/target_bk/
[Oracle @ targetdb target_bk] $ ls
Archivelog_0rnu4jbf_1_1 full_database0nnu4ja0_1_1 full_database0pnu4jb4_1_1
Archivelog_0snu4jbf_1_1 full_database0onu4ja0_1_1 full_database0qnu4jb5_1_1
Target database operations
[Oracle @ targetdb sourcedb] $ mkdir {a, B, c, u} dump
[Oracle @ targetdb sourcedb] $ ls
Adump bdump cdump udump
[Oracle @ targetdb oradata] $ mkdir sourcedb
[Oracle @ targetdb oradata] $ ls
Sourcedb
[Oracle @ targetdb oradata] $ cd sourcedb/
[Oracle @ targetdb sourcedb] $ mkdir arch
[Oracle @ targetdb sourcedb] $ ls
Arch
Start recovery:
Because no parameter file exists, start with rman with no Parameter
Export ORACLE_SID = sourcedb
RMAN> startup nomount;
Startup failure: ORA-01078: failure in processing system parameters
LRM-00109: cocould not open parameter file '/u01/oracle/product/10.2.0/dbs/initsourcedb. ora'
Starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 1218268 bytes
Variable Size 54528292 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
RMAN> exit
Recovery Manager complete.