Home » RDBMS Server » Backup & Recovery » Issues with Catalog start with (oracle 11gr2 , Sun)
Issues with Catalog start with [message #643644] Wed, 14 October 2015 15:45 Go to next message
krish96
Messages: 70
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
Re: Issues with Catalog start with [message #643646 is a reply to message #643644] Wed, 14 October 2015 16:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And RMAN seems to already known them.

Re: Issues with Catalog start with [message #643666 is a reply to message #643644] Thu, 15 October 2015 03:33 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
RMAN> list backup;
Re: Issues with Catalog start with [message #643690 is a reply to message #643666] Thu, 15 October 2015 07:43 Go to previous messageGo to next message
krish96
Messages: 70
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,
Re: Issues with Catalog start with [message #643691 is a reply to message #643690] Thu, 15 October 2015 07:46 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
Copy and paste the output of your entire RMAN session please.
Re: Issues with Catalog start with [message #643692 is a reply to message #643691] Thu, 15 October 2015 07:57 Go to previous messageGo to next message
krish96
Messages: 70
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>
Re: Issues with Catalog start with [message #643693 is a reply to message #643692] Thu, 15 October 2015 08:06 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
RMAN> crosscheck backup;
Re: Issues with Catalog start with [message #643694 is a reply to message #643693] Thu, 15 October 2015 08:15 Go to previous messageGo to next message
krish96
Messages: 70
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>
Re: Issues with Catalog start with [message #643699 is a reply to message #643694] Thu, 15 October 2015 10:49 Go to previous message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, 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;
Previous Topic: periodic maintenance of .arc files
Next Topic: Restore database using datafile control file and Redo Logfile
Goto Forum:
  


Current Time: Wed Feb 21 22:00:55 CST 2018

Total time taken to generate the page: 0.03684 seconds