Diff between Alter Database Recover ... and Recover database ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

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

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    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.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  4. #4
    Join Date
    May 2002
    Posts
    37
    You can use RECOVER DATABSE.... only from Server Manager

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

    Regards.

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  6. #6
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    It works on sqlplus also.

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #7
    Join Date
    Jun 2002
    Posts
    73
    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
  •  



Click Here to Expand Forum to Full Width