OID backup and restore

  1. Backup OID schema ODS from database.
  2. Set ORACL_HOME & ORACLE_INSTANCE variables
  3. Backup OID schema by executing below command
    $ORACLE_HOME/ldap/bin/ldapsearch -h <hostname> -p <port> -D cn=orcladmin -w <paswd> -L -b cn=subschemasubentry -s base -v “objectclass=*” > oidschemebk.ldif

Backup:
$ORACLE_HOME/ldap/bin/ldifwrite connect=”OIDDB” basedn=”dc=domain” ldiffile=”OID_backup.ldif”

Restore:
$ORACLE_HOME/ldap/bin/bulkdelete connect=”OIDDB” basedn=”dc=domain”
$ORACLE_HOME/ldap/bin/bulkload connect=”OIDDB” check=”TRUE” generate=”TRUE” load=”TRUE” restore=”TRUE” append=”TRUE” file=”OID_backup.ldif

Where connect is connect string of OID defined in tnsnames.ora

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s