OraFAQ Forum: Backup & Recovery » Issues with Catalog start with

Home » RDBMS Server » Backup & Recovery » Issues with Catalog start with (oracle 11gr2 , Sun)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issues with Catalog start with [message #643644]

Wed, 14 October 2015 15:45

krish96
Messages: 74
Registered: October 2012

Member

Hello Experts,

I am trying to restore the database ..

here's the log
================

RMAN> connect target *
connected to target database: test (DBID=2001100)

RMAN> connect catalog *
connected to recovery catalog database

RMAN> set echo on
echo set on

RMAN> **end-of-file**

RMAN> catalog start with '/location/database_bkp/';
catalog start with 'location/database_bkp/';
searching for all files that match the pattern location/database_bkp/
no files found to be unknown to the database

and physically the files are available on that location..

thanks in advance

Report message to a moderator

Re: Issues with Catalog start with [message #643646 is a reply to message #643644]

Wed, 14 October 2015 16:54

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And RMAN seems to already known them.

Report message to a moderator

Re: Issues with Catalog start with [message #643666 is a reply to message #643644]

Thu, 15 October 2015 03:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

RMAN> list backup;

Report message to a moderator

Re: Issues with Catalog start with [message #643690 is a reply to message #643666]

Thu, 15 October 2015 07:43

krish96
Messages: 74
Registered: October 2012

Member

hello,

these are the three files from that location..

o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54gp1x_.bkp
o1_mf_ncnd1_CRON_DLY_INCR_DB_CMP_bx54l5tf_.bkp
o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54m9h4_.bkp

and from the list backup shows only two files are restored..

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364233 Incr 1 2.89M DISK 00:00:00 08/17/2015 10:02:38 PM
BP Key: 4364239 Status: AVAILABLE Compressed: YES Tag: CRON_DLY_INCR_DB_CMPRSS
Piece Name: /fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_ncnd1_CRON_DLY_INCR_DB_CMP_bx54l5tf_.bkp
Control File Included: Ckp SCN: 12081822206982 Ckp time: 08/17/2015 10:00:16 PM
List of Datafiles in backup set 4364233
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------------- ----
1 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/system01.dbf
2 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u06/RMAN_BKPDB/data/toad_128K.dbf
3 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/sysaux.dbf
6 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u03/RMAN_BKPDB/data/quest_tools_128K.dbf
7 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u03/RMAN_BKPDB/data/tcrs_dm_frwk_intrs_4M.dbf
9 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u03/RMAN_BKPDB/data/tcrs_dm_mcrf_4M.dbf
18 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u07/RMAN_BKPDB/data/tcrs_dm_invl_prty_fact_4M.dbf
23 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/tcrs_dm_crsh_loc_dimn_4M.dbf
24 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u06/RMAN_BKPDB/index/tcrs_dm_idx_crsh_loc_dimn_4M.dbf
27 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u03/RMAN_BKPDB/index/tcrs_dm_idx_invl_prty_fact_4M.dbf
30 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u06/RMAN_BKPDB/index/tcls_idx_4M.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364234 Incr 1 1.92M DISK 00:00:00 08/17/2015 10:03:21 PM
BP Key: 4364240 Status: AVAILABLE Compressed: YES Tag: CRON_DLY_INCR_DB_CMPRSS
Piece Name: /fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54m9h4_.bkp
List of Datafiles in backup set 4364234
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------------- ----
4 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/users_128K.dbf
8 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u03/RMAN_BKPDB/data/tcrs_dm_harm_evnt_grp_4M.dbf
20 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/index/tcrs_dm_idx_crash_dimn_4M.dbf
25 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/tcrs_dm_s00_4M.dbf
32 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/mail_attachments_128K.dbf
33 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u08/RMAN_BKPDB/data/system_audit.dbf
34 1 Incr 12081822206982 08/17/2015 10:00:16 PM /u01/RMAN_BKPDB/data/contraxx03_8M.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364235 Incr 0 1.66G DISK 00:00:17 10/13/2015 11:25:45 AM
BP Key: 4364241 Status: AVAILABLE Compressed: NO Tag: TAG20151013T112527
Piece Name: /fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_nnnd0_TAG20151013T112527_c1t8m8c1_.bkp
List of Datafiles in backup set 4364235
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------------- ----
5 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/oracle_xdb_1M.dbf
10 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_frwk_intrs_4M.dbf
11 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_harm_evnt_grp_4M.dbf
12 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_mcrf_4M.dbf
13 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/data/tcls_4M.dbf
14 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u01/RMAN_BKPDB/data/tcrs_dm_4M.dbf
15 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_4M.dbf
16 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u01/RMAN_BKPDB/data/tcrs_dm_128K.dbf
17 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_128K.dbf
19 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u01/RMAN_BKPDB/data/tcrs_dm_crash_dimn_4M.dbf
21 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/data/tcrs_dm_crsh_fact_4M.dbf
22 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u01/RMAN_BKPDB/index/tcrs_dm_idx_crsh_fact_4M.dbf
26 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_s00_idx_4M.dbf
28 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u06/RMAN_BKPDB/data/tcrs_dm_unit_dimn_4M.dbf
29 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u02/RMAN_BKPDB/index/tcrs_dm_idx_unit_dimn_4M.dbf
31 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/undo/undo_01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364236 Incr 0 2.34G DISK 00:00:13 10/13/2015 11:26:06 AM
BP Key: 4364242 Status: AVAILABLE Compressed: NO Tag: TAG20151013T112527
Piece Name: /fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_ncnd0_TAG20151013T112527_c1t8n2v4_.bkp
Control File Included: Ckp SCN: 12081822234482 Ckp time: 10/13/2015 11:25:15 AM
List of Datafiles in backup set 4364236
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------------- ----
1 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/system01.dbf
2 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u06/RMAN_BKPDB/data/toad_128K.dbf
3 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/sysaux.dbf
6 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/data/quest_tools_128K.dbf
7 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/data/tcrs_dm_frwk_intrs_4M.dbf
9 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/data/tcrs_dm_mcrf_4M.dbf
18 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u07/RMAN_BKPDB/data/tcrs_dm_invl_prty_fact_4M.dbf
23 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/tcrs_dm_crsh_loc_dimn_4M.dbf
24 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u06/RMAN_BKPDB/index/tcrs_dm_idx_crsh_loc_dimn_4M.dbf
27 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/index/tcrs_dm_idx_invl_prty_fact_4M.dbf
30 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u06/RMAN_BKPDB/index/tcls_idx_4M.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364237 Incr 0 620.30M DISK 00:00:04 10/13/2015 11:26:14 AM
BP Key: 4364243 Status: AVAILABLE Compressed: NO Tag: TAG20151013T112527
Piece Name: /fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_nnnd0_TAG20151013T112527_c1t8nl47_.bkp
List of Datafiles in backup set 4364237
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------------- ----
4 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/users_128K.dbf
8 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u03/RMAN_BKPDB/data/tcrs_dm_harm_evnt_grp_4M.dbf
20 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/index/tcrs_dm_idx_crash_dimn_4M.dbf
25 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/tcrs_dm_s00_4M.dbf
32 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/mail_attachments_128K.dbf
33 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u08/RMAN_BKPDB/data/system_audit.dbf
34 0 Incr 12081822234482 10/13/2015 11:25:15 AM /u01/RMAN_BKPDB/data/contraxx03_8M.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------------
4364238 Full 32.67M DISK 00:00:00 10/13/2015 11:26:18 AM
BP Key: 4364244 Status: AVAILABLE Compressed: NO Tag: TAG20151013T112618
Piece Name: /fra2/RMAN_BKPDB/autobackup/2015_10_13/o1_mf_s_892985115_c1t8ntsq_.bkp
SPFILE Included: Modification time: 10/13/2015 11:25:29 AM
SPFILE db_unique_name: RMAN_BKPDB
Control File Included: Ckp SCN: 12081822234482 Ckp time: 10/13/2015 11:25:15 AM

o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54gp1x_.bkp is missing if i do RMAN> catalog start with '/location/database_bkp/'; it gives the same issue..

Thank you,

Report message to a moderator

Re: Issues with Catalog start with [message #643691 is a reply to message #643690]

Thu, 15 October 2015 07:46

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Copy and paste the output of your entire RMAN session please.

Report message to a moderator

Re: Issues with Catalog start with [message #643692 is a reply to message #643691]

Thu, 15 October 2015 07:57

krish96
Messages: 74
Registered: October 2012

Member

RMAN> catalog start with '/fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54gp1x_.bkp';
catalog start with '/fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54gp1x_.bkp';
searching for all files that match the pattern /fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54gp1x_.bkp
no files found to be unknown to the database

RMAN>

Report message to a moderator

Re: Issues with Catalog start with [message #643693 is a reply to message #643692]

Thu, 15 October 2015 08:06

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

RMAN> crosscheck backup;

Report message to a moderator

Re: Issues with Catalog start with [message #643694 is a reply to message #643693]

Thu, 15 October 2015 08:15

krish96
Messages: 74
Registered: October 2012

Member

RMAN> crosscheck backup;
crosscheck backup;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_ncnd1_CRON_DLY_INCR_DB_CMP_bx54l5tf_.bkp RECID=4846 STAMP=892914992
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/backupset/2015_08_17/o1_mf_nnnd1_CRON_DLY_INCR_DB_CMP_bx54m9h4_.bkp RECID=4847 STAMP=892914992
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_nnnd0_TAG20151013T112527_c1t8m8c1_.bkp RECID=4848 STAMP=892985128
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_ncnd0_TAG20151013T112527_c1t8n2v4_.bkp RECID=4849 STAMP=892985154
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/backupset/2015_10_13/o1_mf_nnnd0_TAG20151013T112527_c1t8nl47_.bkp RECID=4850 STAMP=892985170
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/fra2/RMAN_BKPDB/autobackup/2015_10_13/o1_mf_s_892985115_c1t8ntsq_.bkp RECID=4851 STAMP=892985178
Crosschecked 6 objects

RMAN>

Report message to a moderator

Re: Issues with Catalog start with [message #643699 is a reply to message #643694]

Thu, 15 October 2015 10:49

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

I'm not sure what you're trying to achieve. What does the following yield?

RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;

Report message to a moderator

Previous Topic:	periodic maintenance of .arc files
Next Topic:	Restore database using datafile control file and Redo Logfile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 08:16:18 CST 2025