This discussion is archived
1 2 Previous Next 28 Replies Latest reply: Apr 30, 2013 1:20 AM by yxes2013 Go to original post RSS
  • 15. Re: fast recovery area 10g
    asahide Expert
    Currently Being Moderated
    del...

    Edited by: asahide on 2013/04/30 14:12
  • 16. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    THE ARCHIVELOG BACKUP MUST BE AFTER THE DATABASE BACKUP. you still don't understand it, do you ???
    run {
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    backup database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    BACKUP ARCHIVELOG ALL;
    delete obsolete;
    }
    Hemant K Chitale
  • 17. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thats not what you said earlier :P :(
    I would advice you to put or run the CROSSCHECK ARCHIVELOG ALL and DELETE [NOPROMPT] EXPIRED ARCHIVELOG ALL before the BACKUP >DATABASE;
    So i put the BACKUP DATABASE command at the last ;) So that all commands are before it.

    Is it clear?
  • 18. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    I did NOT say "BACKUP ARCHIVELOG before BACKUP DATABASE". I did even refer to "..subsequent BACKUP ARCHIVELOG".

    You really seem to be not paying attention.

    Hemant K Chitale
  • 19. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thanks hem,

    Your command sequence seems to work. I run it and I got this warning?
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_769_8qylx38n_.arc recid=708 stamp=814106531
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814106525_8qylwxtb_.bkp recid=19 stamp=814106525
    deleted archive log
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_768_8qylx2fq_.arc recid=707 stamp=814106531
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814110133_8qypfosh_.bkp recid=21 stamp=814110133
    Deleted 9 objects
    
    RMAN-06207: WARNING: 5 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: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T123839_8qylpj1z_.bkp
    
    
    Recovery Manager complete.
    Why it says to CROSSCHECK again? it is becoming an infinite crosschecking?

    It is nice to know that dbvisit being found. I did not know it is there ;) How do I display all hidden sofwares installed against our database?
    Does it deletes the archivelogs?
  • 20. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
    (and the others)
    is a Backup Piece.

    You need to have them crosschecked with CROSSCHECK BACKUP.
    They can then be deleted with DELETE EXPIRED BACKUP.


    RMAN doesn't find hidden software. It just so happens that whoever created those backups named them as "X.dbvisit....." they could have been named anything.


    Hemant K Chitale
  • 21. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thanks hem,

    So I need to run this again? or I need to add some command to have a "catch all" one time run process? I want to eliminate reruns of processes or duplications cause its wasting resources ;)
    run {
    crosscheck archivelog all;
    delete noprompt expired archivelog all;
    backup database;
    SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    BACKUP ARCHIVELOG ALL;
    delete obsolete;
    }
    Can you make tha above perfect? :)

    Thanks
  • 22. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    There's no "perfect" answer.

    Many sites do not have "missing" archivelogs. They do not need to run CROSSCHECK ARCHIVELOG ALL because they are in control of the archivelogs. Yours seems to be a site where you are not in control of what is happening.

    And remember : I suggested adding CROSSCHECK ARCHIVELOG ALL and DELETE EXPIRED ARCHIVELOG ALL only if missing archivelogs was a frequent occurrence. It isn't a good thing to go and delete archivelogs without knowing what is happening. Such behaviour should be an exception not a rule.


    Hemant K Chitale
  • 23. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thanks hem,

    I run again the above commands, but still the warning persist :(
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814110141_8qypfxjy_.bkp recid=23 stamp=814110141
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814113545_8qysr9cj_.bkp recid=25 stamp=814113545
    Deleted 6 objects
    
    RMAN-06207: WARNING: 4 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: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
    
    
    Recovery Manager complete.
    What still needs to be added in the commands plaeseee....

    Thanks,
  • 24. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Maybe these are Controlfile Copies created with BACKUP AS COPY CURRENT CONTROLFILE OR the SQL command "ALTER DATABASE BACKUP CONTROLFILE TO ..." instead of being Controlfile Backups created with BACKUP CURRENT CONTROLFILE.

    DID you check if the CROSSCHECK BACKUP listed them ? Or did you just ignore whatever flashed by on screen ?



    Try a CROSSCHECK COPY OF CONTROLFILE



    Hemant K Chitale
  • 25. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thanks hem...

    This is the entire screen logs:
    Recovery Manager: Release 10.2.0.4.0 - Production on Tue Apr 30 14:56:43 2013
    
    Copyright (c) 1982, 2007, Oracle.  All rights reserved.
    
    connected to target database: TEST1 (DBID=1185464014)
    
    RMAN> run {
    2> crosscheck archivelog all;
    3> delete noprompt expired archivelog all;
    4> backup database;
    5> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
    6> BACKUP ARCHIVELOG ALL;
    7> delete obsolete;
    8> }
    9>
    using target database control file instead of recovery catalog
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=143 devtype=DISK
    validation succeeded for archived log
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_772_8qysrd5k_.arc recid=711 stamp=814113548
    validation succeeded for archived log
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_773_8qysrdks_.arc recid=712 stamp=814113548
    Crosschecked 2 objects
    
    
    released channel: ORA_DISK_1
    allocated channel: ORA_DISK_1
    channel ORA_DISK_1: sid=143 devtype=DISK
    specification does not match any archive log in the recovery catalog
    
    Starting backup at 30-APR-13
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting full datafile backupset
    channel ORA_DISK_1: specifying datafile(s) in backupset
    input datafile fno=00006 name=/u01/app/oracle/oradata/test1/smttdata.dbf
    input datafile fno=00003 name=/u01/app/oracle/oradata/test1/sysaux01.dbf
    input datafile fno=00001 name=/u01/app/oracle/oradata/test1/system01.dbf
    input datafile fno=00002 name=/u01/app/oracle/oradata/test1/undotbs01.dbf
    input datafile fno=00005 name=/u01/app/oracle/oradata/test1/example01.dbf
    input datafile fno=00004 name=/u01/app/oracle/oradata/test1/users01.dbf
    channel ORA_DISK_1: starting piece 1 at 30-APR-13
    channel ORA_DISK_1: finished piece 1 at 30-APR-13
    piece handle=/u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T145645_8qytsf6r_.bkp tag=TAG20130430T145645 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:02:45
    Finished backup at 30-APR-13
    
    Starting Control File and SPFILE Autobackup at 30-APR-13
    piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814114770_8qytylkf_.bkp comment=NONE
    Finished Control File and SPFILE Autobackup at 30-APR-13
    
    
    sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
    
    Starting backup at 30-APR-13
    current log archived
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting archive log backupset
    channel ORA_DISK_1: specifying archive log(s) in backup set
    input archive log thread=1 sequence=772 recid=711 stamp=814113548
    input archive log thread=1 sequence=773 recid=712 stamp=814113548
    input archive log thread=1 sequence=774 recid=713 stamp=814114773
    input archive log thread=1 sequence=775 recid=714 stamp=814114773
    channel ORA_DISK_1: starting piece 1 at 30-APR-13
    channel ORA_DISK_1: finished piece 1 at 30-APR-13
    piece handle=/u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T145933_8qytypt2_.bkp tag=TAG20130430T145933 comment=NONE
    channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
    Finished backup at 30-APR-13
    
    Starting Control File and SPFILE Autobackup at 30-APR-13
    piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814114775_8qytyr48_.bkp comment=NONE
    Finished Control File and SPFILE Autobackup at 30-APR-13
    
    RMAN retention policy will be applied to the command
    RMAN retention policy is set to redundancy 1
    using channel ORA_DISK_1
    Deleting the following obsolete backups and copies:
    Type                 Key    Completion Time    Filename/Handle
    -------------------- ------ ------------------ --------------------
    Backup Set           5      27-FEB-13
      Backup Piece       5      27-FEB-13          /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
    Backup Set           4      27-FEB-13
      Backup Piece       4      27-FEB-13          /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
    Backup Set           7      01-MAR-13
      Backup Piece       7      01-MAR-13          /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
    Backup Set           6      01-MAR-13
      Backup Piece       6      01-MAR-13          /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
    Backup Set           24     30-APR-13
      Backup Piece       24     30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T143629_8qysmgfq_.bkp
    Archive Log          712    30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_773_8qysrdks_.arc
    Backup Set           26     30-APR-13
      Backup Piece       26     30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T143908_8qysrfvq_.bkp
    Archive Log          711    30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_772_8qysrd5k_.arc
    Backup Set           27     30-APR-13
      Backup Piece       27     30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814113550_8qysrh51_.bkp
    Backup Set           29     30-APR-13
      Backup Piece       29     30-APR-13          /u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814114770_8qytylkf_.bkp
    deleted archive log
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_773_8qysrdks_.arc recid=712 stamp=814113548
    deleted archive log
    archive log filename=/u01/app/oracle/flash_recovery_area/TEST1/archivelog/2013_04_30/o1_mf_1_772_8qysrd5k_.arc recid=711 stamp=814113548
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814113550_8qysrh51_.bkp recid=27 stamp=814113551
    deleted backup piece
    backup piece handle=/u01/app/oracle/flash_recovery_area/TEST1/autobackup/2013_04_30/o1_mf_s_814114770_8qytylkf_.bkp recid=29 stamp=814114770
    Deleted 4 objects
    
    RMAN-06207: WARNING: 6 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: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc124.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc123.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc126.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /usr/tmp/GS/test1/X.dbvisit.abc125.test1.standbycontrolfile
    RMAN-06214: Backup Piece    /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_nnndf_TAG20130430T143629_8qysmgfq_.bkp
    RMAN-06214: Backup Piece    /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30/o1_mf_annnn_TAG20130430T143908_8qysrfvq_.bkp
    
    
    Recovery Manager complete.
    What does it say? :) The warning object count is increasing :(

    Thanks a lot....

    Edited by: yxes2013 on 30.4.2013 0:04
  • 26. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    I also put CROSSCHECK COPY OF CONTROLFILE

    But still the same warning :(
  • 27. Re: RMAN error
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    The two "new" files in /u01/app/oracle/flash_recovery_area/TEST1/backupset/2013_04_30 are actually backups created at 14:36:29 and 14:39:08 earlier today. I presume that you have manually deleted them and not bothered to do a CROSSCHECK BACKUP and DELELETE EXPIERD BACKUP. The DELETE OBSOLETE raises a warning because it knows that these are obsolete but cannot delete them because they don't exist anymore.

    Why are you repeatedly running the whole backup ?


    Hemant K Chitale
  • 28. Re: RMAN error
    yxes2013 Newbie
    Currently Being Moderated
    Thanks,
    Why are you repeatedly running the whole backup ?
    I am getting rid of the warnings :( hoping to clear all.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points