您好，登录后才能下订单哦！
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
执行以下语句报错：
SQL> alter tablespace system begin backup; ERROR at line 1: ORA-01123: cannot start online backup; media recovery not enabled
通过查看资料发现时归档未开启，开启归档操作步骤：
SQL> alter database close normal; Database altered. SQL> select open_mode from v$database; OPEN_MODE ------------------------------------------------------------ MOUNTED SQL> alter database archivelog; Database altered.
发现这时候要重启数据库，否则无法直接切换到读写模式：
SQL> alter database open; alter database open * ERROR at line 1: ORA-16196: database has been previously opened and closed SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup; ORACLE instance started. Total System Global Area 6680915968 bytes Fixed Size 2213936 bytes Variable Size 3556771792 bytes Database Buffers 3087007744 bytes Redo Buffers 34922496 bytes Database mounted. Database opened.
亿速云「云服务器」，即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘，价格低至29元/月。点击查看>>
开发者交流群：
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。