Source Database
--------------- ::: Directory Structure ::: ORACLE_HOME : E:\oracle\product\10.2.0\db_1 RMAN Backup : E:\rman_backup_full Control Files : E:\oradata\ecc DataFiles: E:\oradata\ECC Archivelog Destination: E:\archivelogs adump : e:\oracle\product\10.2.0\admin\ecc\adump bdump : e:\oracle\product\10.2.0\admin\ecc\bdump cdump : e:\oracle\product\10.2.0\admin\ecc\cdump udump : e:\oracle\product\10.2.0\admin\ecc\udump
1.
create pfile='E:\eccprod.ora' from spfile;
2.
rman target / backup incremental level 0 TAG 'ECC_DAILY_FULL' database filesperset 4; backup archivelog all not backed up 1 times; exit;
3. Copy RMAN backup files and pfile to Target Database directory in same structure
Target Database
--------------- ::: Directory Structure ::: ORACLE_HOME : E:\oracle\product\10.2.0\db_1 Control Files : E:\oradata\ecc RMAN Backup : E:\rman_backup_full DataFiles: E:\oradata\ECC Archivelog Destination: E:\archivelogs adump : e:\oracle\product\10.2.0\admin\ecc\adump bdump : e:\oracle\product\10.2.0\admin\ecc\bdump cdump : e:\oracle\product\10.2.0\admin\ecc\cdump udump : e:\oracle\product\10.2.0\admin\ecc\udump Make sure RMAN directory structure and Datafiles and Control Files Directory structure is identical as Source DB server else you have to use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT parameters 1. Create required folders in the Target database server adump bdump cdump udump Control File Location Datafile Location Archivelog Location RMAN backup location ------ |PFILE | ------ ecc.__db_cache_size=1342177280 ecc.__java_pool_size=8388608 ecc.__large_pool_size=8388608 ecc.__shared_pool_size=226492416 ecc.__streams_pool_size=16777216 *.audit_file_dest='e:\oracle\product\10.2.0\admin\ecc\adump' *.background_dump_dest='e:\oracle\product\10.2.0\admin\ecc\bdump' *.compatible='10.2.0.5.0' *.control_files='e:\oradata\ecc\control01.ctl','e:\oradata\ecc\control02.ctl','e:\oradata\ecc\control03.ctl' *.core_dump_dest='e:\oracle\product\10.2.0\admin\ecc\cdump' *.db_16k_cache_size=67108864 *.db_block_size=8192 *.db_domain='' *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT='eccstandby','ecc' *.db_name='ecc' *.DB_UNIQUE_NAME='ecc' *.dispatchers='(PROTOCOL=TCP) (SERVICE=eccXDB)' *.FAL_CLIENT='ecc' *.FAL_SERVER='eccstandby' *.global_names=TRUE *.INSTANCE_NAME='ecc' *.job_queue_processes=20 *.LOG_ARCHIVE_CONFIG='DG_CONFIG=(ecc,eccstandby)' *.LOG_ARCHIVE_DEST_1='LOCATION=E:\archivelogs VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ecc' *.log_archive_dest_2='SERVICE=eccstandby LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=eccstandby' *.log_archive_dest_state_1='enable' *.log_archive_dest_state_2='ENABLE' *.LOG_ARCHIVE_FORMAT='log%t_%s_%r.arc' *.LOG_FILE_NAME_CONVERT='ecc','eccstandby' *.open_cursors=700 *.OPTIMIZER_INDEX_COST_ADJ=30 *.pga_aggregate_target=364904448 *.processes=250 *.REMOTE_LOGIN_PASSWORDFILE='EXCLUSIVE' *.SERVICE_NAMES='ecc' *.session_cached_cursors=100 *.sessions=280 *.sga_max_size=1677721600 *.sga_target=1677721600 *.STANDBY_FILE_MANAGEMENT='AUTO' *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1' *.user_dump_dest='e:\oracle\product\10.2.0\admin\ecc\udump'
2. Create a service using oradim (if on windows) or with the pfile startup database in nomount mode
oradim -NEW -SID ecc -SYSPWD sys123 -STARTMODE auto -PFILE e:\eccprod.ora
3. Restore Database
rman target / restore database ;
4. Now copy the new archivelogs to the archivelog directory and do recovery
rman target / RMAN> catalog start with 'E:\archivelogs'; searching for all files that match the pattern E:\archivelogs List of Files Unknown to the Database ===================================== File Name: E:\archivelogs\LOG1_53601_781008485.ARC File Name: E:\archivelogs\LOG1_53602_781008485.ARC File Name: E:\archivelogs\LOG1_53603_781008485.ARC File Name: E:\archivelogs\LOG1_53604_781008485.ARC File Name: E:\archivelogs\LOG1_53605_781008485.ARC File Name: E:\archivelogs\LOG1_53606_781008485.ARC File Name: E:\archivelogs\LOG1_53607_781008485.ARC File Name: E:\archivelogs\LOG1_53608_781008485.ARC File Name: E:\archivelogs\LOG1_53609_781008485.ARC File Name: E:\archivelogs\LOG1_53610_781008485.ARC File Name: E:\archivelogs\LOG1_53611_781008485.ARC File Name: E:\archivelogs\LOG1_53612_781008485.ARC File Name: E:\archivelogs\LOG1_53613_781008485.ARC File Name: E:\archivelogs\LOG1_53614_781008485.ARC File Name: E:\archivelogs\LOG1_53615_781008485.ARC File Name: E:\archivelogs\LOG1_53616_781008485.ARC File Name: E:\archivelogs\LOG1_53617_781008485.ARC File Name: E:\archivelogs\LOG1_53618_781008485.ARC File Name: E:\archivelogs\LOG1_53619_781008485.ARC File Name: E:\archivelogs\LOG1_53620_781008485.ARC File Name: E:\archivelogs\LOG1_53621_781008485.ARC File Name: E:\archivelogs\LOG1_53622_781008485.ARC File Name: E:\archivelogs\LOG1_53623_781008485.ARC File Name: E:\archivelogs\LOG1_53624_781008485.ARC File Name: E:\archivelogs\LOG1_53625_781008485.ARC File Name: E:\archivelogs\LOG1_53626_781008485.ARC File Name: E:\archivelogs\LOG1_53627_781008485.ARC File Name: E:\archivelogs\LOG1_53628_781008485.ARC File Name: E:\archivelogs\LOG1_53629_781008485.ARC File Name: E:\archivelogs\LOG1_53630_781008485.ARC File Name: E:\archivelogs\LOG1_53631_781008485.ARC File Name: E:\archivelogs\LOG1_53632_781008485.ARC File Name: E:\archivelogs\LOG1_53633_781008485.ARC File Name: E:\archivelogs\LOG1_53634_781008485.ARC File Name: E:\archivelogs\LOG1_53635_781008485.ARC File Name: E:\archivelogs\LOG1_53636_781008485.ARC File Name: E:\archivelogs\LOG1_53637_781008485.ARC Do you really want to catalog the above files (enter YES or NO)? cataloging files... cataloging done List of Cataloged Files ======================= File Name: E:\archivelogs\LOG1_53601_781008485.ARC File Name: E:\archivelogs\LOG1_53602_781008485.ARC File Name: E:\archivelogs\LOG1_53603_781008485.ARC File Name: E:\archivelogs\LOG1_53604_781008485.ARC File Name: E:\archivelogs\LOG1_53605_781008485.ARC File Name: E:\archivelogs\LOG1_53606_781008485.ARC File Name: E:\archivelogs\LOG1_53607_781008485.ARC File Name: E:\archivelogs\LOG1_53608_781008485.ARC File Name: E:\archivelogs\LOG1_53609_781008485.ARC File Name: E:\archivelogs\LOG1_53610_781008485.ARC File Name: E:\archivelogs\LOG1_53611_781008485.ARC File Name: E:\archivelogs\LOG1_53612_781008485.ARC File Name: E:\archivelogs\LOG1_53613_781008485.ARC File Name: E:\archivelogs\LOG1_53614_781008485.ARC File Name: E:\archivelogs\LOG1_53615_781008485.ARC File Name: E:\archivelogs\LOG1_53616_781008485.ARC File Name: E:\archivelogs\LOG1_53617_781008485.ARC File Name: E:\archivelogs\LOG1_53618_781008485.ARC File Name: E:\archivelogs\LOG1_53619_781008485.ARC File Name: E:\archivelogs\LOG1_53620_781008485.ARC File Name: E:\archivelogs\LOG1_53621_781008485.ARC File Name: E:\archivelogs\LOG1_53622_781008485.ARC File Name: E:\archivelogs\LOG1_53623_781008485.ARC File Name: E:\archivelogs\LOG1_53624_781008485.ARC File Name: E:\archivelogs\LOG1_53625_781008485.ARC File Name: E:\archivelogs\LOG1_53626_781008485.ARC File Name: E:\archivelogs\LOG1_53627_781008485.ARC File Name: E:\archivelogs\LOG1_53628_781008485.ARC File Name: E:\archivelogs\LOG1_53629_781008485.ARC File Name: E:\archivelogs\LOG1_53630_781008485.ARC File Name: E:\archivelogs\LOG1_53631_781008485.ARC File Name: E:\archivelogs\LOG1_53632_781008485.ARC File Name: E:\archivelogs\LOG1_53633_781008485.ARC File Name: E:\archivelogs\LOG1_53634_781008485.ARC File Name: E:\archivelogs\LOG1_53635_781008485.ARC File Name: E:\archivelogs\LOG1_53636_781008485.ARC File Name: E:\archivelogs\LOG1_53637_781008485.ARC RMAN> recover database; Starting recover at 18-FEB-18 using channel ORA_DISK_1 starting media recovery archive log thread 1 sequence 53636 is already on disk as file E:\ARCHIVELOGS\LO G1_53636_781008485.ARC archive log thread 1 sequence 53637 is already on disk as file E:\ARCHIVELOGS\LO G1_53637_781008485.ARC archive log filename=E:\ARCHIVELOGS\LOG1_53636_781008485.ARC thread=1 sequence=5 3636 archive log filename=E:\ARCHIVELOGS\LOG1_53637_781008485.ARC thread=1 sequence=5 3637 unable to find archive log archive log thread=1 sequence=53638 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/18/2018 16:04:01 RMAN-06054: media recovery requesting unknown log: thread 1 seq 53638 lowscn 857 961236 RMAN>
Database is now in incomplete recovery, after new archivelogs are generated do recovery again. You can keep doing this till you are ready to open database with resetlogs and startup in mount mode
rman target / RMAN> catalog start with 'E:\archivelogs'; RMAN> recover database; Starting recover at 18-FEB-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=269 devtype=DISK starting media recovery archive log thread 1 sequence 53638 is already on disk as file E:\ARCHIVELOGS\LO G1_53638_781008485.ARC archive log thread 1 sequence 53639 is already on disk as file E:\ARCHIVELOGS\LO G1_53639_781008485.ARC archive log filename=E:\ARCHIVELOGS\LOG1_53638_781008485.ARC thread=1 sequence=5 3638 archive log filename=E:\ARCHIVELOGS\LOG1_53639_781008485.ARC thread=1 sequence=5 3639 unable to find archive log archive log thread=1 sequence=53640 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of recover command at 02/18/2018 17:03:52 RMAN-06054: media recovery requesting unknown log: thread 1 seq 53640 lowscn 857 981603 RMAN> alter database open resetlogs; database opened RMAN> list incarnation; ist of Database Incarnations B Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time ------ ------- -------- ---------------- --- ---------- ---------- 1 ECC 1040999203 PARENT 1 07-JUL-10 2 ECC 1040999203 PARENT 583052 19-APR-12 3 ECC 1040999203 CURRENT 857981604 18-FEB-18