exadata to non-exadata cloning

 clone
-----------------------
1)
Create init.ora file (example instance name: TPTST)
*._gby_hash_aggregation_enabled=FALSE
*._optimizer_cost_based_transformation='OFF'
*._optimizer_use_feedback=FALSE
*._unnest_subquery=FALSE
*.audit_sys_operations=FALSE
*.audit_trail='NONE'
*.compatible='11.2.0.2.0'
*.control_files='xxxxxxxxxxxxxxxcontrol01.ctl','xxxxxxxxxxxcontrol02.ctl'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_cache_size=750M
*.db_domain=''
*.db_files=1000
*.db_name='TPTST'#Reset to original value by RMAN
*.diagnostic_dest='xxxxxxxxx'
*.large_pool_size=250M
*.log_file_name_convert='xxxxxxx','/u03/','xxxxxxxxxxxx','/u02/'
*.open_cursors=700
*.optimizer_index_caching=99
*.optimizer_index_cost_adj=40
*.optimizer_use_sql_plan_baselines=FALSE
*.parallel_adaptive_multi_user=FALSE
*.parallel_execution_message_size=8384
*.parallel_max_servers=6
*.parallel_min_servers=2
*.pga_aggregate_target=800M
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_limit=TRUE
*.resource_manager_plan='DEFAULT_PLAN'
*.session_cached_cursors=250
*.sga_target=2048M
*.shared_pool_size=700M
*.undo_tablespace='UNDOTBS1'

2)
source oracle_Sid

3)
start DB using init.ora file in nomount state

4)
create spfile from pfile

5)
restart DB using spfile in nomount state

6)
rman auxiliary /

7)
execute below command to create instance.
Check space usage and redirect tablespaces using "set newname for tablespace" clause.


RUN
{
ALLOCATE AUXILIARY CHANNEL c1 DEVICE TYPE disk ;
ALLOCATE AUXILIARY CHANNEL c2 DEVICE TYPE disk ;
SET NEWNAME FOR DATABASE TO '/u04/ORADATA/HREDU/%b';
duplicate database SFNPRD to SFNPRD1 BACKUP LOCATION '/xx/xx/xx'
LOGFILE GROUP 1 ('/xx/xx/xx/redo01.log') SIZE 1G REUSE,
      GROUP 2 ('/xx/xx/xx/redo02.log') SIZE 1G REUSE,
      GROUP 3 ('/xx/xx/xx/redo03.log') SIZE 1G REUSE;
}

8)
mast sensitive data
remove hybrid columanar compression if zfs storage is not available
run appliation specific post clone scripts
drop unwanted undo, temp and redo's

------Active duplicate-----

NOTE:
* make sure to have local_listener parameter in spfile
* make sure listener entries are available in listener.ora in auxiliary and in tnanames.ora in both target and auxiliary

run
{
allocate auxiliary channel a1  device type disk;
allocate auxiliary channel a2  device type disk;
allocate channel a5  device type disk;
allocate channel a6  device type disk;
SET NEWNAME FOR DATABASE TO 'xxxxxxxxxxxxx/%b';
duplicate database to xxxxxxxxxxx from active database;
release channel a1 ;
release channel a2 ;
release channel a5 ;
release channel a6 ;
}