session helps you view the details of all the transactions being performed. The IBackup for Windows application supports two distinct modes to restore the Oracle server database - Complete and Incomplete recovery. Note : It is always recommended that Oracle database backup/restore is performed with the assistance of/by a qualified Oracle database administrator (DBA).<br><br> IBackup's Oracle server database backup is downloadable from the IBackup website http://www.ibackup.com as a plug-in. Copyright © Pro Softnet Corporation. All rights reserved.<br><br> 2 Oracle Server Backup IBackup for Windows allows you to backup the Oracle server databases to your IBackup account without interrupting the Oracle server services that are already running. You can also schedule the backups for a later date and time. Features Authentication of the Oracle server database for backup Provision to report the progress of the backup process Provision to schedule backups for a future date and time with the various scheduling options Secure backups with the highest level of 128-bit SSL encryption on transmission, optional 256-bit proprietary encryption on storage with a user-defined encryption key that is not stored anywhere on IBackup servers Easy-to-use wizards for scheduling the backup jobs Provision for Email and Desktop notifications upon completion of the scheduled backup jobs Provision to generate the log files for each backup session Requirements for Oracle server backup Install the IBackup for Windows application on the computer where the Oracle 9i/10g/11g server/client is available The selected temporary directory on your local computer should have sufficient free disk space to hold the Oracle 9i/10g/11g database backups The database must be in ARCHIVELOG mode The Oracle server user should have SYSDBA privilege Oracle Recovery Manager (RMAN) should be available on the computer where the IBackup for Windows application has been installed Note: Consult your Oracle DBA for details on the configuration parameters.<br><br> How to enable ARCHIVELOG Mode To enable ARCHIVELOG Mode using the Oracle Recovery Manager (RMAN), follow the steps given below: 1. RMAN> connect target <username>/<PWD>@<SID> [connect to your Oracle database]; 2. RMAN> shutdown immediate; 3.<br><br> RMAN> startup mount; 4. RMAN> sql 8alter database archivelog 9; 5. RMAN> alter database open; Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 3 System Requirements For Oracle 9i Pentium 166 MHz or higher processor 128 MB RAM (256 MB recommended) Hard disk space of about 140 MB on the System Drive with an additional 4.5 GB for the Oracle Home Drive (FAT) or 2.8 GB for the Oracle Home Drive (NTFS) Sufficient free hard disk space to store the database backup files Microsoft Windows XP, Windows Server 2003, Windows 2000 with service pack 1, and Windows NT 4.0 with service pack 5 For Oracle 10g/11g Minimum 200 MHz processor Minimum 256 MB RAM (512 MB recommended) 1.5 GB hard disk space Sufficient free hard disk space to store the database backup files Microsoft Windows XP Professional, Windows Server 2003, Windows 2000 with service pack 1 or higher, Windows NT Server 4.0 and Windows NT Server Enterprise Edition 4.0 Terminal Server Edition with service pack 6a or higher Copyright © Pro Softnet Corporation. All rights reserved.<br><br> 4 How to backup Oracle server to your IBackup account Listed below are the steps to backup the Oracle server databases to your IBackup account: Step 1 Access the Oracle Server Backup option You can do so in two ways: On the application Menu Bar go to Backup-Restore > Oracle Server > Oracle Server Backup On the application Tool Bar, go to Wizards > Advanced Backup > Oracle Server > Oracle Server Backup Copyright © Pro Softnet Corporation. All rights reserved. 5 Step 2 The Oracle server login screen is displayed as shown below.<br><br> On this screen, 1. Enter the Username and Password. 2.<br><br> Enter the Host String (database name or tnsnames and so on) and click the 8Login 9 button. Copyright © Pro Softnet Corporation. All rights reserved.<br><br> 6 Step 3 On the Oracle server backup screen, click the 8Browse 9 button and select a temporary location on your local computer where the Oracle server backups would be stored. Note: Ensure that the selected temporary directory on the local computer has sufficient free disk space to hold the Oracle server backup resources. Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 7 Step 4 The selected temporary directory is displayed on the 8Oracle Server Backup 9 screen as shown below. Click the 8Next 9 button.<br><br> Copyright © Pro Softnet Corporation. All rights reserved. 8 Step 5 Select a folder in your IBackup account and click the 'Next' button.<br><br> Copyright © Pro Softnet Corporation. All rights reserved. 9 Step 6 In the 8Schedule backup/restore 9 screen, take an immediate backup using the 8Start the job immediately 9 option or schedule it for a future date and time and click the 8Close 9 button.<br><br> Note: IBackup for Windows allows you to schedule the Oracle server backup for different database instances. For easy identification of the Oracle server backup set, the name of the backup set will begin with 'IBORACLEBkset' followed by the Database SID (Database System Identifier) name that you have scheduled for backup. For example: If the Database SID name is 'JOHN,' then the name of the backup job will be IBORACLEBkset (JOHN_DB).' Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 10 Oracle Server Restore IBackup for Windows allows you to restore the backed up Oracle server databases from your local computer to your Oracle server in a secure, quick and a reliable way. Features Authentication of the Oracle server database for restore Provision to report progress of the restore process Secure backups with the highest level of 128-bit SSL encryption on transmission, optional 256-bit proprietary encryption on storage with a user-defined encryption key that is not stored anywhere on IBackup servers Provision to generate log files for each restore session Requirements for restore Following are the requirements for Oracle server restore: Install the IBackup for Windows application on the computer where the Oracle 9i/10g/11g server/client is available The selected temporary directory on your local computer should have sufficient free disk space to hold the Oracle 9i/10g/11g database restores The database must be in ARCHIVELOG mode The Oracle server user should have SYSDBA privilege Oracle Recovery Manager (RMAN) should be available on the computer where the IBackup for Windows application has been installed Note: Consult your Oracle DBA for details on the configuration parameters.<br><br> How to enable ARCHIVELOG Mode: To enable ARCHIVELOG Mode using the Oracle Recovery Manager (RMAN), follow the steps given below: 1. RMAN> connect target <username/PWD>@<SID> [connect to your Oracle database]; 2. RMAN> shutdown immediate; 3.<br><br> RMAN> startup mount; 4. RMAN> sql 8alter database archivelog 9; 5. RMAN> alter database open; Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 11 How to restore your Oracle server database Follow the steps below, to restore your Oracle server databases from your computer to the Oracle server. Step 1 Access the Oracle Server Restore option in any of the following ways: On the application menu, go to Backup-Restore menu option > Oracle Server > Oracle Server Restore On the application Tool bar > go to Advanced Backup > Oracle Server > Oracle Server Restore Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 12 Step 2 The 8Oracle Server Restore Wizard 9 explaining the restore procedure is displayed. Click the 8Next 9 button to proceed.<br><br> Copyright © Pro Softnet Corporation. All rights reserved. 13 Step 3 The 8Oracle Server Login 9 screen is displayed as shown below.<br><br> On this screen, 1. Enter the Username and Password. 2.<br><br> Enter the Host String (database name or tnsnames and so on) and click the 8Login 9 button. Copyright © Pro Softnet Corporation. All rights reserved.<br><br> 14 Step 4 On the 8Oracle Restore screen 9, using the 8Browse 9 button, select the folder where you wish to restore the Oracle server database files. The selected folder is displayed on the Oracle Restore screen as shown below. You can choose the mode of recovery, based on your restore needs: Complete Recovery: Restores all the Oracle server database files that have been backed up till now.<br><br> Incomplete Recovery: This is a time-based recovery of Oracle databases. It restores files as of a date and time that you have specified for restore. Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 15 Note: Select the same folder 8IBORACLEBackup 9 where the Oracle server databases were previously backed up. If you have deleted the folder, create the folder with the same name using same path, while performing backup.<br><br> Step 5 The selected folder along with the Oracle server database name is displayed in the 8Oracle Server Restore 9 screen as shown below. Click the 'Restore 9 button to retrieve the Oracle server database files. Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 16 Step 6 A message, as shown below, appears. If you click the Yes button, the database files present on your Oracle server would be overwritten.<br><br> Step 7 On completion of the Oracle server restore process, a message is displayed, as shown below. Incomplete Recovery Incomplete Recovery is a time-based recovery of the Oracle databases. This restores the Oracle server database files, of a particular date and time, specified during restore.<br><br> To perform the Incomplete Recovery of your Oracle database(s) Perform the above-mentioned steps till Step 3. Copyright © Pro Softnet Corporation. All rights reserved.<br><br> 17 Step 4 On the Oracle Restore screen, select the option 8Incomplete Recovery. 9 Copyright © Pro Softnet Corporation. All rights reserved. 18 Step 5 Double-click the database name (displayed on the list box of the above screen) and enter/select the appropriate date and time.<br><br> The date and time selected for Incomplete recovery of the databases should not be less than the database creation time or resetlogs creation time. Click the 8Save 9 button. Now click on the 8Restore 9 button and follow the procedure from Step 5 .<br><br> On completion of the Oracle server restore process, a message confirming its success is displayed. You may view the logs for a complete summary of restore operation. Copyright © Pro Softnet Corporation.<br><br> All rights reserved. 19 Troubleshooting The following are few simple troubleshooting methods, which could resolve few minor problems while working with IBackup for Windows application. Windows 2000 you must have service pack 2 or higher installed on the machine for encryption on storage to work properly You must have proper privileges to register the files required during installation It is highly recommended to have the latest service pack for Windows installed on the computer The system must have an ATX power supply and provide appropriate support in order for Automatic Power off to work, otherwise the machine will just reboot IBackup for Windows requires proxy settings if the computer is behind a proxy When the application hangs for a long time and no transfer occurs, Logout of the application and login into the application again.<br><br> Copyright © Pro Softnet Corporation. All rights reserved. 20 IBackup Support Pro Softnet Corporation, IBackup Division, 26115 Mureau Road, Suite A, Calabasas, CA 91302.<br><br> Telephone 1-800-949-3555 ext 3 within USA 1-818-251-4200 ext 3 outside USA Monday - Friday, 6:00 AM to 6:00 PM PST Fax 1-818-878-9208 Email address support@ibackup.com For more information visit: http://www.ibackup.com/ Copyright © Pro Softnet Corporation. All rights reserved. 21<br><br>

less