ORA-01103: database name 'ORCLDG' in control file is not 'ORCL'
今天關閉使用rman複製資料庫再重新開啟時出現這個錯誤“ORA-01103: database name 'ORCLDG' in control file is not 'ORCL' ”
解決方法: 1.將D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora中的引數db_name改為orcldg,啟動資料庫到載入狀態。startup mount pfile='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora';
2. 使用alter database backup controlfile to trace;匯出建立控制檔案的語句。
3.將步驟中的引數改為orcl,啟動資料庫例項sql> startup nomount pfile='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora';
4.將控制檔案語句在命令列執行。然後開啟資料庫sql>alter database open;
5.建立spfile, sql> create spfile from pfile='D:\oracle\product\10.2.0\admin\orcl\pfile\init.ora';
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16582684/viewspace-615178/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- recover database using backup control fileDatabase
- Database Clone by rebuilding control file.DatabaseRebuild
- To use Rman to duplicate database be careful of db_file_name_convertDatabase
- File name 屬性
- Oracle identifiers :Database NameOracleIDEDatabase
- db_file_name_convert和log_file_name_convert詳解
- control file parallel writeParallel
- reduce the database log fileDatabase
- Oracle identifiers :Global database nameOracleIDEDatabase
- 控制檔案-control file
- control file(控制檔案)
- Could not find first log file name in binary log index fileIndex
- FN_AUDIT - Name of security audit file
- Determining the Global Database Name (86)Database
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- oracle中instance name 和database name的一點體會OracleDatabase
- oracle重建control file的操作Oracle
- a control file contains informationAIORM
- control file parallel write等待事件Parallel事件
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- Troubleshooting Database Control Startup IssuesDatabase
- 042-Your database is having two control files, three redo log file groups with two members in each gDatabase
- SCRIPT TO GENERATE SQL*LOADER CONTROL FILESQL
- 重建控制檔案 recreate control file
- control file parallel write事件小記Parallel事件
- control file sequential read等待事件事件
- oracle檔案管理之 control fileOracle
- 【EM】重新建立EM Database ControlDatabase
- 對Database control 做金鑰管理Database
- RMAN 6217 not connected to auxiliary database with a net service nameUXDatabase
- Specifying the Database Time Zone File (81)Database
- ORA-00245:control file backup failed;targetis likely on local file systemAI
- ORA-00245: control file backup failed; target is likely on a local file systemAI
- ORACLE10G DG配置中兩個引數db_file_name_convert和log_file_name_convertOracle
- ERROR: failed to establish dependency between database db_name and diskgroupErrorAIDatabase
- RMAN-05517: temporary file conflicts with file used by target database(zt)Database
- Unload data to a flat file from Oracle databaseOracleDatabase