-
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
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
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.
-
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.
Reddy,Sam
-
You can use RECOVER DATABSE.... only from Server Manager
ALTER DATABASE RECOVER... can be used in application as SQL statment.
Regards.
-
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...
Reddy,Sam
-
It works on sqlplus also.
Ronnie
ronnie_yours@yahoo.com
You can if you think you can.
-
No difference between these two statements, you can use whatever you like.
You cannot succeed if you fear to face challenges.
MAS
BE(CS) , OCP 8/8i.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|