Forums.ATC.no

Teknisk => Generelt teknisk => Emne startet av: ATC på 06. Mai 2009, 20:41 pm

Tittel: Oracle: After restoring a database from backup, the instance fails to start
Skrevet av: ATC på 06. Mai 2009, 20:41 pm

After restoring an oracle database from backup, the instance fails to start properly.

Tittel: [Solved] Oracle: After restoring a database from backup, the instance fails to start
Skrevet av: ATC på 06. Mai 2009, 20:41 pm

Because the file has been handles manually, its 'archive' flag has been reset, because of this it is treated as "dirty" by Oracle.

$ export ORACLE_SID=[sid]
$ sqlplus
(Log in with user name "system as sysdba")
SQL> SELECT status,name FROM v$datafile WHERE status =! 'ONLINE';
(If any of the files are status 'RECOVER' do the following:)
RECOVER DATAFILE '[/full/path/to/file]';
ALTER DATABASE DATAFILE '[filename]' ONLINE;
COMMIT WORK;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE OPEN;
(Repeat if any more errors occur)
EXIT