Berikut ini prosedur menciptakan ulang Control File:
1. Lakukan full backup database, termasuk seluruh datafile dan redo log file..
2. Login ke database dan lakukan startup.
SQL> STARTUP NOMOUNT;
3. Buat ulang control file dengan perintah berikut:
CREATE CONTROLFILE REUSE DATABASE "P716" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 50
MAXLOGMEMBERS 3
MAXDATAFILES 300
MAXINSTANCES 8
MAXLOGHISTORY 500
LOGFILE
GROUP 1 '/u01/oracle/7.1.6/dbs/log1p716.dbf' SIZE 1M,
GROUP 2 '/u01/oracle/7.1.6/dbs/log2p716.dbf' SIZE 1M,
GROUP 3 '/u01/oracle/7.1.6/dbs/log3p716.dbf' SIZE 1M
DATAFILE
'/u01/oracle/7.1.6/dbs/systp716.dbf' SIZE 40M,
'/u01/oracle/7.1.6/dbs/tempp716.dbf' SIZE 1M,
'/u01/oracle/7.1.6/dbs/toolp716.dbf' SIZE 15M ;
Sesuaikan data-data diatas (nama database, directory, log file dan
datafile) sesuai database Anda.
4. Lakukan media recovery terhadap database.
SQL> recover database;
5. Buka kembali database.
SQL> alter database open;
6. Lakukan full cold backup terhadap database (shutdown terlebih dahulu
database Anda).
Semoga membantu.
Salam,
Indra Armansyah
[EMAIL PROTECTED]
----- Original Message -----
From: petambakudang
To: [email protected]
Sent: Thursday, January 04, 2007 11:32 AM
Subject: [indo-oracle] ngga bisa mount dan open database
saya memiliki masalah dengan database saya, yaitu nga bisa di mount
dan opened...
saya sudah menjalankan seperti ini:
SQL*Plus: Release 10.1.0.3.0 - Production on Thu Jan 4 11:01:12 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> Connected.
SQL> SQL> ALTER DATABASE mount
*
ERROR at line 1:
ORA-00214: controlfile '/app/oracle/oradata/cad2006/control02.ctl' version
14033 inconsistent with file '/app/oracle/oradata/cad2006/control01.ctl'
version 14030
Disconnected from Oracle Database 10g Enterprise Edition Release
10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
pesan error seperti diatas, saya sudah coba recovery menggunakan OEM
tapi tidak bisa.
Apa yang harus dilakukan untuk memperbaikinya yah?
terima kasih atas jawabannya
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.0.409 / Virus Database: 268.16.4/615 - Release Date: 1/3/2007
[Non-text portions of this message have been removed]
