RMAN Restore/Duplicate without Catalog
Date: Thu, 24 Nov 2022 04:15:16 +0000 (UTC)
Message-ID: <1405874523.1492243.1669263316730_at_mail.yahoo.com>
Hi Everyone
Please share the RMAN command that can be used to test the restore.
TxSanjay
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 24 2022 - 05:15:16 CET