Database Administration (MOSC)

MOSC Banner

Running awrload to upload the baseline dump fails

edited Sep 19, 2013 4:25AM in Database Administration (MOSC) 7 commentsAnswered

Hi,

I was trying to upload the dump I had taken for one of the baselines using awrextr.sql.

while running awrload.sql, it failed with below error.

The source and target database remains the same as I had taken the dump to import later.

Error:

begin
*
ERROR at line 1:
ORA-20105: unable to move AWR data to SYS
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 2950
ORA-20107: not allowed to move AWR data for local dbid
ORA-06512: at line 3


... Dropping AWR_STAGE user

End of AWR Load

Can you please suggest the solution to rectify this.

Thanks,
Rashmi

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center