Teman-teman mohon bantuannya..saya ingin mengganti path datafile, saya
menjalankannya di SQL
SQL>@/opt/oracle/control.sql
isi dari control.sql sebagai berikut:
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "PROD" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/opt/oracle/oradata/prod/redo01.log' SIZE 50M,
GROUP 2 '/opt/oracle/oradata/prod/redo02.log' SIZE 50M,
GROUP 3 '/opt/oracle/oradata/prod/redo03.log' SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/opt/oracle/oradata/system01.dbf',
'/opt/oracle/oradata/undotbs01.dbf',
'/opt/oracle/oradata/sysaux01.dbf',
'/opt/oracle/oradata/users01.dbf'
CHARACTER SET WE8ISO8859P1
;
-- Commands to re-create incarnation table
-- Below log names MUST be changed to existing filenames on
-- disk. Any one log file from each branch can be used to
-- re-create incarnation records.
-- ALTER DATABASE REGISTER LOGFILE
'/opt/oracle/flash_recovery_area/prod/archivelog/2008_07_10/o1_mf_1_1_%u_.arc';
-- ALTER DATABASE REGISTER LOGFILE
'/opt/oracle/flash_recovery_area/prod/archivelog/2008_07_10/o1_mf_1_1_%u_.arc';
-- Recovery is required if any of the datafiles are restored backups,
-- or if the last shutdown was not normal or immediate.
RECOVER DATABASE
-- Database can now be opened normally.
ALTER DATABASE OPEN;
setelah saya jalankan keluar error:ORA-01503:CREATE CONTROLFILE FAILED
Mohon bantuannya terima kasih
[Non-text portions of this message have been removed]
