nexus Posted January 10, 2013 Report Posted January 10, 2013 as far as i know Catalog database controlfile lo target database backup information undadhu.(Period) nuv "create catalog" command use chesi rman catalog create chestav(catalog here is a set of tables and repository to store target databases' backup information). ilaga create chesina tables lo target database backup information untundhi. Ni backups 90 days retain cheskovali ante [color=#282828][font=helvetica, arial, sans-serif]rman target / catalog user/psswd@catalogdatabase connect ayi [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]i[/font][/color][color=#282828][font=helvetica, arial, sans-serif]kkada [/font][/color][color=#282828][font=helvetica, arial, sans-serif]CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days; ani ivvu[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]last point correct.[/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color]
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357857173' post='1303087784'] as far as i know Catalog database controlfile lo target database backup information undadhu.(Period) nuv "create catalog" command use chesi rman catalog create chestav(catalog here is a set of tables and repository to store target databases' backup information). ilaga create chesina tables lo target database backup information untundhi. Ni backups 90 days retain cheskovali ante [color=#282828][font=helvetica, arial, sans-serif]rman target / catalog user/psswd@catalogdatabase connect ayi [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]i[/font][/color][color=#282828][font=helvetica, arial, sans-serif]kkada [/font][/color][color=#282828][font=helvetica, arial, sans-serif]CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days; ani ivvu[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]last point correct.[/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [/quote] ikkada doubt bhayya asalu e [color=#282828][font=helvetica, arial, sans-serif]CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]ekkada save avtundi control file lo na leka inka vere dagara na.vere dagara aithe ekkada.[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]So tables annav kadha vatini query cheyali ante rc_database kadha manam use cheyalisindi?[/font][/color]
KOTC Posted January 10, 2013 Author Report Posted January 10, 2013 [quote name='nexus' timestamp='1357857173' post='1303087784'] as far as i know Catalog database controlfile lo target database backup information undadhu.(Period) nuv "create catalog" command use chesi rman catalog create chestav(catalog here is a set of tables and repository to store target databases' backup information). ilaga create chesina tables lo target database backup information untundhi. Ni backups 90 days retain cheskovali ante [color=#282828][font=helvetica, arial, sans-serif]rman target / catalog user/psswd@catalogdatabase connect ayi [/font][/color] [color=#282828][font=helvetica, arial, sans-serif]i[/font][/color][color=#282828][font=helvetica, arial, sans-serif]kkada [/font][/color][color=#282828][font=helvetica, arial, sans-serif]CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 days; ani ivvu[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]last point correct.[/font][/color][color=#282828][font=helvetica, arial, sans-serif] [/font][/color] [/quote] Really appreciate mama patience ga na questions ki answers chesinaduku
nexus Posted January 10, 2013 Report Posted January 10, 2013 [quote] rac01> [b][color=#800080]rman target /[/color][/b] Recovery Manager: Release 11.2.0.X.X - Production on Thu Jan 10 16:39:42 2013 Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to t[i]arget database: NEXUS[/i] (DBID=1186899999) RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS; using target database control file instead of recovery catalog old RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS; new RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS; new RMAN configuration parameters are successfully stored [/quote] Above case lo nenu catalog database ki connect avaledu. So nenu config change cheyangane, target database control file(NEXUS db anamata naa case lo) lo update avthundhi. [quote] rac01>[color=#0000cd] [b]rman target / catalog rman_owner/xxxx@rmandb[/b][/color] Recovery Manager: Release 11.2.0.X.X - Production on Thu Jan 10 16:38:45 2013 Copyright © 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to [i]target database: NEXUS[/i] (DBID=1186899999) connected to recovery catalog database RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS; old RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS; new RMAN configuration parameters: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 90 DAYS; new RMAN configuration parameters are successfully stored [color=#ff0000]starting full resync of recovery catalog[/color] [color=#ff0000]full resync complete[/color] [/quote] Above case lo nenu target and catalog database ki connect ayaanu. Nenu config update cheyagane, target database(NEXUS db anamata) control file lo update ayindhi. Tharuvatha target database controlfile ni rman catalog tho sync chesindhi(ante rman catalog lo unna tables ni update chesindhi) Finally, rc_database anedhi aa bochudu catalog tables lo okanoka table. Inka chala tables untayi.
KOTC Posted January 11, 2013 Author Report Posted January 11, 2013 [quote name='nexus' timestamp='1357861807' post='1303088278'] Above case lo nenu catalog database ki connect avaledu. So nenu config change cheyangane, target database control file(NEXUS db anamata naa case lo) lo update avthundhi. Above case lo nenu target and catalog database ki connect ayaanu. Nenu config update cheyagane, target database(NEXUS db anamata) control file lo update ayindhi. Tharuvatha target database controlfile ni rman catalog tho sync chesindhi(ante rman catalog lo unna tables ni update chesindhi) Finally, rc_database anedhi aa bochudu catalog tables lo okanoka table. Inka chala tables untayi. [/quote] cool kaka rman target / catalog usr/pwsd@catalog database e case lo catalog database control file lo 90 days rentention annamata kadha??
nexus Posted January 11, 2013 Report Posted January 11, 2013 catalog database controlfile kaadhu...dhaniki target database ki sambandham ledhu asalu target database control file lo and catalog database lo unna rman catalog tables lo 90 days ani update avthundhi.
KOTC Posted January 11, 2013 Author Report Posted January 11, 2013 [quote name='nexus' timestamp='1357863399' post='1303088383'] catalog database controlfile kaadhu...dhaniki target database ki sambandham ledhu asalu target database control file lo and catalog database lo unna rman catalog tables lo 90 days ani update avthundhi. [/quote] target database lo 90 days info ante em ayina performance issues vastai antava bhayya?
nexus Posted January 11, 2013 Report Posted January 11, 2013 naku telisinantha varaku ravataniki reasons em lev ba..
KOTC Posted January 14, 2013 Author Report Posted January 14, 2013 [color=#333333]As we all know, RMAN maintains metadata about the target database and its backup and[/color] [color=#333333]recovery operations in the RMAN repository. The RMAN repository data is always in the control file of the target database. The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter controls how long backup records are kept in the control file before those records are re-used to hold information about more recent backups. By default this parameter set to 7 days.[/color] [color=#333333]Another copy of the RMAN repository data can also be saved in the recovery catalog.[/color] [color=#333333]Using a recovery catalog preserves RMAN repository information if the control file is lost, making it much easier to restore and recover following the loss of the control file. (A backup control file may not contain complete information about recent available backups.) The recovery catalog can also store a much more extensive history of your backups than the control file, due to limits on the number of control file records.[/color] [color=#333333]In addition to RMAN repository records, the recovery catalog can also hold RMAN stored scripts, sequences of RMAN commands for common backup tasks. Centralized storage of scripts in recovery catalog can be more convenient than working with command files.[/color] source:http://sabdarsyed.blogspot.com/2007/04/creating-recovery-catalog-rman-in.html
KOTC Posted January 14, 2013 Author Report Posted January 14, 2013 RA-19506: failed to create sequential file, name="bk_2951_1_804683951", parms="" ORA-27028: skgfqcre: sbtbackup returned error ORA-19511: Error received from media manager layer, error text: VxBSACreateObject: Failed with error: Server Status: the specified policy does not exist in the configuration database kaka e error gurchi em ayina idea undha??
KOTC Posted January 14, 2013 Author Report Posted January 14, 2013 select handle, media, to_char(start_time,'mm-dd-yyyy hh:mm:ss'), to_char(completion_time,'mm-dd-yyyy hh:mm:ss') from rman.rc_backup_piece;
Recommended Posts