Home » RDBMS Server » Backup & Recovery » Duplicating a Database with RMAN (RHEL 6.4)
Duplicating a Database with RMAN [message #583858] Mon, 06 May 2013 03:07 Go to next message
ssadoglu
Messages: 1
Registered: May 2013
Junior Member
Hi,

I would like to duplicate to the different server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database.
My questions are:

Source Server ( target ) : ORACLE_SID : DB11G
AUXILIARY Server (duplicate ): ORACLE_SID : CLONE

1- if backup files (autobackup and backup set)/ Archived Logs are in a different path on the source host (not default FRA Path) then how can I use the DUPLICATE command? BTW, only the flashback logs are in the default location (/u01/app/oracle/fra/flashback). Path: /u01/app/oracle/oradata/DB11G/autobackup and /u01/app/oracle/oradata/DB11G/backupset. Can you please give me all commands?

2 - Do I have to add *_CONVERT parameters for different SID as shown below? e.g : DB_FILE_NAME_CONVERT , LOG_FILE_NAME_CONVERT.

DB11G.__java_pool_size=4194304
DB11G.__large_pool_size=4194304
DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DB11G.__pga_aggregate_target=155189248
DB11G.__sga_target=264241152
DB11G.__shared_io_pool_size=0
DB11G.__shared_pool_size=171966464
DB11G.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/DB11G/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/DB11G/control01.ctl','/u01/app/oracle/oradata/DB11G/control02.ctl'#Restore Controlfile
*.db_block_size=8192
*.db_domain='localdomain'
*.db_flashback_retention_target=720
*.db_name='DB11G'
*.db_recovery_file_dest='/u01/app/oracle/fra'
*.db_recovery_file_dest_size=3221225472
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DB11GXDB)'
*.log_archive_dest_1='location=/u01/app/oracle/archive_logs'
*.log_archive_format='db11g%r_%t_%s.arc'
*.memory_target=417333248
*.open_cursors=3^AC^@^@C"^@^@^D^@^@^@^@^@^@^@^@^@^A^DU^F^@^@00
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'


Thanks in advance,
Re: Duplicating a Database with RMAN [message #584000 is a reply to message #583858] Tue, 07 May 2013 14:28 Go to previous messageGo to next message
gregfury
Messages: 1
Registered: August 2007
Junior Member
You could use RMAN "Active Duplicate" Here is an example:

connect target sys/password@target
connect auxiliary sys/password@aux

run {
    ALLOCATE CHANNEL tgt1 TYPE DISK;
    ALLOCATE CHANNEL tgt2 TYPE DISK;
    ALLOCATE CHANNEL tgt3 TYPE DISK;
    ALLOCATE CHANNEL tgt4 TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL dup1 TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL dup2 TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL dup3 TYPE DISK;
    ALLOCATE AUXILIARY CHANNEL dup4 TYPE DISK;

    DUPLICATE TARGET DATABASE to aux FROM ACTIVE DATABASE NOFILENAMECHECK
    DB_FILE_NAME_CONVERT ('/oradata/target/','/oradata/aux/')
    LOGFILE
      GROUP 1 ('/oradata/aux/redo01.log')  SIZE 150M,
      GROUP 2 ('/oradata/aux/redo02.log')  SIZE 150M,
      GROUP 3 ('/oradata/aux/redo03.log')  SIZE 150M,
      GROUP 4 ('/oradata/aux/redo04.log')  SIZE 150M,
      GROUP 5 ('/oradata/aux/redo05.log')  SIZE 150M ;
}

Re: Duplicating a Database with RMAN [message #584026 is a reply to message #584000] Wed, 08 May 2013 01:20 Go to previous message
forkausar
Messages: 4
Registered: May 2013
Junior Member
You can user RMAN duplicate command.
Following link explain uses of RMAN duplicate command.

http://www.learnoracledatabase.com/rman/duplicating-database-using-rman-duplicate-command

[Updated on: Wed, 08 May 2013 02:05]

Report message to a moderator

Previous Topic: ORA-00314: log 3 of thread 1, expected sequence# 207 doesn't match 198
Next Topic: how to create auxiliary instance
Goto Forum:
  


Current Time: Thu Mar 28 09:51:28 CDT 2024