RMAN recovery in another host and renaming DBNAME
Precaution: ----------- 1. Be sure that your oracle user on destination host is owned by "dba" secondary group and "oinstall" primary group other wise you will get RMAN-04005: error from target database: ORA-01031: insufficient privileges 2. Create a password file Steps to restoration: --------------------- ----- untar the file containing backup pieces tar -zxvf /app/u02/oradata/full_rman_backup_190911.tar.gz copy all archivelog (near date of full backup) to archiveloglocation ----- mount the database with control file export ORACLE_SID=orcl rman target / nocatalog set dbid xxxxxxxxx startup nomount pfile='/app/u01/oracle/product/10.2.0/db_1/dbs/initorcl.ora' restore controlfile from '/app/u03/oradata/full_rman_backup_190911/o1_mf_s_762246924_77f5xflw_.bkp'; alter database mount; ---- check the datafile, logfile information and find the scn number sqlplus / as sysdba select group#, to_char(first_change#), status, archived from v$log order ...