O-R-A-C-L-E R-M-A-N Backups

[KOTC]

Catalog use chesinapudu a recovery catalog query chesi latest backup ela telusukovachu

[KOTC]

Nocatalog aithe ade database control file use chestundi kadha.

catalog appudu catalog database control file use chestundi kadha so a catalog database lo latest backups ni list chedam ela?

[Joey_Tribbiani]

i think that depends up on how you connect to catalog ..

if you connect rman with catalog and list backups , adi catalog DB nunchi data istundi ..

if you use without catalog , nee current DB control file nunchi istundi ..

Just my 2 cents .. LTT for more inputs

[KOTC]

[quote name='Joey_Tribbiani' timestamp='1357768022' post='1303081006']
i think that depends up on how you connect to catalog ..

if you connect rman with catalog and list backups , adi catalog DB nunchi data istundi ..

if you use without catalog , nee current DB control file nunchi istundi ..

Just my 2 cents .. LTT for more inputs
[/quote]


ade bhayya mana no catalog anuko

rman target / ani connect avutam

ade catalog use chesinapud rman target / catalog username/passwd@catalogdatabase


estam kani ippudu nuv a catalog database ki poyi list backups ani este naku aithe catalog use chesi unna targets database backup list ravtam le.so nuv chepinatu a target database ki poyi chudala list backups ani?

[nexus]

catalog database lo as catalog owner laaga login ayyi below query execute chesi try cheyi baa..

select a.name,a.dbid,to_char(max(b.completion_time),'MM/DD/YYYY:HH24:MI:SS') from rc_database a,bs b where a.name='<ni db name>' and a.db_key=b.db_key group by a.dbid,a.name;

[KOTC]

[quote name='nexus' timestamp='1357770306' post='1303081333']
catalog database lo as catalog owner laaga login ayyi below query execute chesi try cheyi baa..

select a.name,a.dbid,to_char(max(b.completion_time),'MM/DD/YYYY:HH24:MI:SS') from [b]rman[/b].rc_database a,bs b where a.name='<ni db name>' and a.db_key=b.db_key group by a.dbid,a.name;
[/quote]


<ni db name> ante target database name e kadha chesa table or view doesn't exist.

[peru_edaite_enti]

hmm.. morning nee msg chusa... query untundi, vetakali.. but yeah, aa rman catalog schema ki connect aiyi query cheyali..

[nexus]

okay, aithe specify the schema identifier for 'bs' table also like rman.bs (assuming rman is ur catalog owner)

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select a.name,a.dbid,to_char(max(b.completion_time),'MM/DD/YYYY:HH24:MI:SS') from [/background][/size][/font][/color][b]rman[/b][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)].rc_database a, [b]rman.[/b]bs b where a.name='<ni db name>' and a.db_key=b.db_key group by a.dbid,a.name;[/background][/size][/font][/color]

[KOTC]

[quote name='nexus' timestamp='1357772808' post='1303081548']
okay, aithe specify the schema identifier for 'bs' table also like rman.bs (assuming rman is ur catalog owner)

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select a.name,a.dbid,to_char(max(b.completion_time),'MM/DD/YYYY:HH24:MI:SS') from [/background][/size][/font][/color][b]rman[/b][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)].rc_database a, [b]rman.[/b]bs b where a.name='<ni db name>' and a.db_key=b.db_key group by a.dbid,a.name;[/background][/size][/font][/color]
[/quote]


no rows selected

[KOTC]

[quote name='nexus' timestamp='1357772808' post='1303081548']
okay, aithe specify the schema identifier for 'bs' table also like rman.bs (assuming rman is ur catalog owner)

[color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select a.name,a.dbid,to_char(max(b.completion_time),'MM/DD/YYYY:HH24:MI:SS') from [/background][/size][/font][/color][b]rman[/b][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)].rc_database a, [b]rman.[/b]bs b where a.name='<ni db name>' and a.db_key=b.db_key group by a.dbid,a.name;[/background][/size][/font][/color]
[/quote]


target database ki ila connect ayyanu

rman target username/psswd@targetdb catalog username/psswd@catalog database

database complete backup chesa

still no rows selected ani vastundi

[KOTC]

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;--e command e na control file
rentention period set cheytaniki use chesedi

[KOTC]

+1

[nexus]

Google chesthe idhedho dhorikindhi, okasari try cheyi

select RC_BACKUP_SET_SUMMARY.DB_NAME,NEWEST_BACKUP_TIME,TO_CHAR(MIN(BP.START_TIME),'DD/MM/YYYY HH24:MI:SS'),TO_CHAR(MAX(BP.COMPLETION_TIME),'DD/MM/YYYY HH24:MI:SS') from RC_BACKUP_SET_SUMMARY, BP WHERE RC_BACKUP_SET_SUMMARY.DB_KEY = BP.DB_KEY AND RC_BACKUP_SET_SUMMARY.DB_NAME='<ur dbname here>' GROUP BY RC_BACKUP_SET_SUMMARY.DB_NAME, NEWEST_BACKUP_TIME;

[KOTC]

[quote name='nexus' timestamp='1357774413' post='1303081723']
Google chesthe idhedho dhorikindhi, okasari try cheyi

select RC_BACKUP_SET_SUMMARY.DB_NAME,NEWEST_BACKUP_TIME,TO_CHAR(MIN(BP.START_TIME),'DD/MM/YYYY HH24:MI:SS'),TO_CHAR(MAX(BP.COMPLETION_TIME),'DD/MM/YYYY HH24:MI:SS') from RC_BACKUP_SET_SUMMARY, BP WHERE RC_BACKUP_SET_SUMMARY.DB_KEY = BP.DB_KEY AND RC_BACKUP_SET_SUMMARY.DB_NAME='<ur dbname here>' GROUP BY RC_BACKUP_SET_SUMMARY.DB_NAME, NEWEST_BACKUP_TIME;
[/quote]


thanks bhayya kani schema owner ekkad petali ardham avtam ledhu

select rman.RC_BACKUP_SET_SUMMARY.DB_NAME,NEWEST_BACKUP_TIME,TO_CHAR(MIN(BP.START_TIME),'DD/MM/YYYY HH24:MI:SS'),TO_CHAR(MAX(BP.COMPLETION_TIME),'DD/MM/YYYY HH24:MI:SS') from rman.RC_BACKUP_SET_SUMMARY, BP WHERE rman.RC_BACKUP_SET_SUMMARY.DB_KEY = BP.DB_KEY AND rman.RC_BACKUP_SET_SUMMARY.DB_NAME='dbname' GROUP BY rman.RC_BACKUP_SET_SUMMARY.DB_NAME, NEWEST_BACKUP_TIME;

[KOTC]

select name, full, inc, log, ctl
from
rman.rc_database d,
(select db_id, max(START_TIME) full
from rman.rc_backup_set s
where s.backup_type in ('D')
and controlfile_included = 'NONE'
group by db_id) f,
(select db_id, max(START_TIME) inc
from rman.rc_backup_set s
where s.backup_type in ('I')
group by db_id) i,
(select db_id, max(START_TIME) log
from rman.rc_backup_set s
where s.backup_type in ('L')
group by db_id) l,
(select db_key, max(completion_TIME) ctl
from rman.rc_backup_controlfile s
group by db_key) c
where f.db_id(+) = d.dbid
and i.db_id(+) = d.dbid
and l.db_id(+) = d.dbid
and c.db_key(+) = d.db_key
order by 1;




kani idi only date estundi mama time evvatam le




NAME FULL INC LOG CTL
-------- --------- --------- --------- ---------
dbname1 06-JAN-13 09-JAN-13 09-JAN-13
proddb 09-JAN-13 08-JAN-13 09-JAN-13 09-JAN-13
dev 08-JAN-13 09-JAN-13 09-JAN-13