oracle重建控制文件的resetlogs选项
oracle重建控制文件的resetlogs选项
alter database backup controlfile to trace as ‘/home/oracle/controlfile.ora’;
Below are two sets of SQL statements, each of which creates a new
– control file and uses it to open the database. The first set opens
– the database with the NORESETLOGS option and should be used only if
– the current versions of all online logs are available. The second
– set opens the database with the RESETLOGS option and should be used
– if online logs are unavailable.
– The appropriate set of statements can be copied from the trace into
– a script file, edited as necessary, and executed when there is a
– need to re-create the control file.
- 上一篇：Linux下用户组、文件权限详解
- 下一篇：mysql把字段进行逗号分隔成多条数据
相关文章
图文推荐
-
如何使用kali的Searchsploit查找软件漏洞
-
iOS UITextField 使用详解
-
hibernate3中的hibernateDaoSupport到hibernate4中不适用的情况分析和解决
-
又是七夕，1000元租个美女，50元租个私教的App靠谱吗？
- 文章
- 推荐
- 热门新闻