Backing up the database managed by the user

Last update on July 2, 2009 07:40 AM by jak58
Published by jak58

Backing up the database managed by the user







1. Query views for information on database files

Use the view V$DATAFILE to obtain a list of names and statements of all data files
Use the V$CONTROLFILE to display all the control files
Use the V$LOGFILE view to display all the names of redo log files
Use the V$TABLESPACE and V$DATAFILE to obtain a list of all data files and their respective tablespaces

2. Backing up the database

Includes all datafiles and control files that constitute the Oracle database when it is closed
The steps of the backup are:
  • Compile the updated list of all files to be backed up
  • Stop the Oracle instance using the command 
  • SHUTDOWN NORMAL/IMMEDIATE /Transactional
    .
  • Back up all data files and control files with a backup utility operating system .
  • Restart Oracle.
Best answers for « Backing up the database managed by the user » in :
Back up of your drivers with Drivermax ShowBack up of your drivers with Drivermax Introduction Tip: DriverMax is a software allowing you to make the back up of all your all drivers without the use of a back up CD. Introduction This freeware software allows other...
Automatic backup of a Database in SQL EXPRESS 2005 ShowAutomatic backup of a Database in SQL EXPRESS 2005 If you want to automate a backup of a database in SQL Server Express, there is a simple solution using a .bat. file. Create a new text file. This file should contain the following...
Backup/Restore Mysql database ShowBackup/Restore Mysql database Backup Restore your database Note A simple approach on how to backup and restore MySQL databases. Backup To save an existing database it is recommended that you create a dump. To dump all...
Download Back Me Up Backup Software ShowBack Me Up Backup Software is a backup software. Backups are archived in ZIP format which allows you to recover easily your files. Back Me Up supports the following media: ZIP disks, hard disks, CDs and DVDs. Advantage A wizard that guides you...
Download Automatic Backup ShowWhen you lose your data, it is not necessary to persuade your that to possess an effective saving program is the best solution. Automatic Backup is a program which will not only protect your data, but it will also keep the former versions of your...
Download BackRex Office Backup Show
Backup ShowBackup Setting up a redundant architecture ensures that system data will be available but does not protect the data against user-introduced errors or against natural disasters such as fires, floods or even earthquakes. Therefore it is necessary to...
Operating Systems - Customising DOS ShowThe DOS start-up procedure is defined in the autoexec.bat and config.sys files located in the root of your "C:\" drive. We highly recommend making back up copies of these files before modifying them. To deactivate a line of command in either file...
They need your help