Our database & app hangs for the first time, 3 consecutive days (Aug 11,12,13) during run of batch jobs at 12AM.
The batch operator said the batch job is deleting a table with only less than 1000 rows but was not able to lock the table as there lots of updates queues from lots of client app.
I check the alert log for the said time period and this is the output. I saw similar occurences at 1AM
Tue Aug 13 01:20:45 2013
Clearing standby activation ID 2855092487 (0xaa2d4107)
The primary database controlfile was created using the
'MAXLOGFILES 16' clause.
There is space for up to 10 standby redo logfiles
Use the following SQL commands on the standby database to create
standby redo logfiles that match the primary database:
ALTER DATABASE ADD STANDBY LOGFILE 'srl1.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl2.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl3.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl4.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl5.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl6.f' SIZE 262144000;
ALTER DATABASE ADD STANDBY LOGFILE 'srl7.f' SIZE 262144000;
Tue Aug 13 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Aug 13 04:36:07 2013
WARNING: Heavy swapping observed on system in last 5 mins.
pct of memory swapped in [9.53%] pct of memory swapped out [23.33%].
Please make sure there is no memory pressure and the SGA and PGA
are configured correctly. Look at DBRM trace file for more details.
Tue Aug 13 05:07:14 2013
Thread 1 cannot allocate new log, sequence 49033
Private strand flush not complete
AlertSunday Aug 11
AlertMonday Aug 12
AlertTuesday Aug 13
Do you have any idea what causes tha hang? Its weird because these did not happened before.
Thanks a lot,
Does these ASH, & AWR reports shows anything?
Nobody is, the lines preceding the statements read: "Use the following SQL commands on the standby database to create standby redo logfiles that match the primary database:"
Did you check the DBRM trace?
It is in your trace directory, something like:
/opt/oracle/diag/rdbms/your_database_name/trace , the filename will be something like [your_database_name]_dbrm_[some_number].trc
You claimed a numerous of time that you're working on highly sensitive/confidential data and environment. Across all your posts and now those reports, you're giving material enough to know which software/company you are working for, and eventually let a hacker to go further.
If it's true, I hope I'll never need these services, and the manager of your department you are working in should know what you share in a public forum to take proper decision about your situation in his team.
You should actually read the ToU to think about privacy.
>I might be jailed for it
In first instance you should be layed off then pursuit in a court and maybe go to jail, yes.
>Sorry I really didn't mean to pose security threat.
Apparently you did not learnt from previous Justin's warning 3 days ago https://forums.oracle.com/message/11142424#11142424
Now you removed the files, I give it up on that thread and let you continue with your original question if it has any sense to you.