Oracle database backup and recovery archive#
Oracle database backup and recovery Offline#

2.3 My database was terminated while in BACKUP MODE, do I need to recover?.2.2 How does one do on-line database backups?.2.1 How does one do off-line database backups?.1.8 I've lost an archived/online REDO LOG file, can I get my DB back?.1.7 How does one put a database into ARCHIVELOG mode?.1.6 How does one backup a database using the export utility?.1.5 My database is down and I cannot restore.1.4 What is the difference between restoring and recovering?.

Oracle database backup and recovery Offline#

1.3 What is the difference between online and offline backups?.

1.2 What strategies are available for backing-up an Oracle database?.

1.1 Why and when should I backup my database?.

1 General Backup and Recovery questions.

In this case, the current control file knows about the datafile.

Oracle database backup and recovery archive#

You archive all the active online redo logs.ДЄ user accidentally deletes the datafile history01.dbf from the operating system before you have a chance to back it up. You populate the newly created datafile with data. You create a tablespace history containing a single datafile called /mydb/history01.dbf. You make a whole database backup of your ARCHIVELOG mode database. In this example, the following sequence of events occurs: If the datafile was created in a parent incarnation, it will be created during restore or recover as appropriate. During recovery, the database will detect the missing datafile and report it to RMAN, which will create a new datafile and continue recovery by applying the remaining logs. The control file does not have the datafile record, that is, the user did not back up the control file after datafile creation. The RECOVER command can then apply the necessary logs to the datafile. If the datafile record is in the control file, then RESTORE creates the datafile in the original location or in a user-specified location (for example, with SET NEWNAME). The control file knows about the datafile, that is, the user backed up the control file after datafile creation, but the datafile itself is not backed up.

When a datafile is lost, the possible cases can be classified as follows: RMAN can handle lost datafiles without user intervention during restore and recovery. Recovering a Lost Datafile Without a Backup: Example Perform the restore and recovery operation described in 'Performing Disaster Recovery'. Or this example specifies files individually: CATALOG DATAFILECOPY For example, run: CATALOG START WITH '?/oradata/trgt/' For example, enter: CHANGE COPY OF DATAFILE 1,2,3,4,5,6,7,8 UNCATALOG Д¬atalog the datafile copies, using their new filenames or CATALOG START WITH (if you know all the files are in directories with a common prefix easily addressed with a CATALOG START WITH). Start RMAN and then uncatalog the datafile copies on the old host. For example, in UNIX: % cp -r /tmp/*dbf /net/new_host/oracle/oradata/trgt This example assumes that you are using a recovery catalog.ДЄfter connecting to the target database and recovery catalog, run a LIST command to see a listing of datafile copies and their associated primary keys, as in the following example: LIST COPY Д¬opy the datafile copies to the new host with an operating system utility. To move the database to a new host by means of datafile copies, you must transfer the copies manually to the new machine. Restoring Datafile Copies to a New Host: Example