Issue:
alter database open
ORA-1113 signalled during: alter database open...
Starting ORACLE instance (normal)
Solution:
startup mount
ALTER DATABASE RECOVER database;
or
Check backup mode
-- Hot backup status
SELECT COUNT(*) FROM v$backup WHERE status ='ACTIVE';
-- Tablespaces in hot backup mode
SELECT distinct ddf.tablespace_name tablespace_name
FROM v$backup vb, DBA_DATA_FILES ddf
WHERE vb.status ='ACTIVE' and vb.file# = ddf.file_id;
ALTER TABLESPACE (<tbs_name from the query before>) END BACKUP ;
No comments:
Post a Comment