解决办法:
SQL> show parameter standby_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
创建文件
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00016' as 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS03.DBF';
数据库已更改。
SQL> alter database recover managed standby database using current logfile disconnect from session
数据库已更改。
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY
SQL> select process,status,sequence# from v$managed_standby
2 ;