Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: Scripting recover until cancel

    Hi,

    I want to restore an hot backup just after the backup (clone database).

    When i do the "recover database using backup controlfile until cancel" on sqlplus manually, it works good : <RET> to the first archivelog and <cancel> to the second.

    Now how can i do that in a shell script ? How can i submit the two answers to sqlplus ?

    Is there anybody who do a "recover database using backup controlfile until cancel" in a script ? How ?

    Carbone.

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    Use Oracle's syntax, not sqlplus.. that is, use
    Code:
    alter database recover using backup controlfile until cancel;
    and then you can submit cancel as
    Code:
    alter database recover cancel;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •