-
RMAN BACKUP problem
Hi,
Oracle 10.2
WindowsNt
I am taking RMAN incremental level 0 database two months once and taking level 1 backup weekly once and level 2 backups daily.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My problem is when i give this command
RMAN> restore database preview;
Starting restore at 26-OCT-07
using channel ORA_DISK_1
data file 5 will be created automatically during restore operation
data file 6 will be created automatically during restore operation
data file 7 will be created automatically during restore operation
data file 8 will be created automatically during restore operation
data file 9 will be created automatically during restore operation
data file 10 will be created automatically during restore operation
data file 11 will be created automatically during restore operation
data file 12 will be created automatically during restore operation
data file 13 will be created automatically during restore operation
data file 14 will be created automatically during restore operation
data file 15 will be created automatically during restore operation
data file 16 will be created automatically during restore operation
data file 17 will be created automatically during restore operation
data file 18 will be created automatically during restore operation
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/26/2007 20:10:34
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
I dont know why it is giving like this. Any one plz Advice.....
TIA,
-
you dont have a backup to restore
-
Hi,
Thanx for ur reply...
RMAN> list backup summary;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
233 B 0 A DISK 21-SEP-07 1 1 NO TAG20070921T010030
237 B 2 A DISK 22-SEP-07 1 1 NO TAG20070922T020037
241 B 1 A DISK 23-SEP-07 1 1 NO TAG20070923T020025
245 B 2 A DISK 24-SEP-07 1 1 NO TAG20070924T020017
249 B 2 A DISK 25-SEP-07 1 1 NO TAG20070925T020026
253 B 2 A DISK 26-SEP-07 1 1 NO TAG20070926T020026
257 B 2 A DISK 27-SEP-07 1 1 NO TAG20070927T020037
260 B A A DISK 28-SEP-07 1 1 NO TAG20070928T020011
262 B 2 A DISK 28-SEP-07 1 1 NO TAG20070928T020627
263 B A A DISK 28-SEP-07 1 1 NO TAG20070928T020948
264 B A A DISK 29-SEP-07 1 1 NO TAG20070929T020010
265 B A A DISK 29-SEP-07 1 1 NO TAG20070929T020010
266 B A A DISK 29-SEP-07 1 1 NO TAG20070929T020010
268 B 2 A DISK 29-SEP-07 1 1 NO TAG20070929T020841
269 B A A DISK 29-SEP-07 1 1 NO TAG20070929T021622
270 B A A DISK 30-SEP-07 1 1 NO TAG20070930T020013
272 B 1 A DISK 30-SEP-07 1 1 NO TAG20070930T020022
273 B A A DISK 30-SEP-07 1 1 NO TAG20070930T023015
274 B A A DISK 01-OCT-07 1 1 NO TAG20071001T020008
276 B 2 A DISK 01-OCT-07 1 1 NO TAG20071001T020016
277 B A A DISK 01-OCT-07 1 1 NO TAG20071001T020040
278 B A A DISK 02-OCT-07 1 1 NO TAG20071002T020009
280 B 2 A DISK 02-OCT-07 1 1 NO TAG20071002T020025
281 B A A DISK 02-OCT-07 1 1 NO TAG20071002T020057
282 B A A DISK 03-OCT-07 1 1 NO TAG20071003T020010
284 B 2 A DISK 03-OCT-07 1 1 NO TAG20071003T020027
285 B A A DISK 03-OCT-07 1 1 NO TAG20071003T020049
286 B A A DISK 04-OCT-07 1 1 NO TAG20071004T020010
288 B 2 A DISK 04-OCT-07 1 1 NO TAG20071004T020027
289 B A A DISK 04-OCT-07 1 1 NO TAG20071004T020059
290 B A A DISK 05-OCT-07 1 1 NO TAG20071005T020010
292 B 2 A DISK 05-OCT-07 1 1 NO TAG20071005T020037
293 B A A DISK 05-OCT-07 1 1 NO TAG20071005T020110
294 B A A DISK 06-OCT-07 1 1 NO TAG20071006T020010
296 B 2 A DISK 06-OCT-07 1 1 NO TAG20071006T020026
297 B A A DISK 06-OCT-07 1 1 NO TAG20071006T020049
298 B A A DISK 07-OCT-07 1 1 NO TAG20071007T020009
300 B 1 A DISK 07-OCT-07 1 1 NO TAG20071007T020026
301 B A A DISK 07-OCT-07 1 1 NO TAG20071007T020107
302 B A A DISK 08-OCT-07 1 1 NO TAG20071008T020010
304 B 2 A DISK 08-OCT-07 1 1 NO TAG20071008T020027
305 B A A DISK 08-OCT-07 1 1 NO TAG20071008T020051
306 B A A DISK 09-OCT-07 1 1 NO TAG20071009T020012
308 B 2 A DISK 09-OCT-07 1 1 NO TAG20071009T020029
309 B A A DISK 09-OCT-07 1 1 NO TAG20071009T020052
310 B A A DISK 10-OCT-07 1 1 NO TAG20071010T020010
312 B 2 A DISK 10-OCT-07 1 1 NO TAG20071010T020027
313 B A A DISK 10-OCT-07 1 1 NO TAG20071010T020052
314 B A A DISK 10-OCT-07 1 1 NO TAG20071010T171334
316 B 0 A DISK 10-OCT-07 1 1 NO TAG20071010T171351
317 B A A DISK 10-OCT-07 1 1 NO TAG20071010T180335
318 B A A DISK 11-OCT-07 1 1 NO TAG20071011T020011
320 B 2 A DISK 11-OCT-07 1 1 NO TAG20071011T020021
321 B A A DISK 11-OCT-07 1 1 NO TAG20071011T020043
322 B A A DISK 12-OCT-07 1 1 NO TAG20071012T020009
324 B 2 A DISK 12-OCT-07 1 1 NO TAG20071012T020025
325 B A A DISK 12-OCT-07 1 1 NO TAG20071012T020058
326 B A A DISK 13-OCT-07 1 1 NO TAG20071013T020011
328 B 2 A DISK 13-OCT-07 1 1 NO TAG20071013T020028
329 B A A DISK 13-OCT-07 1 1 NO TAG20071013T020051
330 B A A DISK 14-OCT-07 1 1 NO TAG20071014T020009
332 B 1 A DISK 14-OCT-07 1 1 NO TAG20071014T020025
333 B A A DISK 14-OCT-07 1 1 NO TAG20071014T020058
334 B A A DISK 15-OCT-07 1 1 NO TAG20071015T020010
335 B 2 A DISK 15-OCT-07 1 1 NO TAG20071015T020027
336 B 2 A DISK 15-OCT-07 1 1 NO TAG20071015T020027
337 B A A DISK 15-OCT-07 1 1 NO TAG20071015T020052
338 B A A DISK 16-OCT-07 1 1 NO TAG20071016T020009
339 B 2 A DISK 16-OCT-07 1 1 NO TAG20071016T020026
340 B 2 A DISK 16-OCT-07 1 1 NO TAG20071016T020026
341 B A A DISK 16-OCT-07 1 1 NO TAG20071016T020048
342 B A A DISK 17-OCT-07 1 1 NO TAG20071017T020013
343 B 2 A DISK 17-OCT-07 1 1 NO TAG20071017T020144
344 B 2 A DISK 17-OCT-07 1 1 NO TAG20071017T020144
345 B A A DISK 17-OCT-07 1 1 NO TAG20071017T020215
346 B A A DISK 18-OCT-07 1 1 NO TAG20071018T020010
347 B 2 A DISK 18-OCT-07 1 1 NO TAG20071018T020037
348 B 2 A DISK 18-OCT-07 1 1 NO TAG20071018T020037
349 B A A DISK 18-OCT-07 1 1 NO TAG20071018T020108
350 B A A DISK 19-OCT-07 1 1 NO TAG20071019T020012
351 B 2 A DISK 19-OCT-07 1 1 NO TAG20071019T020050
352 B 2 A DISK 19-OCT-07 1 1 NO TAG20071019T020050
353 B A A DISK 19-OCT-07 1 1 NO TAG20071019T020122
354 B A A DISK 20-OCT-07 1 1 NO TAG20071020T020011
355 B 2 A DISK 20-OCT-07 1 1 NO TAG20071020T020048
356 B 2 A DISK 20-OCT-07 1 1 NO TAG20071020T020048
357 B A A DISK 20-OCT-07 1 1 NO TAG20071020T020120
358 B A A DISK 21-OCT-07 1 1 NO TAG20071021T020011
359 B 1 A DISK 21-OCT-07 1 1 NO TAG20071021T020029
360 B 1 A DISK 21-OCT-07 1 1 NO TAG20071021T020029
361 B A A DISK 21-OCT-07 1 1 NO TAG20071021T020112
362 B A A DISK 22-OCT-07 1 1 NO TAG20071022T020008
363 B 2 A DISK 22-OCT-07 1 1 NO TAG20071022T020016
364 B 2 A DISK 22-OCT-07 1 1 NO TAG20071022T020016
365 B A A DISK 22-OCT-07 1 1 NO TAG20071022T020040
366 B A A DISK 23-OCT-07 1 1 NO TAG20071023T020010
367 B 2 A DISK 23-OCT-07 1 1 NO TAG20071023T020039
368 B 2 A DISK 23-OCT-07 1 1 NO TAG20071023T020039
369 B A A DISK 23-OCT-07 1 1 NO TAG20071023T020112
370 B A A DISK 24-OCT-07 1 1 NO TAG20071024T020010
371 B 2 A DISK 24-OCT-07 1 1 NO TAG20071024T020109
372 B 2 A DISK 24-OCT-07 1 1 NO TAG20071024T020109
373 B A A DISK 24-OCT-07 1 1 NO TAG20071024T020142
374 B A A DISK 25-OCT-07 1 1 NO TAG20071025T020012
375 B 2 A DISK 25-OCT-07 1 1 NO TAG20071025T020050
376 B 2 A DISK 25-OCT-07 1 1 NO TAG20071025T020050
377 B A A DISK 25-OCT-07 1 1 NO TAG20071025T020123
378 B A A DISK 26-OCT-07 1 1 NO TAG20071026T020011
379 B 2 A DISK 26-OCT-07 1 1 NO TAG20071026T020049
380 B 2 A DISK 26-OCT-07 1 1 NO TAG20071026T020049
381 B A A DISK 26-OCT-07 1 1 NO TAG20071026T020123
382 B A A DISK 27-OCT-07 1 1 NO TAG20071027T020009
383 B 2 A DISK 27-OCT-07 1 1 NO TAG20071027T020048
384 B 2 A DISK 27-OCT-07 1 1 NO TAG20071027T020048
385 B A A DISK 27-OCT-07 1 1 NO TAG20071027T020122
386 B A A DISK 28-OCT-07 1 1 NO TAG20071028T020011
387 B 1 A DISK 28-OCT-07 1 1 NO TAG20071028T020029
388 B 1 A DISK 28-OCT-07 1 1 NO TAG20071028T020029
389 B A A DISK 28-OCT-07 1 1 NO TAG20071028T020100
390 B A A DISK 29-OCT-07 1 1 NO TAG20071029T020010
391 B 2 A DISK 29-OCT-07 1 1 NO TAG20071029T020018
392 B 2 A DISK 29-OCT-07 1 1 NO TAG20071029T020018
393 B A A DISK 29-OCT-07 1 1 NO TAG20071029T020039
I have 2 level 0 backups.
My recent level 0 backupsets are
RMAN> list backupset 314,315,316,317;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
314 242.92M DISK 00:00:16 10-OCT-07
BP Key: 314 Status: AVAILABLE Compressed: NO Tag: TAG20071010T171334
Piece Name: E:\BACKUP\FULLBCKP_OCT10\DB_9SIU5J1U_1_316
List of Archived Logs in backup set 314
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4132 298304607 10-OCT-07 298326899 10-OCT-07
1 4133 298326899 10-OCT-07 298367212 10-OCT-07
1 4134 298367212 10-OCT-07 298384126 10-OCT-07
1 4135 298384126 10-OCT-07 298389359 10-OCT-07
1 4136 298389359 10-OCT-07 298393801 10-OCT-07
1 4137 298393801 10-OCT-07 298404306 10-OCT-07
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
315 Incr 0 56.03G DISK 00:49:26 10-OCT-07
BP Key: 315 Status: AVAILABLE Compressed: NO Tag: TAG20071010T171351
Piece Name: E:\BACKUP\FULLBCKP_OCT10\DB_9TIU5J2G_1_317
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
316 Incr 0 10.23M DISK 00:00:02 10-OCT-07
BP Key: 316 Status: AVAILABLE Compressed: NO Tag: TAG20071010T171351
Piece Name: E:\BACKUP\FULLBCKP_OCT10\DB_9UIU5LVG_1_318
SPFILE Included: Modification time: 10-OCT-07
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
317 5.68M DISK 00:00:02 10-OCT-07
BP Key: 317 Status: AVAILABLE Compressed: NO Tag: TAG20071010T180335
Piece Name: E:\BACKUP\FULLBCKP_OCT10\DB_9VIU5LVN_1_319
List of Archived Logs in backup set 317
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 4138 298404306 10-OCT-07 298409305 10-OCT-07
It is physicaly available in that location.But in that list backup summary command, i dont know why it is not showing the backupset 315. Plz Advice...
TIA,
-
Hi
try
Code:
crosscheck backupset 315
and then try
Code:
list backup summary
-
hi navneeth,
you can check with LIST BACKUP OF DATABASE
to view all the backups that you did...
and you can also use REPORT NEED BACKUP
to check whether u excluded anything to take backup..
-
@hrishy
Thankx for ur reply.
RMAN> crosscheck backupset 315;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=118 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=E:\BACKUP\FULLBCKP_OCT10\DB_9TIU5J2G_1_317 recid=315 stamp=635620433
Crosschecked 1 objects
Its same as above i posted ....
@knitty
Thanks for ur reply..
RMAN> Report need backup;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 10/30/2007 08:47:02
RMAN-06525: RMAN retention policy is set to none
No i havent excluded anything. And yesterday when i gave list backup command it listed from date 14th OCT, but today it shows only from 16th OCT..
Plz Advice....
TIA,
-
Hi
For each of the backup pieces that belong to the backupset 315 try doing this
Code:
catalog backuppiece 'E:\BACKUP\FULLBCKP_OCT10\DB_9TIU5J2G_1_317'
and then try the list backup summary command
also post all your rman configuration parameters
using show configuration command at rman prompt
regards
Hrishy
-
Hi Hrishy,
Thanks for ur reply...
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO NONE;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFKURNIA.ORA'; # default
k my server is down so i cant check it now.
1.Is there any retention days for those repository records which is stored in the controlfile.B'cuse yesterday when i gave this >list backup of database;
It listed from OCT 14th,and now it lists from OCT16th so asking plz advice..
2.My retention period was set to redundancy 1 when i took backup, and yesterday only i changed it. Is this a problem ?
TIA,
-
Hi
setting the retention policy is site specific and what SLA requirements you have with your application team.It cannot be good or bad its simply site specific
For retention records set in the controlfile the default is 7 days.
Beware of setting this to a large value as in some case due to space issues in the controlfile the records are over written.
To the question of why it suddenly showing the backupsets from 16th oct you need to run the crosscheck backup command again to see there was some different retention policy and that cause the earlier backup of 14th oct to expire.
You can also run the list expired backups to see if those 14th oct backups are showing up as expired ones
Cut and paste the output of
list expired and list obsolete commands from RMAN prompt
regards
Hrishy
-
Hi,
1.
RMAN> report obsolete;
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of report command at 10/30/2007 16:50:52
RMAN-06525: RMAN retention policy is set to none
2.
RMAN> list expired backup;
using target database control file instead of recovery catalog
... it shows nothing.All backups are physicaly present in the destination.
TIA,
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|