磁带备份导致数据库异常的处理方法
周末的时候进行系统备份,ORACLE没有关闭的情况下进行了磁带备份.没有预计到会导致数据库异常.根据分析,磁带备份时会将备份文件占用并锁定,这样数据库在读写时无法正常进行,导致某些文件需要RECOVER.
- 1. Start SQLPLUS:
sqlplus "/ as sysdba"
- 2. Check whether tablespaces are set OFFLINE (only possible if the database is in OPEN state. If you cannot do this, skip steps 2 and 3, and execute them later, if required, when the database is running): SELECT TABLESPACE_NAME FROM DBA_TABLESPACES
WHERE STATUS = 'OFFLINE';
- 3. If tablespaces are returned, reset them to ONLINE: ALTER TABLESPACE
- 4. Check which data files have the status RECOVER: SELECT NAME FROM V$DATAFILE WHERE STATUS = 'RECOVER';
- 5. If you receive data files with the status RECOVER, recover each of these files with the following command:
RECOVER DATAFILE '
(for example RECOVER DATAFILE
'/oracle/HX1/sapdata8/stabi_2/stabi.data2';)
- 6. Check which data files have the status OFFLINE:
SELECT NAME FROM V$DATAFILE WHERE STATUS = 'OFFLINE';
- 7. Set all these data files ONLINE:
ALTER DATABASE DATAFILE '
- 8. If the calls in steps 2, 4 and 6 do not return lines anymore, the problem is correcte
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22078283/viewspace-617435/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
操作表的基础命令
下一篇：
常用的SQL*PLUS命令或SQL
请登录后发表评论
登录
全部评论
