sys@FUWA 2023-11-30 11:31:54> select FILE#,name,CREATION_TIME from v$datafile;

     FILE# NAME 									    CREATION_TIME
---------- -------------------------------------------------------------------------------- -------------------
	 1 /data/oradata/fuwa/system01.dbf						    2013-08-24 11:37:33
	 2 /data/oradata/fuwa/sysaux01.dbf						    2013-08-24 11:37:37
	 3 /data/oradata/fuwa/undotbs01.dbf						    2013-08-24 12:07:19
	 4 /data/oradata/fuwa/users01.dbf						    2013-08-24 11:37:49
	 5 /data/oradata/FUWA/datafile/o1_mf_users_lphyvf37_.dbf			    2023-11-30 11:01:53
	 6 /data/u01/app/oracle/product/11.2.0/db/dbs/UNNAMED00006			    2023-11-30 11:32:35

6 rows selected.

sys@FUWA 2023-11-30 11:34:21> select file#,name ,status from v$datafile where status='RECOVER';

     FILE# NAME 									    STATUS
---------- -------------------------------------------------------------------------------- -------
	 6 /data/u01/app/oracle/product/11.2.0/db/dbs/UNNAMED00006			    RECOVER

sys@FUWA 2023-11-30 11:47:59> 
sys@FUWA 2023-11-30 11:49:53> 
sys@FUWA 2023-11-30 11:49:54> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active


sys@FUWA 2023-11-30 11:49:55> alter database create datafile '/data/u01/app/oracle/product/11.2.0/db/dbs/UNNAMED00006'  as '/data/oradata/wafu/users03.dbf';
alter database create datafile '/data/u01/app/oracle/product/11.2.0/db/dbs/UNNAMED00006'  as '/data/oradata/wafu/users03.dbf'
*
ERROR at line 1:
ORA-01119: error in creating database file '/data/oradata/wafu/users03.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1


sys@FUWA 2023-11-30 11:51:32> alter database create datafile '/data/u01/app/oracle/product/11.2.0/db/dbs/UNNAMED00006'  as '/data/oradata/fuwa/users03.dbf';

Database altered.

sys@FUWA 2023-11-30 11:51:55> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


sys@FUWA 2023-11-30 11:52:37> select name ,status from v$datafile 
  2  ;

NAME										 STATUS
-------------------------------------------------------------------------------- -------
/data/oradata/fuwa/system01.dbf 						 SYSTEM
/data/oradata/fuwa/sysaux01.dbf 						 ONLINE
/data/oradata/fuwa/undotbs01.dbf						 ONLINE
/data/oradata/fuwa/users01.dbf							 ONLINE
/data/oradata/FUWA/datafile/o1_mf_users_lphyvf37_.dbf				 ONLINE
/data/oradata/fuwa/users03.dbf							 RECOVER

6 rows selected.

sys@FUWA 2023-11-30 11:53:06> alter database recover managed standby database using current logfile disconnect from session;
alter database recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active


sys@FUWA 2023-11-30 11:53:46> alter database recover managed standby database cancel;
alter database recover managed standby database cancel
*
ERROR at line 1:
ORA-16136: Managed Standby Recovery not active


sys@FUWA 2023-11-30 11:55:18> alter database  recover managed standby database using current logfile disconnect from session; 
alter database	recover managed standby database using current logfile disconnect from session
*
ERROR at line 1:
ORA-01153: an incompatible media recovery is active

复制