我正在使用主服务器的热备份创建一个data guard。在我的还原中,我使用了以下命令来还原:
run{
set newname for database to '+DADOS';
restore database;
switch datafile all;
switch tempfile all;
recover database;
}在成功还原和恢复之后,我的重做日志文件名的名称如下:
select member from v$logfile;
+DADOS/MUST_RENAME_THIS_LOGFILE_1.4294967295.4294967295
+FRA/MOOTDB/ONLINELOG/group_1.287.1040583755
+DADOS/MUST_RENAME_THIS_LOGFILE_2.4294967295.4294967295
+DADOS/MUST_RENAME_THIS_LOGFILE_3.4294967295.4294967295
+FRA/MOOTDB/ONLINELOG/group_3.259.1036639239
+DADOS/MUST_RENAME_THIS_LOGFILE_4.4294967295.4294967295
+FRA/MOOTDB/ONLINELOG/group_2.288.1040583761
+DADOS/MUST_RENAME_THIS_LOGFILE_5.4294967295.4294967295
+FRA/MOOTDB/ONLINELOG/group_5.295.1042634101
+DADOS/MUST_RENAME_THIS_LOGFILE_6.4294967295.4294967295
+FRA/MOOTDB/ONLINELOG/group_6.297.1042634113为什么他们有"MUST_RENAME_THIS_LOGFILE_"?不是自动的吗?
在我的待机状态下,我使用db_log_file_name_convert和log_file_name_convert
log_file_name_convert = +DATA, +DADOS
db_file_name_convert = +DATA, +DADOS另一个问题是,有些诱饵文件只附带DG名称(请参见下面最后一行)。
select name from v$datafile union all select name from v$tempfile;
+DADOS/MOOTSTB/DATAFILE/system.266.1042731967
+DADOS/MOOTSTB/DATAFILE/sysaux.292.1042731967
+DADOS/MOOTSTB/A249914E10CA3494E0532900A8C0EAA4/DATAFILE/system.278.1042732081
+DADOS/MOOTSTB/A249914E10CA3494E0532900A8C0EAA4/DATAFILE/sysaux.296.1042732081
+DADOS/MOOTSTB/DATAFILE/users.309.1042731967
+DADOS/MOOTSTB/A249914E10CA3494E0532900A8C0EAA4/DATAFILE/undotbs1.320.1042732081
+DADOS/MOOTSTB/DATAFILE/undotbs2.283.1042731967
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/system.257.1042731811
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/sysaux.284.1042731809
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/undotbs1.289.1042731811
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/users.267.1042731811
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/soe.311.1042731809
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/teste.308.1042731811
+DADOS/MOOTSTB/A249E748BB047773E0532900A8C02088/DATAFILE/undo_2.304.1042731811
+DADOS/MOOTSTB/DATAFILE/undotbs1.302.1042731967
+DADOS/MOOTSTB/TEMPFILE/temp.319.1042736311
+DADOS/MOOTSTB/A249914E10CA3494E0532900A8C0EAA4/TEMPFILE/temp.318.1042736323
+DADOS <<<<<< is a tempfile发布于 2020-06-11 09:38:51
还原+备份恢复不使用联机重做日志。您的重做日志刚刚命名为某个文件,但这些文件还不存在。物理备用数据库也不使用联机重做日志(它使用备用重做日志)。
重做日志组将在第一次需要时自动清除(根据OMF +创建文件重命名)。就像在将物理备用转换为主数据库或快照备用或逻辑备用后,实际以READ WRITE模式打开数据库一样。
+FRA/MOOTDB/ONLINELOG/group_1.287.1040583755也不正确。此时,该文件不存在,该文件的位置(一旦清除)将为+FRA/MOOTSTB/ONLINELOG/...,因为备用站点上的db_unique_name为MOOTSTB。(假设你在那里有一个FRA磁盘组。)
通过正确设置db_create_file_dest、db_create_online_log_dest_N、db_recovery_file_dest参数,您可以手动清除日志文件组(在需要时将自动完成的操作),因此它们将被正确命名和放置:
alter database clear logfile group 1;
alter database clear logfile group 2;
alter database clear logfile group 3;
alter database clear logfile group 4;
alter database clear logfile group 5;
alter database clear logfile group 6;名为+DADOS的诱惑文件也不是问题。在挂载阶段的物理备用不需要一个tempfile。一旦打开数据库,将自动重命名和创建该tempfile。
https://dba.stackexchange.com/questions/268908
复制相似问题