RMAN Configuration for 2 nodes RAC Database

**hrishy** · 09-03-2007 06:38 AM

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

**habeebksa** · 09-03-2007 07:15 AM

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';

**hrishy** · 09-03-2007 07:29 AM

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

**habeebksa** · 09-03-2007 07:52 AM

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.

**hrishy** · 09-03-2007 08:03 AM

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

**habeebksa** · 09-03-2007 08:18 AM

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.

**hrishy** · 09-03-2007 08:20 AM

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

**habeebksa** · 09-03-2007 08:59 AM

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

**hrishy** · 09-04-2007 12:11 AM

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 ?

Thread: RMAN Configuration for 2 nodes RAC Database

Thread Tools

Display