KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 [quote name='Silence..Please' timestamp='1360809321' post='1303274636'] mundhu yedho oka db backup undali kadha.. archive logs tho recover cheyataniki at later point .. 11gr2 nunchi Advanced Database Duplication(ADD) feature release chesaru .. u dont need a backup to restore the database.. active database unte dhaani nunchi u can create a database.. maku outage ayi whe we totally lost Primary database.. apudu.. standby ki switchover chesi standby db ni activate chesi.. we restored primary from standby database directly using ADD .. restore is pretty fast too using ADD [/quote] Deniki kosam em ayina parameter change cheyala,idi only for dataguard environment ki aa??
Gachibowli_Diwakar Posted February 14, 2013 Report Posted February 14, 2013 [quote name='KOTC' timestamp='1360859488' post='1303276982'] Deniki kosam em ayina parameter change cheyala,idi only for dataguard environment ki aa?? [/quote] em change cheyyakkarledu .. u can create standby database using ADD .. u can clone the database too using ADD .. refer to this link http://www.oracle-base.com/articles/11g/duplicate-database-using-rman-11gr2.php Active database duplication .. Advanced kadhu ..
Joey_Tribbiani Posted February 14, 2013 Report Posted February 14, 2013 Bhayya , maa backups catalog use chesi ru autai .. Catalog Database vere team maintain chestundi .. we only has access to Query using RMAN ... maa landscape lo 100+ databases untai .. RMAN backups nadustuai .. Is there any Query to give last successful FULL backup Date ?? OEM use chesi aina , RMAN ni Query chesi aina ,inka emaina backup Views ni query chesi aina aa data dorikidda ? Tried a lot , no luck .. evvarikaina teliste seppi punyam kattukondiii
KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 [quote name='Joey_Tribbiani' timestamp='1360863868' post='1303277520'] Bhayya , maa backups catalog use chesi ru autai .. Catalog Database vere team maintain chestundi .. we only has access to Query using RMAN ... maa landscape lo 100+ databases untai .. RMAN backups nadustuai .. Is there any Query to give last successful FULL backup Date ?? OEM use chesi aina , RMAN ni Query chesi aina ,inka emaina backup Views ni query chesi aina aa data dorikidda ? Tried a lot , no luck .. evvarikaina teliste seppi punyam kattukondiii [/quote] col STATUS format a9 col hrs format 999.99 select SESSION_KEY, INPUT_TYPE, STATUS, to_char(START_TIME,'mm/dd/yy hh24:mi') start_time, to_char(END_TIME,'mm/dd/yy hh24:mi') end_time, elapsed_seconds/3600 hrs from V$RMAN_BACKUP_JOB_DETAILS order by session_key; idi try cheyi bhayya rman target / rman >list backup summary; rman > list backup; rendu try cheyi
Joey_Tribbiani Posted February 14, 2013 Report Posted February 14, 2013 FULL ravatla Bhayya ... and also is there any way we can get Backup SIZE ? SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS ----------- ------------- --------- -------------- -------------- ------- 3907 ARCHIVELOG COMPLETED 12/06/12 10:50 12/06/12 10:56 .10 3910 ARCHIVELOG COMPLETED 12/06/12 16:27 12/06/12 16:38 .18 3913 DB INCR COMPLETED 12/07/12 04:21 12/07/12 10:21 6.01 3915 ARCHIVELOG COMPLETED 12/07/12 10:21 12/07/12 10:28 .12 3918 ARCHIVELOG COMPLETED 12/07/12 16:20 12/07/12 18:19 1.97 3921 DB INCR COMPLETED 12/08/12 04:20 12/08/12 06:13 1.88 3923 ARCHIVELOG COMPLETED 12/08/12 06:19 12/08/12 06:24 .10 3926 ARCHIVELOG COMPLETED 12/08/12 16:21 12/08/12 16:23 .04 3929 DB INCR COMPLETED 12/09/12 04:20 12/09/12 07:23 3.04 3931 ARCHIVELOG COMPLETED 12/09/12 07:24 12/09/12 07:31 .10 3934 ARCHIVELOG COMPLETED 12/09/12 16:20 12/09/12 16:23 .04
KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 [quote name='Joey_Tribbiani' timestamp='1360873062' post='1303278227'] FULL ravatla Bhayya ... and also is there any way we can get Backup SIZE ? SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS ----------- ------------- --------- -------------- -------------- ------- 3907 ARCHIVELOG COMPLETED 12/06/12 10:50 12/06/12 10:56 .10 3910 ARCHIVELOG COMPLETED 12/06/12 16:27 12/06/12 16:38 .18 3913 DB INCR COMPLETED 12/07/12 04:21 12/07/12 10:21 6.01 3915 ARCHIVELOG COMPLETED 12/07/12 10:21 12/07/12 10:28 .12 3918 ARCHIVELOG COMPLETED 12/07/12 16:20 12/07/12 18:19 1.97 3921 DB INCR COMPLETED 12/08/12 04:20 12/08/12 06:13 1.88 3923 ARCHIVELOG COMPLETED 12/08/12 06:19 12/08/12 06:24 .10 3926 ARCHIVELOG COMPLETED 12/08/12 16:21 12/08/12 16:23 .04 3929 DB INCR COMPLETED 12/09/12 04:20 12/09/12 07:23 3.04 3931 ARCHIVELOG COMPLETED 12/09/12 07:24 12/09/12 07:31 .10 3934 ARCHIVELOG COMPLETED 12/09/12 16:20 12/09/12 16:23 .04 [/quote] matter enti akkada script lo untndi bhayya adi DBincr ante incremental plus inka full kuda undachi,appudu nuv inka script loki velli chudali script lo chudu usually ga aithe RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE'; BACKUP [color=#ff0000]DATABASE[/color] SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 # recommended format FORMAT 'bk_%s_%p_%t' DATABASE; ante full ani chupistunidi nuv sql lo query cheste script lo backup $ RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'; BACKUP [color=#ff0000] $BACKUP_TYPE-------------------------idi script lo chudalii 0 ante level =0 ani 1 ante level= 1 ani edo untndi[/color] SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 # recommended format FORMAT 'bk_%s_%p_%t' DATABASE; inka oka option enti ante schudle adgtame inka
KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 [color=#282828][font=helvetica, arial, sans-serif]select[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]SESSION_KEY, INPUT_TYPE, STATUS,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]to_char(START_TIME,'mm/dd/yy hh24:mi') start_time,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]to_char(END_TIME,'mm/dd/yy hh24:mi') end_time,[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]elapsed_seconds/3600 hrs,[/font][/color] [color=#ff0000][font=helvetica, arial, sans-serif]output_bytes_display[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]from V$RMAN_BACKUP_JOB_DETAILS[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]order by session_key;[/font][/color] [color=#282828][font=helvetica, arial, sans-serif]output bytes diplay estundi[/font][/color]
KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 em ayindi bhayya resolve ayinda issue?
Joey_Tribbiani Posted February 14, 2013 Report Posted February 14, 2013 modifying the Query according to my requirement bhayya Avvagaane chepta , Thanks for Help bhayya
KOTC Posted February 14, 2013 Author Report Posted February 14, 2013 [quote name='Joey_Tribbiani' timestamp='1360877764' post='1303278779'] modifying the Query according to my requirement bhayya Avvagaane chepta , Thanks for Help bhayya [/quote] np bhayya query share cheyi bhayya useful avtundi evariki ayina Good luck
IWillWin Posted February 15, 2013 Report Posted February 15, 2013 Bhayya, neenu OracleDBA nerchukoni 9 months bench meeda vunaanu...evarainaa konchem job oppourtunity vuntey naaku information share cheyandi.... that would be very helpful for me and kind of you... Thanks.
bePLUS+ Posted February 15, 2013 Report Posted February 15, 2013 [quote name='IWillWin' timestamp='1360890509' post='1303279558'] Bhayya, neenu OracleDBA nerchukoni[size=6] 9 months bench[/size] meeda vunaanu...evarainaa konchem job oppourtunity vuntey naaku information share cheyandi.... that would be very helpful for me and kind of you... Thanks. [/quote] [size=4] [/size]
KOTC Posted February 15, 2013 Author Report Posted February 15, 2013 [quote name='Joey_Tribbiani' timestamp='1360877764' post='1303278779'] modifying the Query according to my requirement bhayya Avvagaane chepta , Thanks for Help bhayya [/quote] Quick note on how to monitor RMAN restore command: set lines 180 pages 1000 numwidth 15 column OPERATION for a8 column STATUS for a10 column OPERATION for a10 alter session set nls_date_format='YYYY.MM.DD HH24:MI:SS'; select OPERATION, STATUS, MBYTES_PROCESSED/1024 GB_PROCESSED, START_TIME, END_TIME, (END_TIME-START_TIME)*24*60 RUNTIME_MINS, trunc(INPUT_BYTES/1024/1024/1024,2) INPUT_GB, trunc(OUTPUT_BYTES/1024/1024/1024,2) OUTPUT_GB from V$RMAN_STATUS where START_TIME > sysdate - 1 and OPERATION = 'RESTORE'; idi online lo chusa bhayya entha time padtundi ani telsundi ne restore ki try it out
KOTC Posted February 15, 2013 Author Report Posted February 15, 2013 [quote name='IWillWin' timestamp='1360890509' post='1303279558'] Bhayya, neenu OracleDBA nerchukoni 9 months bench meeda vunaanu...evarainaa konchem job oppourtunity vuntey naaku information share cheyandi.... that would be very helpful for me and kind of you... Thanks. [/quote] evari tho ayina work chestava leka me vadi tho ne untava?
KOTC Posted February 15, 2013 Author Report Posted February 15, 2013 [quote name='Joey_Tribbiani' timestamp='1360873062' post='1303278227'] FULL ravatla Bhayya ... and also is there any way we can get Backup SIZE ? SESSION_KEY INPUT_TYPE STATUS START_TIME END_TIME HRS ----------- ------------- --------- -------------- -------------- ------- 3907 ARCHIVELOG COMPLETED 12/06/12 10:50 12/06/12 10:56 .10 3910 ARCHIVELOG COMPLETED 12/06/12 16:27 12/06/12 16:38 .18 3913 DB INCR COMPLETED 12/07/12 04:21 12/07/12 10:21 6.01 3915 ARCHIVELOG COMPLETED 12/07/12 10:21 12/07/12 10:28 .12 3918 ARCHIVELOG COMPLETED 12/07/12 16:20 12/07/12 18:19 1.97 3921 DB INCR COMPLETED 12/08/12 04:20 12/08/12 06:13 1.88 3923 ARCHIVELOG COMPLETED 12/08/12 06:19 12/08/12 06:24 .10 3926 ARCHIVELOG COMPLETED 12/08/12 16:21 12/08/12 16:23 .04 3929 DB INCR COMPLETED 12/09/12 04:20 12/09/12 07:23 3.04 3931 ARCHIVELOG COMPLETED 12/09/12 07:24 12/09/12 07:31 .10 3934 ARCHIVELOG COMPLETED 12/09/12 16:20 12/09/12 16:23 .04 [/quote] SELECT OPERATION, STATUS, OBJECT_TYPE, TO_CHAR(START_TIME,[color="navy"]'MM/DD/YYYY:HH:MI:SS'[/color]) AS START_TIME, TO_CHAR(END_TIME,[color="navy"]'MM/DD/YYYY:HH:MI:SS'[/color]) AS END_TIME FROM SYS.V_$RMAN_STATUS WHERE START_TIME > SYSDATE -1 AND OPERATION = [color="navy"]'BACKUP'[/color] AND OBJECT_TYPE = [color="navy"]'DB FULL'[/color] ORDER BY START_TIME DESC; [color=#000000][font=tahoma, verdana, sans-serif][size=2][background=rgb(242, 242, 242)]Change or remove OBJECT_TYPE as needed.[/background][/size][/font][/color]
Recommended Posts