Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Warning during backup

543075May 13 2008 — edited Jun 9 2011
We are getting following error after BCV sync.Please let me know anybody what is cause of it and solution?

alter database begin backup
Wed May 14 00:05:45 2008
ORA-1122 signalled during: alter database begin backup...
Wed May 14 00:08:37 2008
alter database end backup
Wed May 14 00:08:37 2008
WARNING: datafile #1 was not in online backup mode
WARNING: datafile #2 was not in online backup mode
WARNING: datafile #3 was not in online backup mode
WARNING: datafile #4 was not in online backup mode
WARNING: datafile #5 was not in online backup mode
WARNING: datafile #6 was not in online backup mode
WARNING: datafile #7 was not in online backup mode
WARNING: datafile #8 was not in online backup mode
WARNING: datafile #9 was not in online backup mode
WARNING: datafile #10 was not in online backup mode
WARNING: datafile #11 was not in online backup mode
WARNING: datafile #12 was not in online backup mode
ORA-1122 signalled during: alter database end backup...

Comments

oradba May 13 2008
Error: ORA 1122
Text: database file %s failed verification check
-------------------------------------------------------------------------------
Cause: The information in this file is inconsistent with information
from the control file. See accompanying message for reason.
Action: Make certain that the db files and control files are the correct
files for this database.
-----------------------------------------------
It seems you have a serious problem, check alertlog for further messages. Search metalink for possible solutions or contact Oracle support directly.

Werner
153119 May 13 2008
Please look up ora-1122 in the online documentation or on a command prompt issue
oerr ora 1122
and work from the message presented to you.
Apparently a begin backup failed, and your code crashed

--
Sybrand Bakker
Senior Oracle DBA
Madrid May 13 2008 — edited on May 13 2008
We are getting following error after BCV sync.Please
You may refer to this link, it is not the same case you have posted her, but it may help you to find a solution

--> http://www.dbasupport.com/forums/archive/index.php/t-54393.html

~ Madrid
http://hrivera99.blogstpot.com
tri Jun 9 2011
Hi all,

I've got the same problem. The errors found in alert.log as follow:

Wed Jun 8 21:36:16 2011
alter database end backup
WARNING: datafile #338 was not in online backup mode
Wed Jun 8 21:36:35 2011
ORA-1260 signalled during: alter database end backup...
Wed Jun 8 21:36:36 2011

I checked and found file 338 did not exist.
SQL> select file#, name from v$datafile where file#=338;

no rows selected

Please help!
Quoc Tri.
Aman.... Jun 9 2011
hqtri wrote:
Hi all,

I've got the same problem. The errors found in alert.log as follow:

Wed Jun 8 21:36:16 2011
alter database end backup
WARNING: datafile #338 was not in online backup mode
Wed Jun 8 21:36:35 2011
ORA-1260 signalled during: alter database end backup...
Wed Jun 8 21:36:36 2011

I checked and found file 338 did not exist.
SQL> select file#, name from v$datafile where file#=338;

no rows selected
I dont think that its the same problem for you but you have a bigger problem to deal with. The file# 338 is not there with you in the first place so do check how did the file got deleted and recover it using a valid backup .

Aman....
CKPT Jun 9 2011
Wed May 14 00:05:45 2008
ORA-1122 signalled during: alter database begin backup...
Wed May 14 00:08:37 2008
alter database end backup
Is it ARCHIVE LOG mode?

post
SQL> archive log list
If it is in archive, after put dtabase in backup mode post
SQL> select * from v$backup;
Post if you have seen any more erorrs after putting in begin backup mode.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 7 2011
Added on May 13 2008
6 comments
5,304 views