在主库添加数据文件的时候,备库告警日志里面出现了如下错误信息,并且恢复进程也down掉了:
File #210 added to control file as 'UNNAMED00210' because
the parameter STANDBY_FILE_MANAGEMENT is set to MANUAL
The file should be manually created to continue.
MRP0: Background Media Recovery terminated with error 1274
Errors in file /u01/oracle/app/diag/rdbms/orauat1s/orauat/trace/orauat_pr00_109437.trc:
原来是参数standby_file_management 设置为manual ,将standby_file_management 改为auto:
查看数据文件全名:
SQL> select file_name from dba_data_files where tablespace_name='UNNAMED00210';
no rows selected
因为数据文件只是以UNNAMED00210 记录在控制文件中,并没有真正创建成功,所以在 dba_data_files 视图中是看不到的
SQL> select name from v$datafile;
NAME
…………
/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210' as '/oradata/orauat/tbs_captain01.dbf';
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210' as '/oradata/orauat/tbs_captain01.dbf'
*
ERROR at line 1:
ORA-01275: Operation CREATE DATAFILE is not allowed if standby file management
is automatic.
原来在standby_file_management 为auto时,不能手工创建,改为manual
SQL> alter system set standby_file_management=manual;
System altered.
SQL> alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00210' as '/oradata/orauat/tbs_captan01.dbf';
Database altered.
再将standby_file_management改为 auto,启动恢复进程:
SQL> alter system set standby_file_management=auto;
System altered.
SQL> alter database recover managed standby database using current logfile disconnect;
Database altered.
over了,问题解决了。