How to recover an Oracle XE Backup First make sure the database is in archive log mode and running backups on a daily basis. See Oracle XE Backup for instructions on how to do this. Reverting to a Previous Backup If something has gone wrong with the database, such as deleting or corrupting a database file, and […]
Monthly Archives: May 2008
Oracle Backup and Recovery Scenarios
Some standard recovery scenarios Deleted or Corrupted Datafile If a database datafile in the $ORACLE_HOME/oradata/XE is deleted then the database will no longer open. It is not possible to recover just the datafile from a backup since it will be out of sync with the other datafiles and data will have been lost. If the […]
Setting up VNCServer
How to setup vncserver on a linux machine to run gnome or kde. Initialize Startup vncserver for the first time on port 5910 (:10) and set the password. [root@localhost ~]# vncserver :10 You will require a password to access your desktops. Password: Verify: xauth: creating new authority file /root/.Xauthority New ‘localhost.localdomain:10 (root)’ desktop is localhost.localdomain:10 […]
Setup Oracle XE Account on Linux
The oracle account that is created by the Oracle XE installer isn’t very helpful. Setup Bash Log into the system as root and su to oracle #su – oracle Copy over the bash files from the /etc/skel directory cp /etc/skel/.bash* . Edit .bash_profile and add ORACLE_HOME, ORACLE_SID and add $ORACLE_HOME/bin to PATH vi .bash_profile export […]