No question at this time
DBA Top 10
1 M. Cadot 6300
2 B. Vroman 2700
3 P. Tsongayinwe 1500
4 P. Wisse 1300
4 J. PĂ©ran 1300
6 A. Kavsek 900
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
10 B. B 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48709
Total active users1322
Act. users last 24h2
Act. users last hour0
Registered user hits last week33
Registered user hits last month217
Go up

rman catalog - not able to see backup
Next thread: Add & remove External redendency DG with failed group as same disk
Prev thread: How to offload RMAN backups from ZDLRA to a local drive for tape backup

Message Score Author Date
hi all it was stated that rman catalog is usefu...... sze jie koh Oct 15, 2022, 19:56
Hi noob, Yes, database name is important. A cat...... Philip Wisse Oct 17, 2022, 12:15
hi Philip Good to still see you around I hav...... sze jie koh Oct 17, 2022, 18:18
Hi noob, So first you need to connect to a targ...... Philip Wisse Oct 18, 2022, 16:34

Follow up by mail Click here


Subject: rman catalog - not able to see backup
Author: sze jie koh, Singapore
Date: Oct 15, 2022, 19:56, 43 days ago
Os info: solaris 11
Oracle info: 19c
Message: hi all

it was stated that rman catalog is useful when you lost your control flie because it keep track of your backup location

i am trying to simulate a recovery of database using an auxiliary instance connected to rman catalog

but no matter how - the backup done previously will not show up


source db_name - orcl
rman target / catalog rman/backup@test
backup database include current controlfile plus archivelog

auxiliary db_name - orcl
instance name - orcltest

-bash-5.1$ cat initorcltest.ora
db_name=orcl
db_unique_name=orcltest
db_domain=ifast.com
db_create_file_dest='+DATA'

export ORACLE_SID=orcltest;
sqlplus / as sysdba
startup nomount;

-bash-5.1$ rman target / catalog rman/backup@test

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Oct 16 01:34:46 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (not mounted)
connected to recovery catalog database

RMAN> set dbid 1583819332

executing command: SET DBID
database name is "ORCL" and DBID is 1583819332

RMAN> restore controlfile;

Starting restore at 16-OCT-22 01:35:07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=12 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/16/2022 01:35:08
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

RMAN> list backup;

specification does not match any backup in the repository


if i use the original database and connect to catalog - i am able to see all the backup
i am also able to restore the controlfile directly using the actual path to backup file

q1) why am i not able to see the catalog rman backup even if i set the correct dbid already ? just because i use a different instance name ?
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rman catalog - not able to see backup
Author: Philip Wisse, Netherlands
Date: Oct 17, 2022, 12:15, 42 days ago
Message: Hi noob,

Yes, database name is important. A catalog may contain backups from more than 1 databases.

https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/SET.html#GUID-BC501B5C-4CD0-485D-AA18-27E2894024C3
Please read the 'Run the SET DBID command only in the following specialized circumstances:' section

There are several meanings of catalog:
1. The CATALOG START WITH command from within rman
2. The catalog database wich contains backup info (metadata)

If you know the controlfile backup file name, use:
RESTORE CONTROLFILE FROM syntax

Why are you using auxiliary database?

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rman catalog - not able to see backup
Author: sze jie koh, Singapore
Date: Oct 17, 2022, 18:18, 42 days ago
Message: hi Philip

Good to still see you around

I have never really seen any recovery scenario / examples online using rman catalog despite seeing alot of articles on creating the rman catalog

so i decided to try out a complete recovery using rman catalog

i thought i will need an auxiliary instance in order to restore anything ... else by just connecting to the catalog i cannot seem to restore anything

is this not the case here ?


-bash-5.1$ rman catalog rman/backup@test

Recovery Manager: Release 19.0.0.0.0 - Production on Tue Oct 18 00:16:09 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

connected to recovery catalog database

RMAN> set dbid 1583819332

executing command: SET DBID
database name is "ORCL" and DBID is 1583819332

RMAN> list backup summary;


List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------ ------- ------- ---------- ---
2252 B A A DISK 14-OCT-22 22:54:42 1 1 NO TAG20221014T225441
2253 B F A DISK 14-OCT-22 22:54:51 1 1 NO TAG20221014T225443
2254 B F A DISK 14-OCT-22 22:54:55 1 1 NO TAG20221014T225443
2255 B A A DISK 14-OCT-22 22:55:02 1 1 NO TAG20221014T225502
2256 B F A DISK 14-OCT-22 22:55:07 1 1 NO TAG20221014T225506

RMAN> restore spfile from autobackup;

Starting restore at 18-OCT-22 00:16:32

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2022 00:16:32
RMAN-06171: not connected to target database

RMAN> restore controlfile from autobackup;

Starting restore at 18-OCT-22 00:16:57

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2022 00:16:57
RMAN-06496: must use the TO clause when the database is mounted or open

RMAN> restore controlfile to '/tmp/control01.ctl';

Starting restore at 18-OCT-22 00:17:12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/18/2022 00:17:13
RMAN-06171: not connected to target database



Hope to hear your advice
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: rman catalog - not able to see backup
Author: Philip Wisse, Netherlands
Date: Oct 18, 2022, 16:34, 41 days ago
Message: Hi noob,

So first you need to connect to a target database, usually the database from which the backups were made. This is what the error message says.

Else search scenario's for out-of-place restoration.

Forget about aux, this is for duplicating or special restoration like 'point in time'.

Hth, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here