| Duplicating a Database with RMAN [message #583858] |
Mon, 06 May 2013 03:07  |
 |
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  |
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 ;
}
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
