ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

This error most likely occurred when you duplicated a database and the DB_NAME parameter in spfile is not matching the one in the control file. Sometimes it so happened that after duplicating the database name in SPFILE with which you started the instance with is not matching the one in the control file. Explanation: ===================== … Continue reading ORA-01103: database name ‘MW’ in control file is not ‘MWTST’

Restore RMAN to new server and refresh with Archivelog apply

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 … Continue reading Restore RMAN to new server and refresh with Archivelog apply

Cloning Oracle Database 9i, 10g using RMAN in few easy steps.

**************** Cloning of the Oracle Database ******************** On production 1) Make sure controlfile autobackup is on and take the incremental level 0 backup; bash-3.00$ rman Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 23 11:08:48 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. RMAN> connect target / connected to target database: ORCL (DBID=1205560727) … Continue reading Cloning Oracle Database 9i, 10g using RMAN in few easy steps.