Database Backup and Recovery (MOSC)

MOSC Banner

RMAN-05541: no archived logs found in target database

edited Dec 3, 2016 3:00AM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

hello everybody.

I have the following situation:

oracle 11.2.0.3 EE wich is backed up with th script:

run{

crosscheck backup;

crosscheck copy;

crosscheck archivelog all;

delete noprompt obsolete;

DELETE noprompt EXPIRED ARCHIVELOG ALL;

DELETE noprompt EXPIRED BACKUP;

RECOVER COPY OF DATABASE WITH TAG 'B2' until time 'SYSDATE-8';

BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'B2' DATABASE;

BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

restore validate database;

report unrecoverable;

}

So i took the last backup with the script below and put it to the appropriate NFS location /storage/flash_recovery_area/ODBP_WORK/

run{

SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/storage/flash_recovery_area/ODBP_WORK/autobackup/%F';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center