====Configuration of the Destination====
After the backup files have been copied, then we have to perform duplication as follows:
Ensure that the database is dropped and started in NOMOUNT state
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup mount exclusive restrict
ORACLE instance started.
Total System Global Area 1.0689E+10 bytes
Fixed Size 2237776 bytes
Variable Size 6241127088 bytes
Database Buffers 4429185024 bytes
Redo Buffers 16924672 bytes
Database mounted.
SQL> drop database;
After that the SPFILE/PFILE should be modified so it will reflect the replica server and the database started in NOMOUNT mode:
SQL> startup pfile='/home/oracle/textpfile' nomount;
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 2298479800 bytes
Database Buffers 1962934272 bytes
Redo Buffers 12132352 bytes
From the recovery Manager, duplicate the database using the backups which were copied:
Recovery Manager: Release 11.2.0.3.0 - Production on Fri May 27 16:10:49 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to auxiliary database: FINEXPRO (not mounted)
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
RMAN> RUN {
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE DISK;
duplicate database to destinSRV backup location "/home/oracle"
NOFILENAMECHECK ;
}
/
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 27-MAY-16
released channel: c1