Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2006
    Posts
    30

    Unanswered: RMAN problem continued

    I thought I had it, but I didn't. Here is the log from the failing job:
    Starting backup at 09-MAY-07
    channel t1: starting full datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00017 name=/u02/oracle/OraHome1/oradata/IBAS/temp01.dbf
    input datafile fno=00015 name=/u01/oracle/OraHome1/oradata/IBAS/ET_INDEX01.dbf
    input datafile fno=00018 name=/u01/oracle/OraHome1/oradata/IBAS/TS_INDEX1.dbf
    input datafile fno=00023 name=/u01/oracle/OraHome1/oradata/IBAS/CB_INDEX1.dbf
    input datafile fno=00034 name=/u01/oracle/OraHome1/oradata/IBAS/IBAS_INDEX1.dbf
    input datafile fno=00006 name=/u01/oracle/OraHome1/oradata/IBAS/indx01.dbf
    input datafile fno=00014 name=/u01/oracle/OraHome1/oradata/IBAS/ET_INDEX.dbf
    input datafile fno=00002 name=/u02/oracle/OraHome1/oradata/IBAS/undotbs01.dbf
    input datafile fno=00027 name=/u02/oracle/OraHome1/oradata/IBAS/IBASTS3.dbf
    input datafile fno=00032 name=/u02/oracle/OraHome1/oradata/IBAS/.dbf
    input datafile fno=00033 name=/u02/oracle/OraHome1/oradata/IBAS/IBASTS5.dbf
    input datafile fno=00028 name=/u02/oracle/OraHome1/oradata/IBAS/RPTS2.dbf
    input datafile fno=00021 name=/u02/oracle/OraHome1/oradata/IBAS/ETTS02.dbf
    input datafile fno=00026 name=/u02/oracle/OraHome1/oradata/IBAS/IBASTS2.dbf
    input datafile fno=00029 name=/u02/oracle/OraHome1/oradata/IBAS/CBTS4.dbf
    input datafile fno=00030 name=/u02/oracle/OraHome1/oradata/IBAS/ETTS03.dbf
    input datafile fno=00031 name=/u02/oracle/OraHome1/oradata/IBAS/TETS02.dbf
    input datafile fno=00009 name=/u02/oracle/OraHome1/oradata/IBAS/ETTS.dbf
    input datafile fno=00001 name=/u02/oracle/OraHome1/oradata/IBAS/system01.dbf
    input datafile fno=00012 name=/u02/oracle/OraHome1/oradata/IBAS/TETS.dbf
    input datafile fno=00010 name=/u02/oracle/OraHome1/oradata/IBAS/IBASTS.dbf
    input datafile fno=00020 name=/u02/oracle/OraHome1/oradata/IBAS/RPTS1.dbf
    input datafile fno=00022 name=/u02/oracle/OraHome1/oradata/IBAS/CBTS3.dbf
    input datafile fno=00024 name=/u02/oracle/OraHome1/oradata/IBAS/RPTTS1.dbf
    input datafile fno=00025 name=/u02/oracle/OraHome1/oradata/IBAS/temp02.dbf
    input datafile fno=00005 name=/u02/oracle/OraHome1/oradata/IBAS/example01.dbf
    input datafile fno=00016 name=/u02/oracle/OraHome1/oradata/IBAS/CBTS2.dbf
    input datafile fno=00035 name=/u02/oracle/OraHome1/oradata/IBAS/JDPTS1.dbf
    input datafile fno=00011 name=/u02/oracle/OraHome1/oradata/IBAS/CBTS.dbf
    input datafile fno=00019 name=/u02/oracle/OraHome1/oradata/IBAS/PARTTS1.dbf
    input datafile fno=00013 name=/u02/oracle/OraHome1/oradata/IBAS/CBTS1.dbf
    input datafile fno=00008 name=/u02/oracle/OraHome1/oradata/IBAS/users01.dbf
    input datafile fno=00003 name=/u02/oracle/OraHome1/oradata/IBAS/cwmlite01.dbf
    input datafile fno=00004 name=/u02/oracle/OraHome1/oradata/IBAS/drsys01.dbf
    input datafile fno=00007 name=/u02/oracle/OraHome1/oradata/IBAS/tools01.dbf
    channel t1: starting piece 1 at 09-MAY-07
    channel t1: finished piece 1 at 09-MAY-07
    piece handle=/u03/rman/ibas_rman comment=NONE
    channel t1: backup set complete, elapsed time: 00:20:35
    channel t1: starting full datafile backupset
    channel t1: specifying datafile(s) in backupset
    input datafile fno=00036 name=/u01/oracle/OraHome1/oradata/IBAS/RP_PART_INDEX_TS1.dbf
    channel t1: starting piece 1 at 09-MAY-07
    RMAN-00571: ================================================== =========
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ================================================== =========
    RMAN-00579: the following error occurred at 05/09/2007 02:36:16
    RMAN-03007: retryable error occurred during execution of command: backup
    RMAN-12004: unhandled exception during command execution on channel t1
    RMAN-10035: exception raised in RPC: ORA-19504: failed to create file "/u03/rman/ibas_rman"
    ORA-27038: skgfrcre: file exists
    RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

    Here is the code:
    run {

    configure controlfile autobackup on;
    configure retention policy to recovery window of 1 days;
    #delete noprompt obsolete;
    crosscheck archivelog all;

    host 'rm /u03/rman/ibas_rman';
    host 'rm /u03/rman/ibas_control';

    delete noprompt expired backup;
    delete noprompt obsolete;
    #delete noprompt expired archivelog all;

    allocate channel t1 type disk;
    #backup the whole db
    backup
    tag whole_database_open
    format '/u03/rman/ibas_rman'
    database;
    release channel t1;


    # backup a copy of the controlfile that contains records for the
    # other backups just made
    allocate channel t3 type disk;
    backup
    current controlfile
    tag = cf1
    format '/u03/rman/ibas_control';
    release channel t3;

    host 'rm /u03/rman/IBAS.tar';
    host 'tar -cvEf /u03/rman/IBAS.tar /u03/rman/ibas_rman /u03/rman/ibas_control /u03/rman/orapwIBAS /u03/rman/initIBAS.ora';

    So basically my question is-Why is RMAN trying to back up the new datafile seperately?

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking


    You need to use different format kinda like this:
    Code:
    ...etc...
    format '/u03/rman/ibas_rman/%d_s%s_p%p_t%t"'
    ...etc...

    Last edited by LKBrwn_DBA; 05-09-07 at 12:37.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2006
    Posts
    30

    Rman

    Thank you for the suggestion. The backup worked before we added a new tablespace to the DB. I read about resyncing the recovery catalog's database. I tried that. We'll see tonight.

  4. #4
    Join Date
    Sep 2006
    Posts
    30

    Rman

    Well, he cataklog resync did not work. Any other suggestions? As per the log I posted earlier, RMAN is trying to run a 2nd backup for the new tablespace.

  5. #5
    Join Date
    Dec 2002
    Posts
    1,245
    what's this?

    Code:
    input datafile fno=00032 name=/u02/oracle/OraHome1/oradata/IBAS/.dbf
                                                                  ^^^^^^^
    Would you spool "show all;" from RMAN and post it here? Also, I think you posted it before, but which version of Oracle are you using?

    Regards,

    hmscott
    Have you hugged your backup today?

  6. #6
    Join Date
    Sep 2006
    Posts
    30

    Rman

    That file is the name of one of the datafiles. That name was an accident, but we haven't corrected it yet. We are using Oracle 9i.

    Here is the output from SHOW ALL:
    Recovery Manager: Release 9.0.1.1.0 - 64bit Production

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    RMAN> connect target SYS/sys@(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=/u01/oracle/OraHome1/bin/oracle)(ARGV0=oracleIBAS)(ARGS='(DESCRIPTION=(LOCA L=YES)(ADDRESS=(PROTOCOL=beq)))')(ENVS='ORACLE_HOM E=/u01/oracle/OraHome1,ORACLE_SID=IBAS,TNS_ADMIN=/u01/oracle/OraHome1/network/admin'))
    2> connect catalog RMAN/rman@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL =TCP)(HOST=10.33.2.44)(PORT=1521)))(CONNECT_DATA=( SID=INVOEM)(SERVER=DEDICATED)))
    3> @/tmp/091446.24
    4> show all;
    5>
    6> **end-of-file**
    7>
    connected to target database: IBAS (DBID=1079630037)

    connected to recovery catalog database

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/oracle/OraHome1/dbs/snapcf_IBAS.f'; # default

    Recovery Manager complete.

  7. #7
    Join Date
    Dec 2002
    Posts
    1,245
    some comments:
    Code:
    run {
    
    configure controlfile autobackup on; # redundant; you don't need this here
    configure retention policy to recovery window of 1 days; # redundant; you don't need this here
    #delete noprompt obsolete;
    crosscheck archivelog all;
    
    # why are you making calls to the OS to delete these?
    host 'rm /u03/rman/ibas_rman';
    host 'rm /u03/rman/ibas_control';
    
    delete noprompt expired backup; # be careful with this command; see comment below 
    delete noprompt obsolete; # because you're just deleting them here (see note above) 
    #delete noprompt expired archivelog all;
    
    allocate channel t1 type disk;
    #backup the whole db
    backup
    tag whole_database_open
    format '/u03/rman/ibas_rman' # I have to agree with what someone said earlier; use a more descriptive format (with %t and %s)
    database;
    release channel t1;
    
    
    # backup a copy of the controlfile that contains records for the 
    # other backups just made
    # why are you doing this? control file autobackup is on!
    allocate channel t3 type disk;
    backup 
    current controlfile 
    tag = cf1 
    format '/u03/rman/ibas_control';
    release channel t3;
    
    host 'rm /u03/rman/IBAS.tar';
    host 'tar -cvEf /u03/rman/IBAS.tar /u03/rman/ibas_rman /u03/rman/ibas_control /u03/rman/orapwIBAS /u03/rman/initIBAS.ora';
    # Okay, so you are zipping the files afterwards (and I assume you need constant file names to support the TAR process; I think you can probably find a way to pass the filename as a parameter
    
    => I assumed that there was an end bracket here:
    }
    Some other thoughts:
    I remember that there was a limit somewhere on the number of files (pieces) that could be added to a backup set (I think I got my terms right!). I wonder if you've exceeded that threshold and Oracle is starting a new backupset.

    Be careful about blindly including a DELETE BACKUP EXPIRED in you command. DELETE ... OBSOLETE is okay, but EXPIRED means you deleted it (the backupset) using an OS command and now RMAN can't find it using CROSSCHECK. I realize that you are using OS commands to delete the uncompressed backups, but it appears that you are keeping at least one uncompressed copy on disk before the backups even start.

    Are you having disk space issues?

    Re-using the same filename over and over means that you can't easily verify (visually or programmatically) which version of the backup you are dealing with. At 2am when you've been woken from a dead sleep, are you sufficiently aware of your environment to grab the right file the first time?

    You can configure an RMAN parameter such as:
    Code:
    configure channel device type disk disk '/u03/rman/%d_%s_%t.bak'
    Then conceptually, you could simplify your RMAN backup to:

    Code:
    # Back up entire database
    BACKUP DATABASE;
    
    # Back up all archived redo logs 
    BACKUP ARCHIVELOG ALL;
    
    # Delete obsolete backups
    DELETE NOPROMPT OBSOLETE;
    Probably more help than what you wanted. I'm still looking at the MAXFILES parameter. In 10g, I see there are options for max size for a backup piece and max size for a backup set. I wonder if those are in 9i and if they are related. Sorry, I don't have the answers off the top of my head, but I will look more.

    Regards,

    hmscott
    Have you hugged your backup today?

  8. #8
    Join Date
    Sep 2006
    Posts
    30

    Rman

    Thank you so much for the suggestions. Once the backup is done, we actually offload it to another server and archive it (with a date stamp), so the filename will change then.

    If you find out any more info about the MAXFILES, please let me know.

  9. #9
    Join Date
    Sep 2006
    Posts
    30

    Success

    I took the suggestion of adding a parameter to the end of the file (I added %U). All was OK.

    Thanks to everyone who helped!

Posting Permissions

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