| Redo Log Mismatch [message #53479] |
Mon, 23 September 2002 12:24  |
Jason Peterson
Messages: 3
Registered: August 2002
|
Junior Member |
|
|
Here is the problem I'm having on my Oracle 9i
server. I copied the database files, control files and log files from one filesystem to 3 different file systems to comply with Oracle's OFA.
When I mount the database, here is the error.
SQL> startup
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-16068: redo log file activation identifier mismatch
ORA-00312: online log 1 thread 1:
'/opt/app/oracle/oraInventory/TS01/redo01.log'
Any help would be appreciated.
Thanks,
Jason
|
|
|
|
| Re: Redo Log Mismatch [message #53489 is a reply to message #53479] |
Mon, 23 September 2002 14:29  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
$sqlplus /nolog
SQL>conn / as sysdba
SQL>shutdown immediate
SQL>startup mount
SQL>select member from v$logfile;
Compare the location of this log with your log files actual location. If some files are different change the information in the control file:
SQL>alter database rename file 'old_file_locationfilename.log' to 'new_file_locationfilename.log';
SQL>alter database open;
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
