| RECOVER DATABASE [message #157379] |
Thu, 02 February 2006 01:31  |
venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai
|
Member |
|
|
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  |
durga.naik@gmail.com
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
