topic Re: backup in Data Management Questions

backup

jayasudha — Wed, 13 Jul 2016 03:04:56 GMT

Working with Oracle 11gR2 and arcsde 10.1
I generally take backup of user schema using data pump utilities. Do i need to take backup of sde schema ? What situation this would be useful ?

Re: backup

RexRobichaux2 — Thu, 14 Jul 2016 17:03:18 GMT

Hello Jaya,

It would be helpful to know a bit more about the database in question that you are performing backups on in regards to user and schema structure. That said, here is a good prior presentation covering a wealth of Oracle information- including a section on backups (slide / page 40): http://proceedings.esri.com/library/userconf/proc14/tech-workshops/tw_549.pdf Note- best practice is to backup all schemas- including SDE Schema. I hope this is helpful for you-

-Rex

Re: backup

jayasudha — Fri, 15 Jul 2016 03:34:22 GMT

Hello, Thanks for the reply and proceedings.

I want to know about sde schema corruption. What operations could cause that ?

How do i come to know that sde schema is corrupted...any error message ?

Re: backup

PanagiotisPapadopoulos — Fri, 15 Jul 2016 10:04:55 GMT

ArcSDE schema must participate on backup process.

User Schema keeps all you data, but SDE schema keeps the system information for your schema (registation ids, fields, formats, versioning tables e.t.c).

After a database restore maybe some more steps needed in order to make the geodatabase work.

1. import sde schema

2. import data schema owner

3. compile all schemas (EXEC DBMS_UTILITY.COMPILE_SCHEMA(‘SDE’);)

4. GRANT privileges to Public see below

GRANT EXECUTE ON dbms_pipe TO public;

GRANT EXECUTE ON dbms_lock TO public;

5. Finally try to rebuilt or better to re create spatial indexes.

Re: backup

jayasudha — Mon, 18 Jul 2016 10:25:40 GMT

Thanks for the details.

How do i know that sde is corrupted and requires restore from backup ?

What operation could cause sde corruption ?