Home » RDBMS Server » Backup & Recovery » RECOVER DATABASE
RECOVER DATABASE [message #157379] Thu, 02 February 2006 01:31 Go to next message
Messages: 83
Registered: October 2005
Location: chennai
1...RECOVER DATABASE command can be used only when the database is mounted but not open.

RECOVER TABLESPACE command must be mounted and open.

i want to know why RECOVER DATABASE command is used in
open ????

2.. we can put datafiles offline when the database is in mounted stage..can we put datafile when the database is in open ?????

Re: RECOVER DATABASE [message #217685 is a reply to message #157379] Sun, 04 February 2007 14:16 Go to previous message
Messages: 1
Registered: February 2007
Location: Bangalore
Junior Member

1) The Recover Database option is used to recover all datafiles needing recovery, either up to the point of failure, called complete recovery, or up to a point in the past before the failure, called incomplete recovery, which is only available using this option. Recover Database is performed only from the MOUNT state, so, the database will have to be SHUT DOWN before using this.

2) Recover Datafile can also be issued from the OPEN state (except for SYSTEM) while the rest of the database is still up and running.
Offline the datafile, restore the datafile, recover datafile, and online the datafile, as shown below:

$ sqlplus "/ as sysdba"
SQL> alter database datafile '/u03/oradata/PROD/devl_PROD_01.dbf' offline;
SQL> !cp -p /u03/oradata/prod1/devl_PROD_01.dbf /u03/oradata/PROD
SQL> recover automatic datafile '/u03/oradata/PROD/devl_PROD_01.dbf';
SQL> alter database datafile '/u03/oradata/PROD/devl_PROD_01.dbf' online;
Previous Topic: need oracle 10g adming guide (pdf)
Next Topic: Recovery error during duplicate database on remote host
Goto Forum:

Current Time: Wed Oct 26 12:46:56 CDT 2016

Total time taken to generate the page: 0.23624 seconds