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!

Alert log content

ShaikMay 22 2012 — edited May 22 2012

Hi

we have a prod database of version 10.2.0.4

Alert log content showing like :
alter database recover datafile list clear
Tue May 22 08:33:27 2012
Completed: alter database recover datafile list clear
Tue May 22 08:33:27 2012
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
Tue May 22 08:33:27 2012
alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40
Completed: alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29 , 30 , 31 , 32 , 33 , 34 , 35 , 36 , 37 , 38 , 39 , 40
Tue May 22 08:33:27 2012
alter database recover datafile list
41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 288 , 295 , 314 , 351 , 352 , 353 , 354
Completed: alter database recover datafile list
41 , 42 , 43 , 44 , 45 , 46 , 47 , 48 , 49 , 50 , 51 , 52 , 53 , 288 , 295 , 314 , 351 , 352 , 353 , 354
Tue May 22 08:33:27 2012
alter database recover datafile list
379 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 399 , 400 , 401 , 402 , 403 , 404 , 405 , 406 , 407
Completed: alter database recover datafile list
379 , 392 , 393 , 394 , 395 , 396 , 397 , 398 , 399 , 400 , 401 , 402 , 403 , 404 , 405 , 406 , 407
Tue May 22 08:33:27 2012
alter database recover if needed
start
Media Recovery Start
Tue May 22 08:33:27 2012
Media Recovery failed with error 1124
ORA-283 signalled during: alter database recover if needed
start
...
Tue May 22 08:34:42 2012
alter database open resetlogs
Tue May 22 08:34:42 2012
ORA-1531 signalled during: alter database open resetlogs...
Tue May 22 08:45:16 2012

Why recovery operation happening here i didnt understood.

Please clarify me? we didnt did any recovery operations in prod...then why this entries in alert log?

Regards
Shaik

Edited by: Shaik on May 22, 2012 5:23 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2012

Added on May 22 2012

#general-database-discussions

1 comment

1,013 views