Skip to Content
0
Former Member
May 18, 2010 at 01:17 PM

No username of Source system is avbl after livecache system copy

555 Views

Hi Experts

I have done a livecache system copy from the source system to target system. Here the steps are

Assume my Source SYstem Livecache is RP1 and Target System livecache is RS1.

1. Taken Source system livecache DATA and LOG Area backup RP1.

2. Defined the same source system backup medium name in Target System (RS1 and moving the Source system Liveacache backuped files to Target system and defined the medium name as per that)

3. put the livecache db_admin mode

4. db_activate RECOVER <medium_name>.

5. recover_start <log_medium_name> LOG <nnn>

6. db_online.

Here we faced that

ERR

-24622,ERR_AUTOLOADSYSTAB: Automatic loading of the System Tables failed

-24907,ERR_DBAWRONG: Wrong database system administrator

-24988,ERR_SQL: SQL error

-4008,Unknown user name/password combination

So we activated the SUPERDBA as " db_activate SUPERDBA,<password>

then it came to online. and afterwards we have used the load_systab command to load the tables.

BUT we could not find any Source System name like "RP1ADM" in the tables of the livecache database. Only there are CONTROL,SUPERDBA username availbale. Usually there will be also the source admin name . I dont know why it is missing

Before a month we have done livecahe restore same as now in that time we got the source system name admin also. ( RP1ADM) and also tables which owned by RP1ADM. alos i could find APPSYSPARAM table and the instance also registered.

But now in this restore we could not find the above.

We followed the same procedure and there is no change in the steps also.

Could anyone help me...

Regards

bala