Re: RMAN Restore/Duplicate without Catalog
Date: Fri, 25 Nov 2022 04:19:33 +0000 (UTC)
Message-ID: <434507868.3733366.1669349973986_at_mail.yahoo.com>
Hi Hemant
RMAN> connect auxiliary /
On Thursday, November 24, 2022 at 07:53:40 PM EST, Hemant K Chitale <hemantkchitale_at_gmail.com> wrote:
Put the SET DBID within the RUN paragraphLine 5 has an extra quotation mark at the end
Hemant K Chitale
Thanks for the update. I tried and now got the different error
connected to auxiliary database: HICPSUPD (not mounted)
RMAN> run{set dbid 11111111;set until time "to_date('21-NOV-2022 22:00:00','dd-mm-yyyy hh24:mi:ss')";allocate auxiliary channel ch1 type 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/local_home/oracle/admin/sh/tdpo.temtstd.opt)';allocate auxiliary channel ch2 type 'sbt_tape' PARMS 'ENV=(TDPO_OPTFILE=/local_home/oracle/admin/sh/tdpo.temtstd.opt)';duplicate database temtstd to newtstd backup location 'sbt_tape' nofilenamecheck;}2> 3> 4> 5> 6> 7> 8>
executing command: SET DBID
executing command: SET until clause
allocated channel: ch1channel ch1: SID=6882 device type=SBT_TAPEchannel ch1: Data Protection for Oracle: version 8.1.9.0
allocated channel: ch2channel ch2: SID=3139 device type=SBT_TAPEchannel ch2: Data Protection for Oracle: version 8.1.9.0
Starting Duplicate Db at 24-NOV-22released channel: ch1released channel: ch2RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of Duplicate Db command at 11/24/2022 23:06:57RMAN-05501: aborting duplication of target databaseRMAN-05572: CONTROLFILE backup not found for database TEMTSTD with DBID 11111111 created before to_date('21-NOV-2022 22:00:00','dd-mm-yyyy hh24:mi:ss') in sbt_tape
I was checking the error and found that From the documentation :BACKUP LOCATION backup_location : Specifies the backup location on disk where the backups and copies of the database to be duplicated have been placed. This option is valid for duplication without a target or a recovery catalog connection.
Any suggestion please
Sanjay
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> 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-lReceived on Fri Nov 25 2022 - 05:19:33 CET