Wronge incarinnation of this file- wrong creation of scn

[Former Member]

Dear all ,

I have take the back up of our DEV server. and restored in the new server. While restoring i am getting Wrong incartion of this file and wrong SCN. i have followed the note 400421 and 134592. while i am executing two below queries in SQL .

sqlplus /nolog @sapdba_role SR3

sqlplus /nolog @sapdba_role r3;

i am disconnecting from the database

i am pasting the sapdba_role file

Connected.

PL/SQL procedure successfully completed.

cursor Curs_1 is select username from sys.dba_users where username like :Prefix;

*

ERROR at line 7:

ORA-06550: line 7, column 43:

PL/SQL: ORA-01219: database not open: queries allowed on fixed tables/views

only

ORA-06550: line 7, column 18:

PL/SQL: SQL Statement ignored

ORA-06550: line 11, column 9:

PLS-00201: identifier 'DBMS_SQL.OPEN_CURSOR' must be declared

ORA-06550: line 11, column 1:

PL/SQL: Statement ignored

ORA-06550: line 15, column 34:

PLS-00201: identifier 'DBMS_SQL.NATIVE' must be declared

ORA-06550: line 15, column 2:

PL/SQL: Statement ignored

ORA-06550: line 16, column 13:

PLS-00201: identifier 'DBMS_SQL.EXECUTE' must be declared

ORA-06550: line 16, column 2:

PL/SQL: Statement ignored

ORA-06550: line 36, column 36:

PLS-00201: identifier 'DBMS_SQL.NATIVE' must be declared

ORA-06550: line 36, column 4:

PL/SQL: Statement ignored

ORA-06550: line 37, column 15:

PLS-00201: identifier 'DBMS_SQL.EXECUTE' must be declared

ORA-06550: line 37, column 4:

PL/SQL: Statement ignored

ORA-06550: line 47, column 39:

PL/SQL: ORA-01219: database not open: queries allowed on fixed tables/views

only

ORA-06550: lin

grant sapdba to system

*

ERROR at line 1:

ORA-01109: database not open

grant select_catalog_role to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.file$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.ts$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.uet$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.fet$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.obj$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.seg$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.tab$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.ind$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.clu$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.lob$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.user$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant select on sys.object_usage$ to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant create session to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant create view to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant create synonym to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter session to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter system to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter database to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter tablespace to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter any table to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant alter any index to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant analyze any to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant analyze any dictionary to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant gather_system_statistics to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant create public synonym to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant drop public synonym to sapdba

*

ERROR at line 1:

ORA-01109: database not open

grant create job to sapdba

*

ERROR at line 1:

ORA-01109: database not open

old 1: grant ALL on &User..SDBAH to sapdba

new 1: grant ALL on SAPr3;.SDBAH to sapdba

grant ALL on SAPr3;.SDBAH to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..SDBAD to sapdba

new 1: grant ALL on SAPr3;.SDBAD to sapdba

grant ALL on SAPr3;.SDBAD to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAML to sapdba

new 1: grant ALL on SAPr3;.DBAML to sapdba

grant ALL on SAPr3;.DBAML to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBARCL to sapdba

new 1: grant ALL on SAPr3;.DBARCL to sapdba

grant ALL on SAPr3;.DBARCL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAFID to sapdba

new 1: grant ALL on SAPr3;.DBAFID to sapdba

grant ALL on SAPr3;.DBAFID to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAEXTL to sapdba

new 1: grant ALL on SAPr3;.DBAEXTL to sapdba

grant ALL on SAPr3;.DBAEXTL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAREOL to sapdba

new 1: grant ALL on SAPr3;.DBAREOL to sapdba

grant ALL on SAPr3;.DBAREOL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBABARL to sapdba

new 1: grant ALL on SAPr3;.DBABARL to sapdba

grant ALL on SAPr3;.DBABARL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBADFL to sapdba

new 1: grant ALL on SAPr3;.DBADFL to sapdba

grant ALL on SAPr3;.DBADFL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAOPTL to sapdba

new 1: grant ALL on SAPr3;.DBAOPTL to sapdba

grant ALL on SAPr3;.DBAOPTL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBASPAL to sapdba

new 1: grant ALL on SAPr3;.DBASPAL to sapdba

grant ALL on SAPr3;.DBASPAL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBABD to sapdba

new 1: grant ALL on SAPr3;.DBABD to sapdba

grant ALL on SAPr3;.DBABD to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBABL to sapdba

new 1: grant ALL on SAPr3;.DBABL to sapdba

grant ALL on SAPr3;.DBABL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBATL to sapdba

new 1: grant ALL on SAPr3;.DBATL to sapdba

grant ALL on SAPr3;.DBATL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAOBJL to sapdba

new 1: grant ALL on SAPr3;.DBAOBJL to sapdba

grant ALL on SAPr3;.DBAOBJL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAPHAL to sapdba

new 1: grant ALL on SAPr3;.DBAPHAL to sapdba

grant ALL on SAPr3;.DBAPHAL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAGRP to sapdba

new 1: grant ALL on SAPr3;.DBAGRP to sapdba

grant ALL on SAPr3;.DBAGRP to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBAERR to sapdba

new 1: grant ALL on SAPr3;.DBAERR to sapdba

grant ALL on SAPr3;.DBAERR to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBATRIAL to sapdba

new 1: grant ALL on SAPr3;.DBATRIAL to sapdba

grant ALL on SAPr3;.DBATRIAL to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBSTATC to sapdba

new 1: grant ALL on SAPr3;.DBSTATC to sapdba

grant ALL on SAPr3;.DBSTATC to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBSTATTORA to sapdba

new 1: grant ALL on SAPr3;.DBSTATTORA to sapdba

grant ALL on SAPr3;.DBSTATTORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBSTATIORA to sapdba

new 1: grant ALL on SAPr3;.DBSTATIORA to sapdba

grant ALL on SAPr3;.DBSTATIORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBSTATHORA to sapdba

new 1: grant ALL on SAPr3;.DBSTATHORA to sapdba

grant ALL on SAPr3;.DBSTATHORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBSTAIHORA to sapdba

new 1: grant ALL on SAPr3;.DBSTAIHORA to sapdba

grant ALL on SAPr3;.DBSTAIHORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBMSGORA to sapdba

new 1: grant ALL on SAPr3;.DBMSGORA to sapdba

grant ALL on SAPr3;.DBMSGORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..DBCHECKORA to sapdba

new 1: grant ALL on SAPr3;.DBCHECKORA to sapdba

grant ALL on SAPr3;.DBCHECKORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant ALL on &User..MLICHECK to sapdba

new 1: grant ALL on SAPr3;.MLICHECK to sapdba

grant ALL on SAPr3;.MLICHECK to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..TGORA to sapdba

new 1: grant SELECT on SAPr3;.TGORA to sapdba

grant SELECT on SAPr3;.TGORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..IGORA to sapdba

new 1: grant SELECT on SAPr3;.IGORA to sapdba

grant SELECT on SAPr3;.IGORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..TSORA to sapdba

new 1: grant SELECT on SAPr3;.TSORA to sapdba

grant SELECT on SAPr3;.TSORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..TAORA to sapdba

new 1: grant SELECT on SAPr3;.TAORA to sapdba

grant SELECT on SAPr3;.TAORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..IAORA to sapdba

new 1: grant SELECT on SAPr3;.IAORA to sapdba

grant SELECT on SAPr3;.IAORA to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..SVERS to sapdba

new 1: grant SELECT on SAPr3;.SVERS to sapdba

grant SELECT on SAPr3;.SVERS to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..CVERS to sapdba

new 1: grant SELECT on SAPr3;.CVERS to sapdba

grant SELECT on SAPr3;.CVERS to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DD02L to sapdba

new 1: grant SELECT on SAPr3;.DD02L to sapdba

grant SELECT on SAPr3;.DD02L to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DD09L to sapdba

new 1: grant SELECT on SAPr3;.DD09L to sapdba

grant SELECT on SAPr3;.DD09L to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DDNTT to sapdba

new 1: grant SELECT on SAPr3;.DDNTT to sapdba

grant SELECT on SAPr3;.DDNTT to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DDART to sapdba

new 1: grant SELECT on SAPr3;.DDART to sapdba

grant SELECT on SAPr3;.DDART to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DARTT to sapdba

new 1: grant SELECT on SAPr3;.DARTT to sapdba

grant SELECT on SAPr3;.DARTT to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DBCHK to sapdba

new 1: grant SELECT on SAPr3;.DBCHK to sapdba

grant SELECT on SAPr3;.DBCHK to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 1: grant SELECT on &User..DBDIFF to sapdba

new 1: grant SELECT on SAPr3;.DBDIFF to sapdba

grant SELECT on SAPr3;.DBDIFF to sapdba

*

ERROR at line 1:

ORA-00911: invalid character

old 12: Statement := 'grant ALL on &User..SAPLIKEY to sapdba';

new 12: Statement := 'grant ALL on SAPr3;.SAPLIKEY to sapdba';

old 21: Statement := 'grant SELECT on &User..RSNSPACE to sapdba';

new 21: Statement := 'grant SELECT on SAPr3;.RSNSPACE to sapdba';

old 30: Statement := 'grant SELECT on &User..RSPSPACE to sapdba';

new 30: Statement := 'grant SELECT on SAPr3;.RSPSPACE to sapdba';

Curs := dbms_sql.open_cursor;

*

ERROR at line 9:

ORA-06550: line 9, column 9:

PLS-00201: identifier 'DBMS_SQL.OPEN_CURSOR' must be declared

ORA-06550: line 9, column 1:

PL/SQL: Statement ignored

ORA-06550: line 13, column 34:

PLS-00201: identifier 'DBMS_SQL.NATIVE' must be declared

ORA-06550: line 13, column 2:

PL/SQL: Statement ignored

ORA-06550: line 14, column 13:

PLS-00201: identifier 'DBMS_SQL.EXECUTE' must be declared

ORA-06550: line 14, column 2:

PL/SQL: Statement ignored

ORA-06550: line 22, column 34:

PLS-00201: identifier 'DBMS_SQL.NATIVE' must be declared

ORA-06550: line 22, column 2:

PL/SQL: Statement ignored

ORA-06550: line 23, column 13:

PLS-00201: identifier 'DBMS_SQL.EXECUTE' must be declared

ORA-06550: line 23, column 2:

PL/SQL: Statement ignored

ORA-06550: line 31, column 34:

PLS-00201: identifier 'DBMS_SQL.NATIVE' must be declared

ORA-06550: line 31, column 2:

PL/SQL: Statement ignored

ORA-06550: line 32, column 13:

PLS-00201: identifier 'DBMS_SQL.EXECUTE' must be declared

ORA-06550: line 32, column 2:

PL/SQL: Statement ignored

ORA-06550:

Thanks and Regards

Santhi

[volker_borowski2]

Hello,

you are trying to analyze the wrong problem.

Your recovery was faulty. Your database is complaining that it is not OPEN.

In this state, you will never be able to run sapdba_role.sql, so absolutely no

need to analyze any errors related to that log.

First you need to successfully restore and may be recover your database.

select status from v$database;

should give "OPEN" as a result to assure you, that the recovery was successfull.

"Wrong incarnation" looks like a controlfile missmatch, like you left the controlfiles of the

original system in place and did not create new controlfiles to adjust the SID to the new

datafiles to be attached to the target db.

So how did you do the restore / recovery ?

Volker