Hello all,
I am facing problems about QAD linux memory issue
My customer has 2 servers: 1 for App server(linux), 1 for DB server(linux). They use 2 DBs (live and test Database) on the same local server (DB server).
Some times the test DB does not run, it automatically shutdown (they can not login it). The live database is still run at that time.
I use crontab to backup live DB everyday (afterwork) and restore the test DB from live DB at 3:00AM everyday.
Pls give me any idea expert from you all.
Thanks,
Here is the error msg log file when I try to startup the test database by manual:
[root@qadprod-srv5 mfgsvr]# ./start.qadprod-test
10:17:27 BROKER 0: Multi-user session begin. (333)
10:17:27 BROKER 0: ** The database was last used Wed Jun 12 03:36:19 2013. (886)
10:17:27 BROKER 0: ** The before-image file expected Thu Jun 13 03:35:29 2013. (887)
10:17:27 BROKER 0: ** Those dates don't match, so you have the wrong copy of one of them. (888)
10:17:27 BROKER : Removed shared memory with segment_id: 1146892
10:17:27 BROKER : Multi-user session end. (334)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
10:17:27 BROKER ** The database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/hlpqadprod-test is in use in multi-user mode. (276)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
10:17:27 BROKER ** The database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/admqadprod-test is in use in multi-user mode. (276)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
[root@qadprod-srv5 mfgsvr]# ./stop.qadprod-test
SYSTEM ERROR: Can't attach shared memory with segment_id: 1146892 for /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/mfgqadprod-test
There is no server for database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/mfgqadprod-test. (1423)
Shutdown is executing. (1613)
Shutdown complete. (1614)
Shutdown is executing. (1613)
Shutdown complete. (1614)
[root@qadprod-srv5 mfgsvr]# ./start.qadprod-test
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: ** The database was last used Wed Jun 12 03:36:19 2013. (886)
10:18:06 BROKER 0: ** The before-image file expected Thu Jun 13 03:35:29 2013. (887)
10:18:06 BROKER 0: ** Those dates don't match, so you have the wrong copy of one of them. (888)
10:18:06 BROKER : Removed shared memory with segment_id: 1179658
10:18:06 BROKER : Multi-user session end. (334)
10:18:06 BROKER ** This process terminated with exit code 2. (8619)
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
10:18:06 BROKER 0: Physical Redo Phase Completed at blk 0 off 6215 upd 0. (7161)
10:18:06 BROKER 0: At end of Physical redo, transaction table size is 128. (13547)
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
10:18:06 BROKER 0: Physical Redo Phase Completed at blk 88 off 782 upd 0. (7161)
10:18:06 BROKER 0: At end of Physical redo, transaction table size is 128. (13547)
[root@qadprod-srv5 mfgsvr]#
I am facing problems about QAD linux memory issue
My customer has 2 servers: 1 for App server(linux), 1 for DB server(linux). They use 2 DBs (live and test Database) on the same local server (DB server).
Some times the test DB does not run, it automatically shutdown (they can not login it). The live database is still run at that time.
I use crontab to backup live DB everyday (afterwork) and restore the test DB from live DB at 3:00AM everyday.
Pls give me any idea expert from you all.
Thanks,
Here is the error msg log file when I try to startup the test database by manual:
[root@qadprod-srv5 mfgsvr]# ./start.qadprod-test
10:17:27 BROKER 0: Multi-user session begin. (333)
10:17:27 BROKER 0: ** The database was last used Wed Jun 12 03:36:19 2013. (886)
10:17:27 BROKER 0: ** The before-image file expected Thu Jun 13 03:35:29 2013. (887)
10:17:27 BROKER 0: ** Those dates don't match, so you have the wrong copy of one of them. (888)
10:17:27 BROKER : Removed shared memory with segment_id: 1146892
10:17:27 BROKER : Multi-user session end. (334)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
10:17:27 BROKER ** The database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/hlpqadprod-test is in use in multi-user mode. (276)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
10:17:27 BROKER ** The database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/admqadprod-test is in use in multi-user mode. (276)
10:17:27 BROKER ** This process terminated with exit code 2. (8619)
[root@qadprod-srv5 mfgsvr]# ./stop.qadprod-test
SYSTEM ERROR: Can't attach shared memory with segment_id: 1146892 for /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/mfgqadprod-test
There is no server for database /u01/mfgqadprod/mfgsvr/dataqadprod/qadprod-test/mfgqadprod-test. (1423)
Shutdown is executing. (1613)
Shutdown complete. (1614)
Shutdown is executing. (1613)
Shutdown complete. (1614)
[root@qadprod-srv5 mfgsvr]# ./start.qadprod-test
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: ** The database was last used Wed Jun 12 03:36:19 2013. (886)
10:18:06 BROKER 0: ** The before-image file expected Thu Jun 13 03:35:29 2013. (887)
10:18:06 BROKER 0: ** Those dates don't match, so you have the wrong copy of one of them. (888)
10:18:06 BROKER : Removed shared memory with segment_id: 1179658
10:18:06 BROKER : Multi-user session end. (334)
10:18:06 BROKER ** This process terminated with exit code 2. (8619)
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
10:18:06 BROKER 0: Physical Redo Phase Completed at blk 0 off 6215 upd 0. (7161)
10:18:06 BROKER 0: At end of Physical redo, transaction table size is 128. (13547)
10:18:06 BROKER 0: Multi-user session begin. (333)
10:18:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
10:18:06 BROKER 0: Physical Redo Phase Completed at blk 88 off 782 upd 0. (7161)
10:18:06 BROKER 0: At end of Physical redo, transaction table size is 128. (13547)
[root@qadprod-srv5 mfgsvr]#