No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
rman catalog - not able to see 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 |
| Thanks for the info, i was having the same issue f...... |
|
Unique Fumigation |
Feb 21, 2023, 09:12 |
| Subject: |
rman catalog - not able to see backup |
| Author: |
sze jie koh, Singapore |
| Date: |
Oct 15, 2022, 19:56, 230 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, 229 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, 228 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, 227 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
| Subject: |
Re: rman catalog - not able to see backup |
| Author: |
Unique Fumigation, Pakistan |
| Date: |
Feb 21, 2023, 09:12, 102 days ago |
| Message: |
Thanks for the info, i was having the same issue for our [url=https://uniquefumigation.com/blog/]pest blog[/url] |
| Your rating?: |
This reply is Good Excellent |
| Goto: |
Reply - Top of page |
If you think this item violates copyrights, please click here
|