Keywords

ORA-01523、ORA-01511

​

Applied Products

• Anybackup 7.0.x

​

Symptoms

When the anybackup management console initiates the Oracle RAC browse recovery task, select the data file redirection path for the recovery destination. The recovery task fails to execute. View the execution output, and the following error message is displayed:

Task execution exception, reason: interface call failed（ORA-01511:error in renaming log/data files）ORA-01523:cannot rename data file to '+data/orcl/group_2.295.936197519' - file already part of database。

​

Impact

Anybackup failed to perform the Oracle RAC browse recovery task.

​

Cause

When anybackup performs Oracle RAC redirected path recovery, the log file is not renamed. If the log file with the same name is recorded in the Oracle database control file, the browse recovery fails.

​

Resolution

Before the Oracle RAC data recovery task is executed abnormally and the ora-01511 and ora-01523 errors are prompted, all the data files have been recovered. At this time, just log in to the database and execute the SQL statement to rename the log files in the error prompt. You can start the database in the open resetlogs mode. Please follow the following steps:

1. Login the Oracle server operating system remotely through the remote connection tool.

2. Executing the following command to login oracle database:

export ORACLE_SID=<sid>

sqlplus / as sysdba

Attention： <sid> is the Oracle database instance name, which is case sensitive。

3.Entering the Oracle database, execute the following SQL statement to view the current log file group：

select member from v$logfile;

4. Execute the following SQL statement to rename the log file to the redirected path：

alter database rename file '+DATA_FRA/orcl/onlinelog/group_1.468.1027242405' to '+data/orcl/redo01.log';

alter database rename file '+DATA_FRA/orcl/onlinelog/group_2.465.1027242405' to '+data/orcl/redo02.log';

alter database rename file '+DATA_FRA/orcl/onlinelog/group_3.462.1027242405' to '+data/orcl/redo03.log';

Attention：+data/orcl is the redirection path of data files.

5. Execute the following SQL statement to start the database using resetlogs：

alter database open resetlogs;

​

More information

For detailed description of ora-01523, please refer to the official Oracle document：ORA-01523 .