10gRMAN.txt 2005-08-16 Bikle ----------------- This file contains a simple 10g rman demo. Under 10g, rman has been simplified. sqlplus '/as sysdba' 18:04:22 SQL> ALTER SYSTEM SET db_recovery_file_dest_size=166G; System altered. Elapsed: 00:00:00.01 Notice that I need to create a directory for the flasharea; Oracle is not smart enough to do it. 22:59:43 SQL> ALTER SYSTEM SET db_recovery_file_dest='/oradat/XXOT/flasharea'; ALTER SYSTEM SET db_recovery_file_dest='/oradat/XXOT/flasharea' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory SVR4 Error: 2: No such file or directory Elapsed: 00:00:00.02 23:09:06 SQL> !mkdir /oradat/XXOT/flasharea/ 23:09:25 SQL> ALTER SYSTEM SET db_recovery_file_dest='/oradat/XXOT/flasharea'; System altered. Elapsed: 00:00:00.85 23:09:32 SQL> bikle-db10:/oradat/XXOT/flasharea> $ORACLE_HOME/bin/rman target / Recovery Manager: Release 10.1.0.4.0 - 64bit Production Copyright (c) 1995, 2004, Oracle. All rights reserved. connected to target database: XXOT (DBID=2636036423) RMAN> backup database; Starting backup at 2005-08-15 using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=285 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current controlfile in backupset input datafile fno=00023 name=/oradat/XXOT/bi/zz_search/zz_search_200505/xxot_zz_search_200505_data00.dbf input datafile fno=00110 name=/oradat/XXOT/data2/lspend/xxot_lspend_data00.dbf input datafile fno=00113 name=/oradat/XXOT/index/lindx/xxot_lindx00.dbf input datafile fno=00080 name=/oradat/XXOT/undo/xxot_undotbs2_undo04.dbf input datafile fno=00081 name=/oradat/XXOT/undo/xxot_undotbs2_undo05.dbf input datafile fno=00078 name=/oradat/XXOT/undo/xxot_undotbs2_undo02.dbf input datafile fno=00011 name=/oradat/XXOT/data/xxot_data05.dbf input datafile fno=00017 name=/oradat/XXOT/partner/ksaj/ksajdata/xxot_ksajdata_data00.dbf input datafile fno=00034 name=/oradat/XXOT/data/o1_mf_data_z35nk3qn_.dbf input datafile fno=00074 name=/oradat/XXOT/data/o1_mf_data_z35pvl9d_.dbf input datafile fno=00040 name=/oradat/XXOT/data/o1_mf_data_z35pscg1_.dbf input datafile fno=00087 name=/oradat/XXOT/index/sindx/xxot_sindx03.dbf input datafile fno=00044 name=/oradat/XXOT/bi/bidata/o1_mf_bidata2_zfzckqcc_.dbf input datafile fno=00008 name=/oradat/XXOT/data/xxot_data02.dbf input datafile fno=00005 name=/oradat/XXOT/data/xxot_data2_data01.dbf input datafile fno=00089 name=/oradat/XXOT/index/mindx/xxot_mindx01.dbf input datafile fno=00007 name=/oradat/XXOT/data/xxot_data01.dbf input datafile fno=00085 name=/oradat/XXOT/index/sindx/xxot_sindx01.dbf input datafile fno=00014 name=/oradat/XXOT/ors/o1_mf_orsindx_zdt6wtkp_.dbf input datafile fno=00057 name=/oradat/XXOT/listings/espend/xxot_espend_data02.dbf input datafile fno=00075 name=/oradat/XXOT/data2/cdspend/xxot_cdspend_data00.dbf input datafile fno=00077 name=/oradat/XXOT/data2/cdspend/xxot_cdspend_data02.dbf input datafile fno=00086 name=/oradat/XXOT/index/sindx/xxot_sindx02.dbf input datafile fno=00107 name=/oradat/XXOT/data2/cdspend/xxot_cdspend_data03.dbf input datafile fno=00109 name=/oradat/XXOT/data2/ldspend/xxot_ldspend_data00.dbf input datafile fno=00012 name=/oradat/XXOT/debug/o1_mf_debug_zcjdkz6z_.dbf input datafile fno=00027 name=/oradat/XXOT/system/sysaux01.dbf input datafile fno=00105 name=/oradat/XXOT/index/campaign_website_editidx/xxot_campaign_website_editidx_indx00.dbf input datafile fno=00092 name=/oradat/XXOT/index/editidx/xxot_editidx_indx00.dbf input datafile fno=00100 name=/oradat/XXOT/index/websiteidx/xxot_websiteidx_indx01.dbf input datafile fno=00104 name=/oradat/XXOT/index/category_website_editidx/xxot_category_website_editidx_indx01.dbf input datafile fno=00026 name=/oradat/XXOT/mviews/xxot_mviews_data02.dbf input datafile fno=00058 name=/oradat/XXOT/listings/espend/xxot_espend_data03.dbf input datafile fno=00060 name=/oradat/XXOT/listings/espend/xxot_espend_data05.dbf input datafile fno=00019 name=/oradat/XXOT/partner/ksaj/ksajindx/xxot_ksajindx_indx00.dbf input datafile fno=00097 name=/oradat/XXOT/index/website_editidx/xxot_website_editidx_indx00.dbf input datafile fno=00102 name=/oradat/XXOT/index/website_editidx/xxot_website_editidx_indx02.dbf input datafile fno=00001 name=/oradat/XXOT/system/xxot_system01.dbf input datafile fno=00099 name=/oradat/XXOT/index/websiteidx/xxot_websiteidx_indx00.dbf input datafile fno=00083 name=/oradat/XXOT/ors/xxot_orsindx_indx01.dbf input datafile fno=00054 name=/oradat/XXOT/listings/ldata/xxot_ldata_data01.dbf input datafile fno=00021 name=/oradat/XXOT/partner/ksaj/ksajmview/xxot_ksajmview_data00.dbf input datafile fno=00024 name=/oradat/XXOT/mviews/xxot_mviews_data01.dbf input datafile fno=00094 name=/oradat/XXOT/index/category_websiteidx/xxot_category_websiteidx_indx01.dbf input datafile fno=00020 name=/oradat/XXOT/index2/o1_mf_indx2_08tc5rtc_.dbf input datafile fno=00003 name=/oradat/XXOT/users/xxot_users01.dbf input datafile fno=00006 name=/oradat/XXOT/bi/bidata/o1_mf_bidata_zbxspnqk_.dbf input datafile fno=00025 name=/oradat/XXOT/partner/ksaj/ksajzz_search/ksajzz_search_200507/xxot_ksajzz_search_200507_data00.dbf channel ORA_DISK_1: starting piece 1 at 2005-08-15 channel ORA_DISK_1: finished piece 1 at 2005-08-15 piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_15/o1_mf_ncndf_TAG20050815T231120_1j30whlr_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:37:47 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00032 name=/oradat/XXOT/data/xxot_data2_data00.dbf input datafile fno=00016 name=/oradat/XXOT/data/o1_mf_data2_zfdmfm58_.dbf input datafile fno=00112 name=/oradat/XXOT/data2/lspend/xxot_lspend_data01.dbf input datafile fno=00079 name=/oradat/XXOT/undo/xxot_undotbs2_undo03.dbf input datafile fno=00049 name=/oradat/XXOT/undo/xxot_undotbs2_undo01.dbf input datafile fno=00048 name=/oradat/XXOT/undo/xxot_undotbs2_undo00.dbf input datafile fno=00053 name=/oradat/XXOT/migdata/o1_mf_migdata_z2mzz2px_.dbf input datafile fno=00091 name=/oradat/XXOT/listings/listing/listing_data01.dbf input datafile fno=00090 name=/oradat/XXOT/listings/listing/listing_data00.dbf input datafile fno=00038 name=/oradat/XXOT/data/o1_mf_data_z35prc0k_.dbf input datafile fno=00073 name=/oradat/XXOT/data/o1_mf_data_z35ptcyh_.dbf input datafile fno=00047 name=/oradat/XXOT/index/listingidx/listingidx_indx01.dbf input datafile fno=00043 name=/oradat/XXOT/bi/bidata/o1_mf_bidata2_zfzckb75_.dbf input datafile fno=00041 name=/oradat/XXOT/bi/bidata/o1_mf_bidata2_zfzchrks_.dbf input datafile fno=00009 name=/oradat/XXOT/data/xxot_data03.dbf input datafile fno=00046 name=/oradat/XXOT/index/listingidx/listingidx_indx00.dbf input datafile fno=00010 name=/oradat/XXOT/data/xxot_data04.dbf input datafile fno=00042 name=/oradat/XXOT/bi/bidata/o1_mf_bidata2_zfzcjy8c_.dbf input datafile fno=00055 name=/oradat/XXOT/listings/espend/xxot_espend_data00.dbf input datafile fno=00056 name=/oradat/XXOT/listings/espend/xxot_espend_data01.dbf input datafile fno=00062 name=/oradat/XXOT/listings/espend/xxot_espend_data07.dbf input datafile fno=00076 name=/oradat/XXOT/data2/cdspend/xxot_cdspend_data01.dbf input datafile fno=00084 name=/oradat/XXOT/index/sindx/xxot_sindx00.dbf input datafile fno=00088 name=/oradat/XXOT/index/mindx/xxot_mindx00.dbf input datafile fno=00108 name=/oradat/XXOT/data2/cdspend/xxot_cdspend_data04.dbf input datafile fno=00111 name=/oradat/XXOT/data2/pdspend/xxot_pdspend_data00.dbf input datafile fno=00013 name=/oradat/XXOT/ors/o1_mf_orsdata_zdt6scth_.dbf input datafile fno=00103 name=/oradat/XXOT/index/category_website_editidx/xxot_category_website_editidx_indx00.dbf input datafile fno=00106 name=/oradat/XXOT/index/campaign_website_editidx/xxot_campaign_website_editidx_indx01.dbf input datafile fno=00101 name=/oradat/XXOT/index/websiteidx/xxot_websiteidx_indx02.dbf input datafile fno=00022 name=/oradat/XXOT/mviews/xxot_mviews_data00.dbf input datafile fno=00028 name=/oradat/XXOT/mviews/xxot_mviews_data03.dbf input datafile fno=00059 name=/oradat/XXOT/listings/espend/xxot_espend_data04.dbf input datafile fno=00061 name=/oradat/XXOT/listings/espend/xxot_espend_data06.dbf input datafile fno=00096 name=/oradat/XXOT/index/editidx/xxot_editidx_indx01.dbf input datafile fno=00098 name=/oradat/XXOT/index/website_editidx/xxot_website_editidx_indx01.dbf input datafile fno=00082 name=/oradat/XXOT/ors/xxot_orsdata_data01.dbf input datafile fno=00004 name=/oradat/XXOT/tools/xxot_tools01.dbf input datafile fno=00002 name=/oradat/XXOT/migdata/o1_mf_migdata_zbxs6j9n_.dbf input datafile fno=00095 name=/oradat/XXOT/index/category_websiteidx/xxot_category_websiteidx_indx02.dbf input datafile fno=00050 name=/oradat/XXOT/listings/ldata/xxot_ldata_data00.dbf input datafile fno=00052 name=/oradat/XXOT/bi/bidata/o1_mf_bidata_z2mkvmdx_.dbf input datafile fno=00093 name=/oradat/XXOT/index/category_websiteidx/xxot_category_websiteidx_indx00.dbf input datafile fno=00018 name=/oradat/XXOT/index2/o1_mf_indx2_08tc4lvz_.dbf input datafile fno=00051 name=/oradat/XXOT/listings/xxot/o1_mf_xxot_z2mkv4jb_.dbf input datafile fno=00015 name=/oradat/XXOT/bi/bidata/o1_mf_bidata_zfdg9hhh_.dbf channel ORA_DISK_1: starting piece 1 at 2005-08-15 channel ORA_DISK_1: finished piece 1 at 2005-08-16 piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_15/o1_mf_nnndf_TAG20050815T231120_1j3336p7_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:41:07 Finished backup at 2005-08-16 RMAN> bikle-db10:/oradat/XXOT/arch> df -k . Filesystem kbytes used avail capacity Mounted on /dev/dsk/c3t0d0s6 842339968 665315649 168600920 80% /disks/xxot1-128-10 bikle-db10:/oradat/XXOT/arch> bikle-db10:/oradat/XXOT> ls ./ bi/ data2/ index/ migdata/ ors/ redo2/ tempts/ users/ ../ control/ debug/ index2/ mviews/ partner/ system/ tools/ arch/ data/ flasharea/ listings/ nohup.out redo1/ temp/ undo/ bikle-db10:/oradat/XXOT> du -sk flasharea 144104196 flasharea bikle-db10:/oradat/XXOT> RMAN> BACKUP CURRENT CONTROLFILE FOR STANDBY; Starting backup at 2005-08-16 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including standby controlfile in backupset channel ORA_DISK_1: starting piece 1 at 2005-08-16 channel ORA_DISK_1: finished piece 1 at 2005-08-16 piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_16/o1_mf_ncnnf_TAG20050816T080111_1j3zxrnc_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 Finished backup at 2005-08-16 RMAN> quit Recovery Manager complete. bikle-db10:/oradat/XXOT/flasharea> After running some more experiments with RMAN, I ended up with more backups than I wanted. So, I issued a simple command to remove all backups except the latest one: RMAN> DELETE OBSOLETE REDUNDANCY = 1; using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 4405 2005-07-29 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025730.ARC Archive Log 4408 2005-07-29 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025731.ARC Archive Log 4411 2005-07-29 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025732.ARC snip Archive Log 9848 2005-08-17 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000027616_0488295169.ARC Archive Log 9849 2005-08-17 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000027617_0488295169.ARC Archive Log 9850 2005-08-17 /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000027618_0488295169.ARC Backup Set 6 2005-08-17 Backup Piece 6 2005-08-17 /oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_17/o1_mf_ncnnf_TAG20050817T133145_1j77ols2_.bkp Controlfile Copy 3768 2005-08-17 /tmp/ctl.ctl Controlfile Copy 3769 2005-08-17 /tmp/stb2005-08-17-17-05.ctl Controlfile Copy 3806 2005-08-22 /tmp/xxot_bk_control.ctl Controlfile Copy 3807 2005-08-22 /oradat/XXOT/control/xxot_bk_control.ctl Controlfile Copy 3808 2005-08-22 /tmp/xxot_stb_control.ctl Do you really want to delete the above objects (enter YES or NO)? yesplease "yesplease" is an invalid response - please re-enter. Do you really want to delete the above objects (enter YES or NO)? yes deleted backup piece backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_15/o1_mf_ncndf_TAG20050815T231120_1j30whlr_.bkp recid=1 stamp=566435487 deleted backup piece backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_15/o1_mf_nnndf_TAG20050815T231120_1j3336p7_.bkp recid=2 stamp=566437750 deleted backup piece backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_16/o1_mf_ncnnf_TAG20050816T080111_1j3zxrnc_.bkp recid=3 stamp=566467272 deleted controlfile copy controlfile copy filename=/oradat/XXOT/control/xxot_stb.ctl recid=3759 stamp=566501186 deleted backup piece backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_17/o1_mf_ncnnf_TAG20050817T133145_1j77ols2_.bkp recid=6 stamp=566573506 deleted controlfile copy controlfile copy filename=/tmp/ctl.ctl recid=3768 stamp=566576032 deleted controlfile copy controlfile copy filename=/tmp/stb2005-08-17-17-05.ctl recid=3769 stamp=566586402 deleted controlfile copy controlfile copy filename=/tmp/xxot_bk_control.ctl recid=3806 stamp=566978761 deleted controlfile copy controlfile copy filename=/oradat/XXOT/control/xxot_bk_control.ctl recid=3807 stamp=566978762 deleted controlfile copy controlfile copy filename=/tmp/xxot_stb_control.ctl recid=3808 stamp=566978763 Deleted 10 objects RMAN-06207: WARNING: 1889 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ========================== RMAN-06212: Object Type Filename/Handle RMAN-06213: --------------- --------------------------------------------------- RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025730.ARC RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025731.ARC RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025732.ARC RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000025733.ARC snip RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000027617_0488295169.ARC RMAN-06214: Archivelog /var/opt/oracle/admin/XXOT/arch/XXOT_0001_0000027618_0488295169.ARC RMAN> I looked up CROSSCHECK in the rman docs and followed a simple example they had there: RMAN> CROSSCHECK BACKUP; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_17/o1_mf_ncndf_TAG20050817T112251_1j703z17_.bkp recid=4 stamp=566565775 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_17/o1_mf_nnndf_TAG20050817T112251_1j726fp6_.bkp recid=5 stamp=566567901 Crosschecked 2 objects RMAN> I see CROSSCHECK as a method for synchronizing RMAN metadata with the actual backups I have on disk (or tape, but I'm not currently using tape). Here is a demo of backing up just one tablespace: RMAN> BACKUP TABLESPACE SYSTEM; Starting backup at 2005-08-22 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current controlfile in backupset input datafile fno=00001 name=/oradat/XXOT/system/xxot_system01.dbf channel ORA_DISK_1: starting piece 1 at 2005-08-22 channel ORA_DISK_1: finished piece 1 at 2005-08-22 piece handle=/oradat/XXOT/flasharea/PR_XXOT/backupset/2005_08_22/o1_mf_ncndf_TAG20050822T170643_1jnt4o19_.bkp comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26 Finished backup at 2005-08-22 RMAN>