i need a little help please - RMAN

[manatee]

NBU 7.6.0.3

very sorry for the OOT post.

i'm trying to help our DBA restore a database from a certain date. according to him, he needs the "backup files of 9 NOV as we need to restore the control file of this day". it looks something like this:

-rw-rw-r-- oraprod asmdba 37748736 Nov 27 23:38 /ctrl_u16rm0j2s_s23590_p1_t929057884

-rw-rw-r-- oraprod asmdba 48552704K Nov 27 23:29 /arch_u15rm0ij5_s23589_p1_t929057381
-rw-rw-r-- oraprod asmdba 49037312K Nov 27 23:15 /arch_u14rm0hnn_s23588_p1_t929056503
-rw-rw-r-- oraprod asmdba 49164544K Nov 27 23:15 /arch_u13rm0hnf_s23587_p1_t929056495
-rw-rw-r-- oraprod asmdba 49302528K Nov 27 23:14 /arch_u12rm0hn9_s23586_p1_t929056489
-rw-rw-r-- oraprod asmdba 262144 Nov 27 22:59 /bk_u11rm0gqa_s23585_p1_t929055562
-rw-rw-r-- oraprod asmdba 37748736 Nov 27 22:58 /bk_u10rm0gon_s23584_p1_t929055511

is there an NBU command to list those files that RMAN did? thanks in advance.

regards,

[Michael_G_Ander · Accepted solution]

Yes,  bplist with -t 4 if I remember correctly, unless you using dump to disk in which case you show be able to see the files with -t 0 (Unix) or -t 13 (Windows)

[manatee]

hi, i did try the manuals but couldn't find the right topic/chapter. what has changed is he is a new DBA and i'm not that familiar yet with CLI commands. anyway, somehow he found it and started the restore. i'm making a note of the command.

thank you for replying. again, apologies for the off-topic post.

[Marianne]

What are the Retention levels used in Oracle policy schedules and/or SLP (backup and duplication) used for the the Oracle Default Application schedule?

If you know that there is still valid, unexpired Oracle backup on tape or disk for this date, you can use start- and end-dates with bplist command.

e.g to list all Oracle backups for this client between 8 and 10 November:

bplist -t 4 -C <client-name> -s 11/08/2016 -e 11/10/2016 -l -R /