Home -> Mailing Lists -> Oracle-L -> RMAN Restore/Duplicate without Catalog

RMAN Restore/Duplicate without Catalog

From: Sanjay Mishra <"Sanjay>
Date: Thu, 24 Nov 2022 04:15:16 +0000 (UTC)
Message-ID: <1405874523.1492243.1669263316730_at_mail.yahoo.com> 








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> run2> {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 commandsRMAN-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.
TxSanjay

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


Received on Thu Nov 24 2022 - 05:15:16 CET












Original text of this message