Oracle Backup

Download

Oracle client configuration

Oracle client installation

1. Download it from oracle site (select your OS and click See All).
2. Install it choosing Administrator installation type.
3. Add ORACLE_HOME environment variable (e.g. n:\app\bob.jates\product\11.2.0\client_1).
4. Add %ORACLE_HOME%\bin to PATH environment variable (e.g. add ;%ORACLE_HOME%\bin to the end of PATH environment variable) for the system variables.
5. Restart your computer to apply PATH value to system account.
6. Ensure that Oracle was configured properly:
   1. run Command Prompt (e.g. cmd.exe);
   2. run command rman in Command Prompt (you should see RMAN> in command prompt, then click Ctrl+C to exit);
   3. run command sqlplus.exe in Command Prompt (you should see Enter user-name: in command prompt, then click Ctrl+C to exit).

Note:

---

We don't recommend to setup Oracle Client and IASO Client to the server with Oracle data bases.

---

Connection to database configuration

1. Edit file %ORACLE_HOME%\network\admin\tnsnames.ora (e.g. with notepad). It should look like:

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =  ORACLE_HOST)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl1.solaris.iaso.local)
    )
  )

where

• ORCL1 is Oracle TNS alias,
• ORACLE_HOST is host name or IP where Oracle database is running,
• 1521 is Oracle database Listener port,
• orcl1.solaris.iaso.local is database service name.

2. Edit file %ORACLE_HOME%\network\admin\sqlnet.ora (e.g. with notepad). It should look like:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Mounting network share with Oracle backups

We have two ways to do it:

First way is:

1. Configure Backup Service Controller to run with Administrator account permissions.
2. Login to Windows under an Administrator account.
3. Add network share:

> net use o: \\oracle_host\oracle\app\oracle\backup /persistent:yes

Second way is:

1. Download Sysinternals PSExec toolset from here http://technet.microsoft.com/en-us/sysinternals/bb897553.
2. Extract downloaded archive to folder.
3. Run following Windows Command Prompt: cmd.exe.
4. Change Command Prompt directory to folder from point 2: cd "directory"
5. Start another cmd.exe with SYSTEM account using PSExec tool: psexec -i -s cmd.exe. You will see new console window. We'll write all commands into this console window.
6. Run following command in newely created console window: net use o: \\oracle_host\oracle\app\oracle\backup /persistent:yes. This command will attach network share to O: drive for SYSTEM account.

IASO2012 Client configuration

1. Open Oracle Databases tab in IASO2012 Client:
   
   
2. Add server credentials (e.g. ORCL1, admin, password, o:\, where ORCL1 is TNS alias specified in tnsnames.ora file, admin is Oracle account name with SYSDBA permissions, password is account password, o:\ is path to mounted network share.
   
   
3. Go to backup tree and try to expand Oracle databases node. Now you can do a backup.
   
   

Download