-
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
-
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.
-
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.
-
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.
-
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.
-
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.
-
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
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|