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;