Database Replay error
845641May 12 2012 — edited May 12 2012Please help me experts
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
[oracle@localhost ~]$ wrc system/manager mode=calibrate replaydir=/u01/app/cap
Workload Replay Client: Release 11.2.0.1.0 - Production on Tue Jul 17 17:50:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Report for Workload in: /u01/app/cap
-----------------------
Recommendation:
Consider using at least 1 clients divided among 1 CPU(s)
You will need at least 33 MB of memory per client process.
If your machine(s) cannot match that number, consider using more clients.
Workload Characteristics:
- max concurrency: 9 sessions
- total number of sessions: 15
Assumptions:
- 1 client process per 50 concurrent sessions
- 4 client process per CPU
- 256 KB of memory cache per concurrent session
- think time scale = 100
- connect time scale = 100
- synchronization = TRUE
[oracle@localhost ~]$ wrc system/manager mode=replay replaydir=/u01/app/cap
Workload Replay Client: Release 11.2.0.1.0 - Production on Tue Jul 17 17:50:31 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Wait for the replay to start (17:50:31)
Replay started (17:50:41)
Errors in file :
ORA-15558: replay thread encountered unexpected error
_________________________________
Alert log does not show enough detailed information..
[oracle@localhost ~]$ tailf /u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
space available in the underlying filesystem or ASM diskgroup.
Tue Jul 17 17:47:26 2012
alter database datafile 4 resize 400m
Completed: alter database datafile 4 resize 400m
Tue Jul 17 17:50:41 2012
DBMS_WORKLOAD_REPLAY.START_REPLAY(): Starting database replay at 07/17/2012 17:50:41
Tue Jul 17 17:51:23 2012
Starting background process SMCO
Tue Jul 17 17:51:23 2012
SMCO started with pid=20, OS id=25453