DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 29 of 29

Thread: RMAN Configuration for 2 nodes RAC Database

  1. #21
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you please post the full path where the backup pieces are available on the OS ?

    Can you post the values of RMAN CONFIGURATION Parameters especially the retention policy ?

    regards
    Hrishy

  2. #22
    Join Date
    Aug 2007
    Posts
    54
    Hi, Hrishy

    The OS path for rman backup is

    /makkdb1-bk/rman

    And the configuration parameters are as follows:

    These parameters are set before taking datafiles backup:

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK;
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/makkdb1-bk/rma
    n/%F';
    configuration for DISK channel 2 is ignored
    configuration for DISK channel 3 is ignored
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/makkdb1-bk/rman/%U';
    CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
    CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
    CONFIGURE MAXSETSIZE TO 5 G;
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/9iRAC/dbs/snapcf_rcdb1.f';



    These parameters are set before taking backup of archivelogs: only one change mark in red.

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
    CONFIGURE BACKUP OPTIMIZATION ON;
    CONFIGURE DEFAULT DEVICE TYPE TO DISK;
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/makkdb1-bk/rman/%F';
    configuration for DISK channel 2 is ignored
    configuration for DISK channel 3 is ignored
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
    CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1;
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
    CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/makkdb1-bk/rman/arc_%U';
    CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
    CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT '/makkdb2-bk/rman/%U';
    CONFIGURE MAXSETSIZE TO 5 G;
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/9iRAC/dbs/snapcf_rcdb1.f';
    Last edited by habeebksa; 09-03-2007 at 07:19 AM.

  3. #23
    Join Date
    Jan 2001
    Posts
    2,828
    HI

    What does list expired backupset return please post the output

    Are you sure that the backup was lying there is not more then 30 days old ?

    regards
    Hrishy
    Last edited by hrishy; 09-03-2007 at 07:36 AM.

  4. #24
    Join Date
    Aug 2007
    Posts
    54

    RMAN Configuration for 2 nodes RAC Database

    Hi, Hrishy.

    The output of the command is scrolling up on screen, any condition can be given to limit output and put in this window.

  5. #25
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you paste the output of

    Code:
    select
      b.NAME,
      a.COMPLETION_TIME,
      a.MEDIA,
      a.STATUS,
      a.HANDLE
     from
      rc_backup_piece a,
      rc_database b
     where a.DB_KEY = b.DB_KEY
    and HANDLE  in 
    ('/makkdb1-bk/rman/4fiq9uj1_1_1',
    '/makkdb1-bk/rman/4giq9uko_1_1')
     order by b.NAME, a.COMPLETION_TIME, a.STATUS

    regards
    Hrishy
    Last edited by hrishy; 09-03-2007 at 08:07 AM.

  6. #26
    Join Date
    Aug 2007
    Posts
    54

    RMAN Configuration for 2 nodes RAC Database

    Hi, Hrishy. The shown ls command shows that the latest backup files exists on disk:

    $ cd /makkdb1-bk/rman
    $ ls
    5aiqjugs_1_1 5fiqjuuq_1_1 5kiqjv7p_1_1
    5biqjuij_1_1 5giqjv0i_1_1 arc_5miqjvbh_1_1
    5ciqjuli_1_1 5hiqjv29_1_1 arc_5niqjvcm_1_1
    5diqjuq4_1_1 5iiqjv40_1_1 c-521704063-20070829-00
    5eiqjusp_1_1 5jiqjv5o_1_1 c-521704063-20070829-01


    Hrishy, the files in the makkdb2-bk/oracle-bk are daily archive log files backup.

    SQL> select handle
    2 from rc_backup_piece
    3 where completion_time between sysdate-30 and sysdate;

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/arc_12ionbvd_1_1
    /makkdb2-bk/oracle-bk/arc_1diov93e_1_1
    /makkdb2-bk/oracle-bk/arc_1fiov93k_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070809-01
    /makkdb2-bk/oracle-bk/arc_2kipf3bd_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070815-00
    /makkdb2-bk/oracle-bk/arc_2mipf5d2_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070815-01
    /makkdb2-bk/oracle-bk/arc_2sipkc36_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070817-00
    /makkdb2-bk/oracle-bk/arc_52iqenre_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/c-521704063-20070827-00
    /makkdb2-bk/oracle-bk/arc_5riqmkvc_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070830-00
    /makkdb2-bk/oracle-bk/arc_5tiqmn11_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070830-01
    /makkdb2-bk/oracle-bk/arc_61iqpbd1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070831-01
    /makkdb2-bk/oracle-bk/arc_0pioi37c_1_1
    /makkdb2-bk/oracle-bk/arc_0qioi37g_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070804-01
    /makkdb2-bk/oracle-bk/arc_11ionbvb_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/1pip52de_1_1
    /makkdb1-bk/rman/1qip52f5_1_1
    /makkdb1-bk/rman/1rip52i4_1_1
    /makkdb1-bk/rman/1sip52ml_1_1
    /makkdb1-bk/rman/1tip52pb_1_1
    /makkdb1-bk/rman/1uip52rc_1_1
    /makkdb1-bk/rman/1vip52t3_1_1
    /makkdb1-bk/rman/20ip52ur_1_1
    /makkdb1-bk/rman/21ip530i_1_1
    /makkdb1-bk/rman/22ip532a_1_1
    /makkdb1-bk/rman/23ip534b_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/c-521704063-20070811-01
    /makkdb1-bk/rman/arc_25ip5384_1_1
    /makkdb1-bk/rman/arc_26ip5398_1_1
    /makkdb1-bk/rman/c-521704063-20070811-02
    /makkdb2-bk/oracle-bk/arc_3tipuvl1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070821-01
    /makkdb2-bk/oracle-bk/arc_3viq1hve_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070822-00
    /makkdb2-bk/oracle-bk/arc_41iq1k11_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070822-01
    /makkdb2-bk/oracle-bk/arc_47iq6qn6_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/c-521704063-20070824-00
    /makkdb2-bk/oracle-bk/arc_65iqrvp2_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070901-01
    /makkdb2-bk/oracle-bk/arc_30ipn0fe_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070818-00
    /makkdb2-bk/oracle-bk/arc_16ioq0bg_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070807-00
    /makkdb2-bk/oracle-bk/c-521704063-20070809-00
    /makkdb2-bk/oracle-bk/arc_2iipch13_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070814-01
    /makkdb2-bk/oracle-bk/arc_3pipsb91_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/c-521704063-20070820-01
    /makkdb2-bk/oracle-bk/arc_45iq48d3_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070823-01
    /makkdb1-bk/rman/5aiqjugs_1_1
    /makkdb1-bk/rman/5biqjuij_1_1
    /makkdb1-bk/rman/5ciqjuli_1_1
    /makkdb1-bk/rman/5diqjuq4_1_1
    /makkdb1-bk/rman/5eiqjusp_1_1
    /makkdb1-bk/rman/5fiqjuuq_1_1
    /makkdb1-bk/rman/5giqjv0i_1_1
    /makkdb1-bk/rman/5hiqjv29_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/5iiqjv40_1_1
    /makkdb1-bk/rman/5jiqjv5o_1_1
    /makkdb1-bk/rman/5kiqjv7p_1_1
    /makkdb1-bk/rman/c-521704063-20070829-00
    /makkdb2-bk/oracle-bk/c-521704063-20070805-01
    /makkdb2-bk/oracle-bk/arc_15ioq0ba_1_1
    /makkdb1-bk/rman/arc_5miqjvbh_1_1
    /makkdb1-bk/rman/arc_5niqjvcm_1_1
    /makkdb1-bk/rman/c-521704063-20070829-01
    /makkdb2-bk/oracle-bk/c-521704063-20070812-00
    /makkdb2-bk/oracle-bk/c-521704063-20070812-01

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/arc_3nips97c_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070820-00
    /makkdb2-bk/oracle-bk/arc_43iq46b8_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070823-00
    /makkdb2-bk/oracle-bk/arc_54iqept1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070827-01
    /makkdb2-bk/oracle-bk/arc_63iqrtnd_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070901-00
    /makkdb2-bk/oracle-bk/arc_67iqui3e_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070902-00
    /makkdb2-bk/oracle-bk/arc_69iquk51_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/c-521704063-20070902-01
    /makkdb2-bk/oracle-bk/arc_19ioskna_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070808-00
    /makkdb2-bk/oracle-bk/c-521704063-20070808-01
    /makkdb2-bk/oracle-bk/arc_1iip1tfj_1_1
    /makkdb2-bk/oracle-bk/arc_1lip4hrh_1_1
    /makkdb2-bk/oracle-bk/arc_1mip4hrk_1_1
    /makkdb2-bk/oracle-bk/arc_3riputje_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070821-00
    /makkdb2-bk/oracle-bk/arc_4biq9f3b_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070825-00

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/arc_4uiqc3f7_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070826-00
    /makkdb2-bk/oracle-bk/arc_5piqk0jc_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070829-02
    /makkdb2-bk/oracle-bk/c-521704063-20070807-01
    /makkdb2-bk/oracle-bk/c-521704063-20070813-00
    /makkdb2-bk/oracle-bk/arc_2qiphpp1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070816-01
    /makkdb2-bk/oracle-bk/arc_4diq9h51_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070825-01
    /makkdb1-bk/rman/4fiq9uj1_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/4giq9uko_1_1
    /makkdb1-bk/rman/4hiq9unn_1_1
    /makkdb1-bk/rman/4iiq9us9_1_1
    /makkdb1-bk/rman/4jiq9uuu_1_1
    /makkdb1-bk/rman/4kiq9v0v_1_1
    /makkdb1-bk/rman/4liq9v2n_1_1
    /makkdb1-bk/rman/4miq9v4e_1_1
    /makkdb1-bk/rman/4niq9v65_1_1
    /makkdb1-bk/rman/4oiq9v7t_1_1
    /makkdb1-bk/rman/4piq9v9u_1_1
    /makkdb1-bk/rman/c-521704063-20070825-02

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/arc_4riq9vdd_1_1
    /makkdb1-bk/rman/arc_4siq9veh_1_1
    /makkdb1-bk/rman/c-521704063-20070825-03
    /makkdb2-bk/oracle-bk/arc_50iqc5h1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070826-01
    /makkdb2-bk/oracle-bk/arc_56iqhc7f_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070828-00
    /makkdb2-bk/oracle-bk/arc_58iqhe94_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070828-01
    /makkdb2-bk/oracle-bk/arc_5viqp9be_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070831-00

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/arc_1aioskng_1_1
    /makkdb2-bk/oracle-bk/arc_1hip1tfh_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070810-00
    /makkdb2-bk/oracle-bk/c-521704063-20070810-01
    /makkdb2-bk/oracle-bk/c-521704063-20070811-00
    /makkdb2-bk/oracle-bk/arc_28ip7679_1_1
    /makkdb2-bk/oracle-bk/arc_29ip767e_1_1
    /makkdb2-bk/oracle-bk/arc_2cip9qjc_1_1
    /makkdb2-bk/oracle-bk/arc_2dip9qje_1_1
    /makkdb2-bk/oracle-bk/arc_2oiphnne_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070816-00

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/arc_49iq6sp3_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070824-01
    /makkdb2-bk/oracle-bk/c-521704063-20070804-00
    /makkdb2-bk/oracle-bk/c-521704063-20070805-00
    /makkdb2-bk/oracle-bk/arc_0tioknjc_1_1
    /makkdb2-bk/oracle-bk/arc_0uioknjh_1_1
    /makkdb2-bk/oracle-bk/arc_2gipcevh_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070814-00
    /makkdb2-bk/oracle-bk/arc_2uipke52_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070817-01
    /makkdb2-bk/oracle-bk/arc_32ipn2h2_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb2-bk/oracle-bk/c-521704063-20070818-01
    /makkdb2-bk/oracle-bk/c-521704063-20070806-00
    /makkdb1-bk/rman/34ipnfsl_1_1
    /makkdb1-bk/rman/35ipnfud_1_1
    /makkdb1-bk/rman/36ipng1c_1_1
    /makkdb1-bk/rman/37ipng5t_1_1
    /makkdb1-bk/rman/38ipng8i_1_1
    /makkdb1-bk/rman/39ipngak_1_1
    /makkdb1-bk/rman/3aipngcb_1_1
    /makkdb1-bk/rman/3bipnge2_1_1
    /makkdb1-bk/rman/3cipngfq_1_1

    HANDLE
    --------------------------------------------------------------------------------
    /makkdb1-bk/rman/3dipnghh_1_1
    /makkdb1-bk/rman/3eipngjj_1_1
    /makkdb1-bk/rman/c-521704063-20070818-02
    /makkdb1-bk/rman/arc_3gipngn1_1_1
    /makkdb1-bk/rman/arc_3hipngns_1_1
    /makkdb1-bk/rman/c-521704063-20070818-03
    /makkdb2-bk/oracle-bk/arc_3jippkr7_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070819-00
    /makkdb2-bk/oracle-bk/arc_3lippmt1_1_1
    /makkdb2-bk/oracle-bk/c-521704063-20070819-01

    175 rows selected.

  7. #27
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you post the output of

    Code:
    select
      b.NAME,
      a.COMPLETION_TIME,
      a.MEDIA,
      a.STATUS,
      a.HANDLE
     from
      rc_backup_piece a,
      rc_database b
     where a.DB_KEY = b.DB_KEY
    and HANDLE  in 
    ('/makkdb1-bk/rman/4fiq9uj1_1_1',
    '/makkdb1-bk/rman/4giq9uko_1_1')
     order by b.NAME, a.COMPLETION_TIME, a.STATUS

  8. #28
    Join Date
    Aug 2007
    Posts
    54

    RMAN Configuration for 2 nodes RAC Database

    Hi, Hrishy. the output

    SQL> select b.name,a.completion_time,
    2 a.media,a.status,a.handle
    3 from rc_backup_piece a,
    4 rc_database b
    5 where a.DB_KEY=b.DB_KEY
    6 and handle in
    7 ('/makkdb1-bk/rman/4fiq9uj1_1_1','/makkdb1-bk/rman/4giq9uko_1_1')
    8 order by b.name,a.completion_time,a.status;

    NAME COMPLETIO MEDIA
    -------- --------- --------------------------------------------------------------------------------
    S
    -
    HANDLE
    ----------------------------------------------------------------------------------------------------
    RACDB 25-AUG-07
    X
    /makkdb1-bk/rman/4fiq9uj1_1_1

    RACDB 25-AUG-07
    X
    /makkdb1-bk/rman/4giq9uko_1_1

  9. #29
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Well rman says that your backups have expired based on the contents of the catalog.

    I would suggest you do a clean test just to discount something funny from this whole exercise

    First delete the expired

    1)delete expired backup
    2)backup database plus archivelog
    3)Backup the files to some other location or tape
    3)remove the files using host command using rm
    4)run crosscheck command rman should report the backup as expired
    5)restore the files to the same location
    6)run crosscheck command rman should mark the backups as available

    Let me know if you are able to reproduce whatever happened till now

    regards
    Hrishy


    I hope the permissions on these files /makkdb1-bk/rman/4fiq9uj1_1_1 are 666
    so rman can read them ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width