Re: RMAN Restore/Duplicate without Catalog
Date: Fri, 25 Nov 2022 15:22:49 +0000 (UTC)
Message-ID: <784094297.3837620.1669389769484_at_mail.yahoo.com>
Frank
Thanks for the update. I can restore using restore from auto backup but then cannot mount as the database with the same db_name is already running on the server. I want to restore the DB a different name. When I tried to restore control file from auto backup and it was done successfully but when tried to mount, it gave an error that cannot mount the database in exclusive mode. Not sure if this is due to the same db_name running on the server. I used a different ORACLE_SID but db_name in the pfile is same as otherwise Restore controlfile from auto backup can give an error that dbname in Controlfile is not matching. So any help is appreciated to test.
Sanjay On Friday, November 25, 2022 at 06:31:49 AM EST, Frank Gordon <frankagordon_at_gmail.com> wrote:
Hello,
You may be in a position where you have to restore the backup piece containing your controlfile to the file system using the media manager.
Do you know enough about your media manager to get a listing of the files on it?Can you ask someone that knows TDPO to get you that listing?
One of the files should contain a backup of the controlfile. You'll have to use the media manager to get that onto your database server.Then you can restore controlfile from '/path/to/restored_file/on/db_server' in rman.
Regards,Frank
On Fri, Nov 25, 2022 at 4:20 AM Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:
Hi Hemant
Thanks for the update. I tried and now got the different error
RMAN> connect auxiliary /
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 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
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
-- +353-86-0695383 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 25 2022 - 16:22:49 CET