SQL> SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01111: name for data file 7 is unknown - rename to correct file
ORA-01110: data file 7: '/oracle/app/oracle/product/12.2/db_1/dbs/UNNAMED00007'
dataguard 环境添加转换参数*.db_create_file_dest='+DGDATA02'
修改参数文件:
fgbbdb.__data_transfer_cache_size=0
fgbbdb.__db_cache_size=2751463424
fgbbdb.__inmemory_ext_roarea=0
fgbbdb.__inmemory_ext_rwarea=0
fgbbdb.__java_pool_size=16777216
fgbbdb.__large_pool_size=33554432
fgbbdb.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment
fgbbdb.__pga_aggregate_target=1073741824
fgbbdb.__sga_target=3355443200
fgbbdb.__shared_io_pool_size=0
fgbbdb.__shared_pool_size=536870912
fgbbdb.__streams_pool_size=0
*._log_deletion_policy='ALL'
*.audit_file_dest='/oracle/app/oracle/admin/fgbbdb/adump'
*.audit_trail='db'
*.compatible='12.2.0'
*.control_files='+DGSYSTEM/FGBBDB/CONTROLFILE/current.256.1108206413','+DGDATA01/FGBBDB/CONTROLFILE/current.256.1108206413'
*.db_block_size=16384
*.db_create_online_log_dest_1='+dgsystem'
*.db_create_online_log_dest_2='+dgdata01'
*.db_file_name_convert='itpuxdg1','fgbbdb','itpuxdg2','fgbbdb'
*.db_name='fgbbdb'
*.db_recovery_file_dest_size=1610612736000
*.db_recovery_file_dest='+dgrecovery'
*.db_unique_name='fgbbdb'
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=fgbbdbXDB)'
*.fal_client='fgbbdb'
*.fal_server='itpuxdg1','itpuxdg2'
*.local_listener='LISTENER_FGBBDB'
*.log_archive_config='DG_CONFIG=(fgbbdb,itpuxdg1,itpuxdg2)'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=fgbbdb'
*.log_archive_dest_2='SERVICE=itpuxdg1 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=itpuxdg1'
*.log_archive_dest_3='SERVICE=itpuxdg2 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=itpuxdg2'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.db_create_file_dest='+DGDATA02'
*.db_file_name_convert='itpuxdg1','fgbbdb','itpuxdg2','fgbbdb'
*.log_file_name_convert='itpuxdg1','fgbbdb','itpuxdg2','fgbbdb'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.pga_aggregate_target=1024m
*.processes=2000
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3200m
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'