RMAN: restore not done; all files read only, offline, excluded, or already restored
0
votes
1
answer
805
views
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: {=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.
Asked by datascinalyst
(105 rep)
Mar 25, 2024, 09:45 AM
Last activity: May 23, 2025, 04:02 PM
Last activity: May 23, 2025, 04:02 PM