| |
| |
 Oracle Server Backup |
| |
|
| |
|
| |
|
| |
|
| |
How do I backup Oracle databases? |
| |
To view the steps to backup the Oracle server database, click here.
|
| |
 |
| |
|
| |
What version of Oracle does IBackup for Windows support? |
| |
IBackup for Windows currently supports backup/restore of Oracle 9i and Oracle 10g versions.
|
| |
|
| |
|
| |
Does IBackup for Windows perform Incremental backup of Oracle databases? |
| |
Yes. IBackup for Windows performs incremental backup of Oracle databases. |
| |
|
| |
|
| |
Can I backup Oracle server databases located at a remote location, using the IBackup for Windows application? |
| |
Yes, you can backup the Oracle server databases present at a remote location. For this, select a temporary directory on the computer where the Oracle server service is running. Ensure that the temporary directory selected on the computer for the local backup of Oracle server is mapped from a remote location and has space to hold the Oracle server backup resources.
|
| |
|
| |
|
| |
Are there any special settings that I should be aware of while performing backup/restore using the IBackup for Windows application? |
| |
Yes. The following are the special settings that you need to make:
a. The Oracle database selected for backup must be in the ARCHIVELOG Mode.
b. For remote backup, select the temporary directory on the computer where the Oracle server service is running. Ensure that the temporary directory selected on the computer for the local backup of the Oracle server is mapped from a remote location and has sufficient space to hold the Oracle server backup resources.
c. You must have the SYSDBA privileges.
|
| |
|
| |
|
| |
How do I convert the database to the ARCHIVELOG Mode? |
| |
To perform the Oracle server database backup, set the database to the ARCHIVELOG Mode.
To enable ARCHIVELOG Mode using 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. RMAN> startup mount;
4. RMAN> sql 'alter database archivelog';
5. RMAN> alter database open
|
| |
|
| |
|
| |
Can I backup the databases from multiple instances of the Oracle server with IBackup for Windows? |
| |
Yes. IBackup for Windows can backup databases from multiple instances of the Oracle server.
|
| |
|
| |
|
| |
Can I select the Oracle server backup location on the network? |
| |
The IBackup for Windows application allows you to select the backup location on the network for the remote backup of Oracle server databases. Choose the temporary location on the computer where the Oracle server service is running. Ensure that the temporary directory selected on the computer for the local backup of Oracle server is mapped from the remote computer and has sufficient space to hold the Oracle server backup resources.
|
| |
|
| |
|
| |
Where and how should I select the remote server backup location? |
| |
Select the temporary location on the remote computer where the Oracle Server service is running. Ensure that the temporary directory selected on the computer for the local backup of Oracle server is mapped from the remote computer and has sufficient space to hold the Oracle server backup resources.
|
| |
|
| |
|
| |
I am receiving an error message stating: 'ORA-01031: insufficient privileges' while performing the Oracle server Backup. Why? |
| |
This error occurs if you have logged into the Oracle server that does not have sufficient privileges to perform backup and restore operations.
To resolve the issue you need SYSDBA privileges:
Syntax: SQL>grant sysdba to <user>
|
| |
|
| |
|
| |
Can I perform Oracle server backup in the 'Mirror Path' mode? |
| |
No. Even if you choose the 'Mirror Path' for backups, they take place in the 'Relative Path' mode.
|
| |
|
| |
|
| |
Can I add/modify the files present in the Oracle backup folder 'IBORACLEBackup'? |
| |
No. It is not advisable to add/modify files present in the Oracle backup folder 'IBORACLEBackup'. Any modification to files present in this folder impacts your Oracle server restore operations.
|
| |
|
| |
|
| |
Can I remove the Oracle backup folder 'IBORACLEBackup' from my local computer on completion of Oracle server backup to my IBackup account? |
| |
Yes. You can remove the Oracle backup folder 'IBORACLEBackup' from your local computer on successful completion of the Oracle server backup to your IBackup account. However, removing this folder prevents local Incremental backup of your Oracle server databases.
|
| |
|
| |
|
| |
How do I restore my Oracle database back to Oracle server? |
| |
You can restore data from your IBackup account to the Oracle server using IBackup for Windows 'Oracle Server Restore' option. For details, click here.
|
| |
|
| |
|
| |
Where should I place Oracle backup folder 'IBORACLEBackup' to perform Network/Remote Oracle server database restore? |
| |
You need to select a temporary location on the computer where the Oracle server service is running. The 'IBORACLEBackup' folder selected for restore should be in the same path as it was, while performing the backup operation.
|
| |
|
| |
|
| |
What is incomplete recovery? |
| |
Incomplete recovery allows you to recover the state of the database to as of any required time. If any important table was dropped and needs to be recovered, then specify the time before it was dropped and recover the same using 'Incomplete recovery'.
|
| |
|
| |
|
| |
|
