Tuesday, June 2, 2015

RMAN Active Database Duplication

12:14 AM Posted by Mehdi Pourhadi No comments
well for doing the active database duplication there are a few thing you need to check which are as the followings:
  1. Free space
  2. check in your target database pfile that these two lines exist:
  • *.db_file_name_convert='{SOURCEDB_DATAFILE_LOC}','{TARGTDB_DATAFILE_LOC}'
  • *.log_file_name_convert='{SOURCEDB_DATAFILE_LOC}','{TARGTDB_DATAFILE_LOC}'
3. Password on the both side should be the same.
4. ARCHIVELOG mode must be enabled on both sides.
5. both source and destination(target) database servers require “tnsnames.ora” entry.

Enable Archive Log

  • sqlplus / as sysdba
  • SQL> archive log list;
            Database log mode No Archive Mode
            Automatic archival Disabled
            Archive destination USE_DB_RECOVERY_FILE_DEST
            Oldest online log sequence 15
            Current log sequence 17
  • SQL> alter database archivelog;
  • SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 15

Current log sequence 17 

Drop Database using SQL

1. connect to your target database
2. export ORACLE_SID= ${ORACLE_SID} --> for multiple oracle instance
3. sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 23 10:21:34 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
4. SQL> shutdown transactional;
Database closed.
Database dismounted.
ORACLE instance shut down.
5. SQL> startup mount exclusive restrict;
ORACLE instance started.
Total System Global Area 8584982528 bytes
Fixed Size 2253256 bytes
Variable Size 1744834104 bytes
Database Buffers 6677331968 bytes
Redo Buffers 160563200 bytes
Database mounted.
6. SQL> drop database;
Database dropped.
Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
7. SQL> startup nomount;
ORACLE instance started.
Total System Global Area 4776853504 bytes
Fixed Size 2254416 bytes
Variable Size 1258293680 bytes
Database Buffers 3372220416 bytes
Redo Buffers 144084992 bytes
Note : if you can get your database to "startup nomount" try to exit and then login as sys again.

After adding the servers in the tnsnames.ora confirm that they can connect to each other :
  • from the source “tnsping ${auxiliary_database_name}”
  • from the auxiliary “tnsping ${source_database_name}”
in order to be more sure check the password too
  • from the source “sqlplus /nolog”
  • conn sys@${source_database_name}
  • enter password
  • do the same from target database if they can be connected.
Now in the target database do the followings :
  1. rman target sys@${SOURCE_DBNAME} auxiliary sys@${AUXILIARY_DB}
  2. ENTER THE PASSWORDS
  3. after connecting run the following:

duplicate target database to ${ORACLE_SID} from active database nofilenamecheck;

0 comments:

Post a Comment