Skip to main content
SnapManager for SAP

Create the repository database instance

Contributors netapp-revathid
PDFs

The repository database instance is an Oracle database in which you create the SnapManager repository. The repository database instance must be a stand-alone database and cannot be the target database.

What you'll need

You must have an Oracle database and a user account to access the database.

Steps

  1. Log in to SQL *Plus: sqlplus '/ as sysdba'

  2. Create a new tablespace for the SnapManager repository: create tablespacetablespace_name datafile ′/u01/app/oracle/oradata/datafile/tablespace_name.dbf′ size 100M autoextend on;

    tablespace_name is the name of the tablespace.

  3. Verify the block size of the tablespace: select tablespace_name, block_size from dba_tablespaces;

    SnapManager requires a minimum 4-K block size for the tablespace.