Scripting recover until cancel

dcharbonnel · #1 (**permalink**) 01-27-06, 07:48

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.

JMartinez · #2 (**permalink**) 01-27-06, 09:12

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;

Internet Services

Web Development

Digital Marketing

Consumer Tech