adg数据文件无法创建问题

ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 375 - new file '/u01/app/oracle/tb1.dbf' not found
ORA-01111: name for data file 375 is unknown - rename to correct file
ORA-01110: data file 375: '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00375'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

原因：1data磁盘满了，导致创建不了

            2standby_file_management参数没有设置成auto

解决：手动添加

1

ALTER system SET standby_file_management='manual';

2

alter database create datafile  '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00375' as  '+data/financestd/datafile/tbsidx11';

3

ALTER system SET standby_file_management='auto';

4

SQL> shutdown immediate
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 5.3447E+10 bytes
Fixed Size            2240984 bytes
Variable Size         6442454568 bytes
Database Buffers     4.6842E+10 bytes
Redo Buffers          160722944 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> select open_mode, database_role from v$database;