Diff between Alter Database Recover ... and Recover database ...

[ronnie]

Are these 2 statements similar every respect. If yes why do they have 2 command to do the same exact thing.

Alter database recover until cancel using backup controlfile;

Recover database until cancl using backup controlfile;


Thanks

[stecal]

Backward/forward compatiblity thing - recover command has alter database implicitly implied. Oracle Corp saved DBA's from having to type two extra words for a common procedure.

[sreddy]

Using Media Recovery Statements
Oracle uses these basic media recovery SQL*Plus statements, which differ only in the way the system determines the set of files to be recovered:

RECOVER DATABASE
RECOVER TABLESPACE
RECOVER DATAFILE

Each statement uses the same criteria to determine whether files are recoverable. Oracle prevents two recovery sessions from recovering the same file and prevents media recovery of a file that is in use.

You can also use the SQL statement ALTER DATABASE RECOVER, although Oracle strongly recommends you use the SQL*Plus RECOVER statement instead so that Oracle will prompt you for the names of the archived redo logs.

Basic statements purpose is different little bit. AFA option of recovering until cancel using controlfile its same.

[dave777]

You can use RECOVER DATABSE.... only from Server Manager

ALTER DATABASE RECOVER... can be used in application as SQL statment.

Regards.

[sreddy]

Originally posted by dave777
You can use RECOVER DATABSE.... only from Server Manager

ALTER DATABASE RECOVER... can be used in application as SQL statment.

Regards.

RECOVER DATABSE.... can be used from SQL. Thats what oracle docs says: Not tried from SQLPLUS though...

[ronnie]

It works on sqlplus also.

[asharsidd]

No difference between these two statements, you can use whatever you like.