nexus Posted January 9, 2013 Report Posted January 9, 2013 [color=#282828][font=helvetica, arial, sans-serif]Try this. TO_CHAR function use chesi convert cheskovachu select name, full, inc, log, ctl[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]rman.rc_database d,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),'MM/DD/YYYY:HH24:MI:SS') full[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('D')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and controlfile_included = 'NONE'[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) f,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]inc[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('I')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) i,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]log[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('L')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) l,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_key, to_char(max(completion_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]ctl[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_controlfile s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_key) c[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where f.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and i.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and l.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and c.db_key(+) = d.db_key[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]order by 1;[/font][/color]
KOTC Posted January 9, 2013 Author Report Posted January 9, 2013 [quote name='nexus' timestamp='1357775529' post='1303081829'] [color=#282828][font=helvetica, arial, sans-serif]Try this. TO_CHAR function use chesi convert cheskovachu select name, full, inc, log, ctl[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]rman.rc_database d,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),'MM/DD/YYYY:HH24:MI:SS') full[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('D')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and controlfile_included = 'NONE'[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) f,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]inc[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('I')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) i,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_id, to_char(max(START_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]log[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_set s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where s.backup_type in ('L')[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_id) l,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](select db_key, to_char(max(completion_TIME),[/font][/color][color=#282828][font=helvetica, arial, sans-serif]'MM/DD/YYYY:HH24:MI:SS') [/font][/color][color=#282828][font=helvetica, arial, sans-serif]ctl[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from rman.rc_backup_controlfile s[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]group by db_key) c[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]where f.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and i.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and l.db_id(+) = d.dbid[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]and c.db_key(+) = d.db_key[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]order by 1;[/font][/color] [/quote] Thanks alot mama work ayindi kani e query only latest time intervals estundha like ani times evadhu kadha
nexus Posted January 10, 2013 Report Posted January 10, 2013 [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select name, full, inc, log, ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]rman.rc_database d,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,'MM/DD/YYYY:HH24:MI:SS') full[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('D')[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and controlfile_included = 'NONE'[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) f,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]inc[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('I')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) i,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]log[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('L')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) l,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_key, to_char(completion_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_controlfile s[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) c[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where f.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and i.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and l.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and c.db_key(+) = d.db_key[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]order by 1;[/background][/size][/font][/color] [font="helvetica, arial, sans-serif"][color="#282828"][size=3]max and groupby thisesaa.....this query might take time to execute.[/size][/color][/font]
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357776053' post='1303081879'] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select name, full, inc, log, ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]rman.rc_database d,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,'MM/DD/YYYY:HH24:MI:SS') full[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('D')[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and controlfile_included = 'NONE'[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) f,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]inc[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('I')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) i,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]log[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('L')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) l,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_key, to_char(completion_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_controlfile s[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) c[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where f.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and i.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and l.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and c.db_key(+) = d.db_key[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]order by 1;[/background][/size][/font][/color] [font=helvetica, arial, sans-serif][color=#282828][size=3]max and groupby thisesaa.....this query might take time to execute.[/size][/color][/font] [/quote] Bhayya 5mins kanna ekav tesukuntndi light anukunta antha ? any other options? ippudu recovery catalog control file retention period ila ne kadha set chese di CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357776053' post='1303081879'] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]select name, full, inc, log, ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]rman.rc_database d,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,'MM/DD/YYYY:HH24:MI:SS') full[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('D')[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and controlfile_included = 'NONE'[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) f,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]inc[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('I')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) i,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_id, to_char(START_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]log[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_set s[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where s.backup_type in ('L')[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) l,[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)](select db_key, to_char(completion_TIME,[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]'MM/DD/YYYY:HH24:MI:SS') [/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]ctl[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]from rman.rc_backup_controlfile s[/background][/size][/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]) c[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]where f.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and i.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and l.db_id(+) = d.dbid[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]and c.db_key(+) = d.db_key[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(247, 247, 247)]order by 1;[/background][/size][/font][/color] [font=helvetica, arial, sans-serif][color=#282828][size=3]max and groupby thisesaa.....this query might take time to execute.[/size][/color][/font] [/quote] jeevitham ela rastav bhayya nuv query lu naku aithe modda be ravu e query ani timings kante completed or failed vaste better anukunta bhayya
nexus Posted January 10, 2013 Report Posted January 10, 2013 yeah, time thiskuntadhi aa query kastha, where condition lo just niku kavalsina dbname tho filter cheyi kavalante, so just aa oka database details matram vasthundhi kastha twaraga. Reg backup retention, it is in correct format
nexus Posted January 10, 2013 Report Posted January 10, 2013 [quote name='KOTC' timestamp='1357777021' post='1303081969'] jeevitham ela rastav bhayya nuv query lu naku aithe modda be ravu e query ani timings kante completed or failed vaste better anukunta bhayya [/quote] nenu bongu rasanu..naaku antha scene ledhu...edho ala edit cheyatam nerchukunna baaga anthe
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357777145' post='1303081978'] nenu bongu rasanu..naaku antha scene ledhu...edho ala edit cheyatam nerchukunna baaga anthe [/quote] adi ayina bettter bhayya nenu nerchukovali FYI:http://oracle.su/docs/11g/backup.112/e10643/rcviews001.htm CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;--idi correct e antav pyna laga configure cheste catalog database control file lo backup information 90 days untndi kadha???
nexus Posted January 10, 2013 Report Posted January 10, 2013 Thanks for the link. It is informational First thing, catalog database controlfile anedhi wrong terminology Either catalog database aina vadutham or control file vadutham. Catalog database stores the information about the backups of target database. Okavela catalog database use cheyakunte aa backup information antha controlfile lo untundhi. Control file lo indefinite ga information store cheyodhu. CONTROLFILE_RECORD_KEEP_TIME parameter lo entha value undho, anni recent days backup information matram target database controlfile to store ayuntundhi. After that keep time period, it will be overwritten. Finally ni RMAN configuration command correct. It sets retention period of the backups to 3 days not to 90 days. Note: Eventhough you set the retention period, rman doesn't delete the backup older than the retention period if there is no recent full backup available.
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357778880' post='1303082152'] Thanks for the link. It is informational First thing, catalog database controlfile anedhi wrong terminology Either catalog database aina vadutham or control file vadutham. Catalog database stores the information about the backups of target database. Okavela catalog database use cheyakunte aa backup information antha controlfile lo untundhi. Control file lo indefinite ga information store cheyodhu. CONTROLFILE_RECORD_KEEP_TIME parameter lo entha value undho, anni recent days backup information matram target database controlfile to store ayuntundhi. After that keep time period, it will be overwritten. Finally ni RMAN configuration command correct. It sets retention period of the backups to 3 days not to 90 days. Note: Eventhough you set the retention period, rman doesn't delete the backup older than the retention period if there is no recent full backup available. [/quote] okati clarify cheyi kaka so nenu catalog database use chestuna kadha so a catalog database control file lo target database backup informations asalu untndha unte eni days untdi adi ela check cheyalii (nuv chepinatu controlfile_record_keep_time chudala??))
nexus Posted January 10, 2013 Report Posted January 10, 2013 In my perspective, Catalog database and rman catalog are two different things. Catalog database is just like a regular database in which we create rman catalog. Like the regular databases, Catalog database's control file stores information only regarding itself(like datafile locations, backup information etc). RMAN catalog which resides in the catalog database is the one which is responsible for storing the backup information of the target databases. It stores this information inside the tables.
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 Ardham ayi ardham kanatu undi bhayya.
nexus Posted January 10, 2013 Report Posted January 10, 2013 okasari naku catalog database ela create chestharo koncham brief ga cheppu ba. Dhanni batti niku artham ayelaaga cheptha
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [color=#282828][font=helvetica, arial, sans-serif]catalog database or repository database--- catdb[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]target database----porddb[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]so nenu oka user ni create chesa catdb(repository) loo say rmanuser, [/font][/color][color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]GRANT recovery_catalog_owner,resource,coonect TO rmanuser;[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]then ippudu catdb ki veli[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]rman connect catalog rmanuser/paswd@catdb[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]rman> create catalog;[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]travtha proddb ki velii rman target / catalog rmanuser/passwd@rman12c[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]rman> register database;[/background][/size][/font][/color] [color=#282828][font=helvetica, arial, sans-serif][size=3][background=rgb(238, 238, 238)]anthe kadha[/background][/size][/font][/color]
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 ikkada na question enti a catalog database lo ni control file lo target database backup info untndi adi oka 90 days set cheyali adi ela cheyali nuv chepina [color=#282828][font=helvetica, arial, sans-serif]controlfile_record_keep_time=90 days petala leka[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]rman target / catalog user/psswd@catalogdatabase connect ayi[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]show all;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]ikkada [/font][/color][color=#282828][font=helvetica, arial, sans-serif]CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days; evala?[/font][/color] [color=#282828][font=helvetica, arial, sans-serif](nuv chepindi okati aithe ardham boss target database control lo min 7 days records aithe untai backup vi --correct e na)[/font][/color]
Recommended Posts