[스크랩] datafile #1 was not in online backup mode

https://community.oracle.com/thread/657224?tstart=0

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...

• 2305 보기
• 태그:

평균 사용자 등급: 평가 없음 (0 등급)

평균 사용자 등급

평가 없음

(0 등급)

• 1. Re: Warning during  backup

  

  19426 2008. 5. 13 오후 2:00 (543075에 대한 응답)

  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

  • 좋아요 좋아요 0개 표시(0)
  • 작업 

• 2. Re: Warning during  backup

  

  153119 2008. 5. 13 오후 2:02 (543075에 대한 응답)

  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

  • 좋아요 좋아요 0개 표시(0)
  • 작업 

• 3. Re: Warning during  backup

  

  Madrid 2008. 5. 13 오후 2:54 (543075에 대한 응답)

  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

  • 좋아요 좋아요 0개 표시(0)
  • 작업 

• 4. Re: Warning during  backup

  

  Tri 2011. 6. 8 오후 11:37 (Madrid에 대한 응답)

  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.

  • 좋아요 좋아요 0개 표시(0)
  • 작업 

• 5. Re: Warning during  backup

  

  Aman.... 2011. 6. 8 오후 11:40 (Tri에 대한 응답)

  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....

  • 좋아요 좋아요 0개 표시(0)
  • 작업 

• 6. Re: Warning during  backup

  

  CKPT 2011. 6. 8 오후 11:58 (543075에 대한 응답)

  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.

  •