Tags: autoextend, backup, backups, database, datafile, due, error, extend, fact, mysql, oracle, pbs, rman, sql

autoextend off / on?

On Database » Oracle

982 words with 2 Comments; publish: Wed, 13 Feb 2008 10:44:00 GMT; (25046.88, « »)

I have been having pbs with rman backups and this is due to the fact that during rman backup, a datafile is being extend and it gives the error below.

RMAN-10035: exception raised in RPC: ORA-19575: expected 820995 blocks in file /u05/oradata/MTNPRD/applsysx01.dbf, found 820990

RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

Now, I will like to change the datafile from autoextend on to off but before doing that, I will like to have some advice as I wanna know the up and downside of it!

Thanks

DID

All Comments

Leave a comment...

  • 2 Comments
    • I don't think this is a autoextend on or off issue . It is rather backupset corruption issue, if you have anotherbackupset , then you can delete it from rec catalog.

      hare krishna

      Alok

      #1; Sat, 23 Feb 2008 13:47:00 GMT
    • You can turn off autoextend, but if the tablespace needs to autoextend an error will be raised. Another option is to adjust your backup time to a time where the tablespace is less likely to autoextend if possible.
      #2; Sat, 23 Feb 2008 13:48:00 GMT