ON CALL DBA SUPPORT

— Database blog

RMAN BACKUP MEDIA ID /TAPE ID

Posted by ssgottik on 16/04/2014

select   to_char(bu.completion_time, ‘YYYY-MM-DD HH24:MI’) as completion_time,bu.media as media_id      
from v$backup_piece bu
where   to_char( bu.completion_time , ‘MM-DD-YYYY’)= ‘mm-dd-yyyy’   
order by 1 desc

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: