Re: RMAN Restore/Duplicate without Catalog

Put the SET DBID within the RUN paragraph Line 5 has an extra quotation mark at the end

Hemant K Chitale

On Thu, Nov 24, 2022 at 12:16 PM Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:

> Hi Everyone
>
> I need some help in RMAN restore where the backup is going to the TSM Tape
> library and it is not using Catalog.
> 1. Can I able to use the Duplicate command without Source and Catalog and
> using the Tape library?
> 2. How to restore the existing database running on the server with a
> different name ?
>
> I tried few things like
> RMAN> set dbid 11111111;
>
> executing command: SET DBID
>
> RMAN> run
> 2> {
> 3> set until time "to_date('22-NOV-2022 22:00:00','dd-mm-yyyy
> hh24:mi:ss')";
> 4> allocate auxiliary channel ch1 type 'sbt_tape' PARMS
> 'ENV=(TDPO_OPTFILE=/local_home/oracle/admin/sh/tdpo.temtstd.opt)';
> 5> allocate auxiliary channel ch2 type 'sbt_tape' PARMS
> 'ENV=(TDPO_OPTFILE=/local_home/oracle/admin/sh/tdpo. temtstd.opt)'';
> 6> duplicate database temtstd to newtstd backup location 'sbt_tape'
> nofilenamecheck;
>
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-00558: error encountered while parsing input commands
> RMAN-01009: syntax error: found "single-quoted-string": expecting one of:
> "auxiliary, connect, format, maxopenfiles, maxpiecesize, parms, rate, send,
> to, ;"
> RMAN-01007: at line 5 column 121 file: standard input
>
>
>
> Please share the RMAN command that can be used to test the restore.
>
> Tx
> Sanjay
>

--
http://www.freelists.org/webpage/oracle-l