Tags: autoextend, backup, backups, database, datafile, due, error, extend, fact, mysql, oracle, pbs, rman, sql
autoextend off / on?
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!
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.
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