Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

RMAN: restore not done; all files read only, offline, excluded, or already restored

Atif MemonMar 28 2024 — edited Mar 28 2024

I did a hot RMAN backup of a server running Oracle 19c database, then moved the backup to a new server.

This is the backupscript

BACKUP AS compressed BACKUPSET INCREMENTAL LEVEL=0 FORMAT 'Prod_Full_DB_%u_%s_%p' DATABASE plus archivelog;

When I completed the restore, I faced this error

SQL> RECOVER DATABASE;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279: change 8922136743 generated at 03/24/2024 04:19:33 needed for thread
1
ORA-00289: suggestion : /u03/archives/1_65472_1115909325.dbf
ORA-00280: change 8922136743 for thread 1 is in sequence #65472


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log '/u03/archives/1_65472_1115909325.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

I solved this error by manually transferring the archives to the server. I also realized that the archive which was causing problem was made DURING the backup process.

After the restore was completed I did some searching, and found a way to restore archives from the backup pieces:

run {
allocate channel t1 type disk;
set archivelog destination to '/u04/';
restore archivelog until sequence 65460;
release channel t1;
}

however, I am facing this error

archived log for thread 1 with sequence 1 is already on disk as file /u01/archives/1_1_1164473680.dbf
archived log for thread 1 with sequence 2 is already on disk as file /u01/archives/1_2_1164473680.dbf
restore not done; all files read only, offline, excluded, or already restored

I guess this might be because the database has already been restored.

any changes I should make when I am taking the backup, as the archive which was causing an issue, was made while the backup was being taken.

Comments
Post Details
Added on Mar 28 2024
0 comments
98 views