ECC5 US7ASCII character set non Unicode, problem with copy back

[Former Member]

I'm trying to do an Oracle restore method to complete a copy back, but I get the following error:

ERROR 2009-05-21 20:41:18

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-01503: CREATE CONTROLFILE failedORA-01565: error in identifying file'H:\ORACLE\ABC\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'ORA-27047: unable to read the header block of fileOSD-04001: invalid logical block size

The restore was tablespace and an OFFLINE.

The source was US7ASCII NLS, however when I installed the database (9i) and the CI and DB I didn't seem to have US7ASCII available option - only WE8DEC.

Could this be the problem and anyone esle seen this?

Thanks in advance.

Jeff

[fidel_vales · Accepted solution]

Hi,

Of course I'm guessing but, what is the value of your parameter DB_BLOCK_SIZE now and what was before?

also, I do not understand what are you doing?

> I'm trying to do an Oracle restore method to complete a copy back.

you are trying to copy back what from what?

> The restore was tablespace and an OFFLINE.

you restored only one tablespace?

> I installed the database (9i)

9i is not supported anymore, not a "big issue" but, you are limiting your options

> didn't seem to have US7ASCII available option - only WE8DEC.

Probably the oracle parameter file created by SAPINST will not match the DB you are restoring and you can have problems there. Also you should review your environment variables

[Former Member · Accepted solution]

Thanks for the reply. This is non-Unicode, ECC5 on Oracle 9i ...

I have done a FULL OFFLINE restore of the SAPDATA tablespaces (1 - 6) to disk, and now want to a) build a configuration file (via CONTROL.SQL under the DB installation / Restore method) b) start the DB

But when it reads the CONTROL.SQL it seems to think the first datafile (system_1 ..) is either corrupt or it can't read for some reason. We have restored that one file but still problems.....

The DB_BLOCK_SIZE is the same as the source - since the CONTROL.SQL file is built from the BACKUP CONTROLFILE TO TRACE .. and is 8192.

My gut feeling is that because the source was upgraded to PRD sometime ago, the NLS was never upgraded from US7ASCII to WE8DEC; and now when trying to do a copyback (or possible a restore in a DR situation) when building SAP / ORACLE using the ECC 5 installation kit it no longer supports (or allows) to use US7ASCII. Therefore when trying to read the data then it can't do this ... But so far not finding any evidence other than a statement in the auto generated CONTROL.XML file for the CI:

"

//----

---

//Further default values

//----

---

var defaultRow = new Array;

//Defaults for nlsCharacterSet

if (installationIsUnicode())

{

defaultRow.nlsCharacterSet = "UTF8";

}

else

{

defaultRow.nlsCharacterSet = "WE8DEC";

}

fieldsThatDontNeedUserInput.push("nlsCharacterSet");

if ("EXP" != whatAction)

{

tORA_DbConfig = new Table("tORA_DbConfig");

tORA_DbConfig.remove("WHERE nlsCharacterSet = 'US7ASCII'");

tGlobalDbParameters.updateRow({nlsCharacterSet: defaultRow.nlsCharacterSet},

"WHERE dbSid = getContextParameter('dbSid')");

...

"

As this is a Windows 2003 box I have attempted to add in NLS_LANG = AMERICAN_AMERICA.US7ASCII in the ENV variables under Administrator and de-installed and re-installed the Oracle execuatables ... but their is no option under Oracle 9i install to choose NLS ... and so no effect.

I think I need to follow OSS Note 102402 on the SOURCE, and upgrade NLS to WE8DEC and then peform a BACKUPand then restore and copyback using that - therefore the kit will support that ....

Cheers,

Jeff

[Former Member]

Hi,

Check below links & SAP notes.

http://help.sap.com/saphelp_nw70/helpdata/EN/0d/d2ffba4a0c11d182b80000e829fbfe/frameset.htm

Note 546006 - Problems with Oracle due to operating system errors

Note 147243 - R3COPY under NT Oracle ( If your OS is Win NT)

Note 606359 - FAQ: Oracle National Language Support (NLS)

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=34490

http://download.oracle.com/docs/cd/A58617_01/server.804/a58312/apd4.htm

Hope this helps.

Thanks

Sushil

Edited by: Sushil Suryawanshi on May 22, 2009 4:38 AM