hi gurus,
im using 11.2.0.3 oracle database under redhat 5.3.
I'm doing every monday and thursday a restore/recover with a full backup of prod database to test database (in another server).
I think that i can use any view or table to check if the restore was successfull or not with this script:
select end_time, status, input_type
from v$rman_backup_job_details
where input_type <> 'ARCHIVELOG';
For example, i did one restore on 12th and 15th of this week but it's appear:
END_TIME STATUS INPUT_TYPE
--------- ----------------------- -------------
10-NOV-12 COMPLETED DB FULL
11-NOV-12 COMPLETED DB FULL
12-NOV-12 COMPLETED DB FULL
13-NOV-12 COMPLETED DB FULL
14-NOV-12 COMPLETED DB FULL
15-NOV-12 COMPLETED DB FULL
why appears another days if i ommited "ARCHIVELOGS", is there another way to query only the result of the restore/recover of rman backup?