Re: RMAN Restore/Duplicate without Catalog

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: ch1
> channel ch1: SID=6882 device type=SBT_TAPE
> channel ch1: Data Protection for Oracle: version 8.1.9.0
>
> allocated channel: ch2
> channel ch2: SID=3139 device type=SBT_TAPE
> channel ch2: Data Protection for Oracle: version 8.1.9.0
>
> Starting Duplicate Db at 24-NOV-22
> released channel: ch1
> released channel: ch2
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of Duplicate Db command at 11/24/2022 23:06:57
> RMAN-05501: aborting duplication of target database
> RMAN-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 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
>
>

-- 
+353-86-0695383

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