| RMAN error in oracle 10g [message #268041] |
Mon, 17 September 2007 05:20  |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
hi everybody!pls.help...i just copied the backup file from production UNIX server to another UNIX server.this other UNIX server has uniform config with the production...when i restore the copied backup file this error comes out...
RMAN> restore database;
Starting restore at 17-SEP-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2183 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=2182 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=2181 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=2180 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=2179 devtype=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: sid=2178 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/17/2007 12:59:58
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 36 found to restore
RMAN-06023: no backup or copy of datafile 35 found to restore
RMAN-06023: no backup or copy of datafile 34 found to restore
RMAN-06023: no backup or copy of datafile 33 found to restore
RMAN-06023: no backup or copy of datafile 32 found to restore
RMAN-06023: no backup or copy of datafile 31 found to restore
RMAN-06023: no backup or copy of datafile 30 found to restore
RMAN-06023: no backup or copy of datafile 29 found to restore
RMAN-06023: no backup or copy of datafile 28 found to restore
RMAN-06023: no backup or copy of datafile 27 found to restore
RMAN-06023: no backup or copy of datafile 26 found to restore
RMAN-06023: no backup or copy of datafile 25 found to restore
RMAN-06023: no backup or copy of datafile 24 found to restore
RMAN-06023: no backup or copy of datafile 23 found to restore
RMAN-06023: no backup or copy of datafile 22 found to restore
RMAN-06023: no backup or copy of datafile 21 found to restore
RMAN-06023: no backup or copy of datafile 20 found to restore
RMAN-06023: no backup or copy of datafile 19 found to restore
RMAN-06023: no backup or copy of datafile 18 found to restore
RMAN-06023: no backup or copy of datafile 17 found to restore
RMAN-06023: no backup or copy of datafile 16 found to restore
RMAN-06023: no backup or copy of datafile 15 found to restore
RMAN-06023: no backup or copy of datafile 14 found to restore
RMAN-06023: no backup or copy of datafile 13 found to restore
RMAN-06023: no backup or copy of datafile 12 found to restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to 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
RMAN>
tanx a lot and more power!
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #268054 is a reply to message #268044] |
Mon, 17 September 2007 06:14  |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
RMAN> list incarnation;
using target database control file instead of recovery catalog
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL 1157779562 CURRENT 236285604 21-AUG-07
RMAN>
sir, i am restoring the copied backup file from production to this other server...production server and this server has the same configuration....
tanx
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #268590 is a reply to message #268041] |
Wed, 19 September 2007 02:30 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oraarch/RMAN/bakup/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 6 BACKUP TYPE TO COMPRESSED BACKUPSET;
_%s_%p.back' ;
run {
backup filesperset 6 database;
sql 'alter system archive log current';
l_file1.ctl''";
archivelog all delete all input ;
l_file2.ctl''";
}
this is the script used for backing up in production(server A) ...then the backup file is copied to another server(server B).then, this copied backup file is restored in(server B). can this be possible?
|
|
|
|
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #268610 is a reply to message #268593] |
Wed, 19 September 2007 02:55 |
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
|
Member |
|
|
You have not entered the filename:
RMAN> catalog backuppiece '/u01/app/oraarch/RMAN/bakup';
Give the name of the file also.
RMAN> catalog backuppiece '/u01/app/oraarch/RMAN/bakup/<file_name>';
Then try the restore
|
|
|
|
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #268691 is a reply to message #268041] |
Wed, 19 September 2007 06:52 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
v$hydrabad
RMAN> catalog backuppiece '/u01/app/oraarch/RMAN/bakup/DB_back_190_1.back';
cataloged backuppiece
backup piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_190_1.back recid=2 stamp
=633711005
RMAN>
???????????
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #269433 is a reply to message #268041] |
Sat, 22 September 2007 04:44 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
thank you everybody for your help...
nandkumar,
i manage to restore but 1 thing,it seems that the temp files and redo.log's date was not changed...i think these are not updated...
SQL> desc dba_tables;
ERROR:
ORA-04043: object dba_tables does not exist
SQL> show user
USER is "SYS"
tanx again...
|
|
|
|
| Re: RMAN error in oracle 10g [message #269439 is a reply to message #269433] |
Sat, 22 September 2007 05:41 |
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
|
Member |
|
|
You have only restored the database......You need to perform the recovery...and then open the database.
You are not able to see the dba_tables view because the database is in mount state. You can check this from status column of the v$instance view.
By the way....did you read the document at the link posted by ebrian....That will give you a clear picture.
|
|
|
|
| Re: RMAN error in oracle 10g [message #270258 is a reply to message #269439] |
Wed, 26 September 2007 06:07 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
RMAN> restore database;
Starting restore at 26-SEP-07
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2189 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=2188 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=2187 devtype=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: sid=2186 devtype=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: sid=2193 devtype=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: sid=2194 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oradata/orcl/system01.dbf
restoring datafile 00006 to /u01/app/oradata/orcl/HUY_BLOB2.DBF
restoring datafile 00007 to /u01/app/oradata/orcl/HUY_DATA4.DBF
restoring datafile 00013 to /u01/app/oradata/orcl/HUY_DATA9.DBF
restoring datafile 00020 to /u01/app/oraindex/orcl/HUY_INDEX6.DBF
restoring datafile 00026 to /u01/app/oraindex/orcl/HUY_INDEX4.DBF
channel ORA_DISK_1: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_274_1.back
channel ORA_DISK_2: starting datafile backupset restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u01/app/oradata/orcl/HUY_BLOB1.DBF
restoring datafile 00008 to /u01/app/oradata/orcl/HUY_DATA8.DBF
restoring datafile 00014 to /u01/app/oradata/orcl/HUY_DATA10.DBF
restoring datafile 00017 to /u01/app/oradata/orcl/HUY_DEF1.DBF
restoring datafile 00021 to /u01/app/oraindex/orcl/HUY_INDEX5.DBF
restoring datafile 00027 to /u01/app/oraindex/orcl/HUY_INDEX9.DBF
channel ORA_DISK_2: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_275_1.back
channel ORA_DISK_3: starting datafile backupset restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/app/oradata/orcl/undotbs01.dbf
restoring datafile 00012 to /u01/app/oradata/orcl/HUY_DATA7.DBF
restoring datafile 00019 to /u01/app/oraindex/orcl/HUY_INDEX8.DBF
restoring datafile 00025 to /u01/app/oraindex/orcl/HUY_INDEX1.DBF
restoring datafile 00032 to /u01/app/oradata/orcl/HUY_PROPERTY4.DBF
restoring datafile 00036 to /u01/app/oradata/orcl/cwmlite
channel ORA_DISK_3: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_276_1.back
channel ORA_DISK_4: starting datafile backupset restore
channel ORA_DISK_4: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/app/oradata/orcl/sysaux01.dbf
restoring datafile 00009 to /u01/app/oradata/orcl/HUY_DATA6.DBF
restoring datafile 00015 to /u01/app/oradata/orcl/HUY_DATA1.DBF
restoring datafile 00022 to /u01/app/oraindex/orcl/HUY_INDEX3.DBF
restoring datafile 00028 to /u01/app/oradata/orcl/HUY_LOOKUP1.DBF
restoring datafile 00029 to /u01/app/oradata/orcl/HUY_PROPERTY3.DBF
channel ORA_DISK_4: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_277_1.back
channel ORA_DISK_5: starting datafile backupset restore
channel ORA_DISK_5: specifying datafile(s) to restore from backup set
restoring datafile 00004 to /u01/app/oradata/orcl/users01.dbf
restoring datafile 00010 to /u01/app/oradata/orcl/HUY_DATA3.DBF
restoring datafile 00016 to /u01/app/oradata/orcl/HUY_DATA2.DBF
restoring datafile 00023 to /u01/app/oraindex/orcl/HUY_INDEX7.DBF
restoring datafile 00030 to /u01/app/oradata/orcl/HUY_PROPERTY1.DBF
restoring datafile 00033 to /u01/app/oradata/orcl/HUY_TEST1.DBF
channel ORA_DISK_5: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_278_1.back
channel ORA_DISK_6: starting datafile backupset restore
channel ORA_DISK_6: specifying datafile(s) to restore from backup set
restoring datafile 00011 to /u01/app/oradata/orcl/HUY_DATA5.DBF
restoring datafile 00018 to /u01/app/oraindex/orcl/HUY_INDEX2.DBF
restoring datafile 00024 to /u01/app/oraindex/orcl/HUY_INDEX10.DBF
restoring datafile 00031 to /u01/app/oradata/orcl/HUY_PROPERTY2.DBF
restoring datafile 00034 to /u01/app/oraindex/orcl/INDX01.DBF
restoring datafile 00035 to /u01/app/oradata/orcl/DRSYS
channel ORA_DISK_6: reading from backup piece /u01/app/oraarch/RMAN/bakup/DB_bac
k_279_1.back
channel ORA_DISK_3: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_276_1.back tag=TAG20070925T2015
07
channel ORA_DISK_3: restore complete, elapsed time: 00:30:49
channel ORA_DISK_6: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_279_1.back tag=TAG20070925T2015
07
channel ORA_DISK_6: restore complete, elapsed time: 00:31:24
channel ORA_DISK_4: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_277_1.back tag=TAG20070925T2015
07
channel ORA_DISK_4: restore complete, elapsed time: 00:36:09
channel ORA_DISK_5: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_278_1.back tag=TAG20070925T2015
07
channel ORA_DISK_5: restore complete, elapsed time: 00:38:25
channel ORA_DISK_2: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_275_1.back tag=TAG20070925T2015
07
channel ORA_DISK_2: restore complete, elapsed time: 00:38:60
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/DB_back_274_1.back tag=TAG20070925T2015
07
channel ORA_DISK_1: restore complete, elapsed time: 00:41:45
Finished restore at 26-SEP-07
_____________******________________
RMAN> recover database;
Starting recover at 26-SEP-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
starting media recovery
channel ORA_DISK_2: starting archive log restore to default destination
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_2: restoring archive log
archive log thread=1 sequence=321
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=320
channel ORA_DISK_1: reading from backup piece /u01/app/oraarch/RMAN/bakup/db_ARC
H_281_1.back
channel ORA_DISK_2: restoring archive log
archive log thread=1 sequence=322
channel ORA_DISK_2: reading from backup piece /u01/app/oraarch/RMAN/bakup/db_ARC
H_284_1.back
channel ORA_DISK_2: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/db_ARCH_284_1.back tag=TAG20070925T2053
48
channel ORA_DISK_2: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/db_ARCH_281_1.back tag=TAG20070925T2053
48
channel ORA_DISK_1: restore complete, elapsed time: 00:01:36
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_320_631212901.dbf
thread=1 sequence=320
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_321_631212901.dbf
thread=1 sequence=321
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_322_631212901.dbf
thread=1 sequence=322
unable to find archive log
archive log thread=1 sequence=323
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/26/2007 13:57:58
RMAN-06054: media recovery requesting unknown log: thread 1 seq 323 lowscn 25663
1313
RMAN>
______________the location of arch__________
hisdbs07--> /u01/app/oracle/product/10.2.0/dbs/arch # ll
total 1449474
-rw-rw---- 1 oracle dba 106724352 Sep 23 10:48 1_293_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 23 10:48 1_294_631212901.dbf
-rw-rw---- 1 oracle dba 129343488 Sep 23 13:02 1_301_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 23 13:02 1_302_631212901.dbf
-rw-rw---- 1 oracle dba 248541184 Sep 24 14:46 1_305_631212901.dbf
-rw-rw---- 1 oracle dba 7154688 Sep 24 14:45 1_306_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 24 14:45 1_307_631212901.dbf
-rw-rw---- 1 oracle dba 248541184 Sep 26 13:57 1_320_631212901.dbf
-rw-rw---- 1 oracle dba 1756160 Sep 26 13:56 1_321_631212901.dbf
-rw-rw---- 1 oracle dba 5120 Sep 26 13:56 1_322_631212901.dbf
-rw-rw-r-- 1 root sys 11209 Sep 12 13:35 orcl_ora_19191.trc
yes i have reviewed it(the link)...tanx again...
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #271327 is a reply to message #270445] |
Mon, 01 October 2007 05:27 |
bong
Messages: 13
Registered: September 2007
|
Junior Member |
|
|
i think backup is there
[SIZE=1]-rw-rw-rw- 1 root sys 4646551552 Oct 1 11:29 DB_back_334_1.back
-rw-rw-rw- 1 root sys 4532944896 Oct 1 11:31 DB_back_335_1.back
-rw-rw-rw- 1 root sys 2689900544 Oct 1 11:32 DB_back_336_1.back
-rw-rw-rw- 1 root sys 4494614528 Oct 1 11:34 DB_back_337_1.back
-rw-rw-rw- 1 root sys 4376813568 Oct 1 11:36 DB_back_338_1.back
-rw-rw-rw- 1 root sys 2500894720 Oct 1 11:37 DB_back_339_1.back
-rw-rw-rw- 1 root sys 7176192 Oct 1 11:48 c-1157779562-20070930-
00
-rw-rw-rw- 1 root sys 7176192 Oct 1 11:48 c-1157779562-20070930-
01
-rw-rw-rw- 1 root sys 7127040 Oct 1 11:37 contol_file1.ctl
-rw-rw-rw- 1 root sys 7127040 Oct 1 11:37 contol_file2.ctl
-rw-rw-rw- 1 root sys 190882816 Oct 1 11:37 db_ARCH_341_1.back
-rw-rw-rw- 1 root sys 192046080 Oct 1 11:37 db_ARCH_342_1.back
-rw-rw-rw- 1 root sys 196502528 Oct 1 11:37 db_ARCH_343_1.back
-rw-rw-rw- 1 root sys 44576768 Oct 1 11:37 db_ARCH_344_1.back[/SIZE]
|
|
|
|
| Re: RMAN error in oracle 10g [message #271328 is a reply to message #271327] |
Mon, 01 October 2007 05:34 |
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
|
Member |
|
|
Bong, the error says:
RMAN-06054: media recovery requesting unknown log: thread 1 seq 323 lowscn 25663
make sure that you have that archive file having sequence no 323 in that location. If its not there, copy it from the source destination.
[Updated on: Mon, 01 October 2007 05:35] Report message to a moderator |
|
|
|
| Re: RMAN error in oracle 10g [message #271574 is a reply to message #271328] |
Tue, 02 October 2007 01:47 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
*****recovery*******
RMAN> recover database;
Starting recover at 01-OCT-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=352
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=353
channel ORA_DISK_1: reading from backup piece /u01/app/oraarch/RMAN/bakup/db_ARC
H_344_1.back
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/db_ARCH_344_1.back tag=TAG20070930T2053
50
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_352_631212901.dbf
thread=1 sequence=352
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_353_631212901.dbf
thread=1 sequence=353
unable to find archive log
archive log thread=1 sequence=354
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/01/2007 15:55:50
RMAN-06054: media recovery requesting unknown log: thread 1 seq 354 lowscn 25918
2270
RMAN>
*********backup contents**************
total 46686768
-rw-r----- 1 oracle dba 4646674432 Oct 1 20:54 DB_back_346_1.back
-rw-r----- 1 oracle dba 4541857792 Oct 1 20:52 DB_back_347_1.back
-rw-r----- 1 oracle dba 2689392640 Oct 1 20:40 DB_back_348_1.back
-rw-r----- 1 oracle dba 4494835712 Oct 1 20:51 DB_back_349_1.back
-rw-r----- 1 oracle dba 4378697728 Oct 1 20:50 DB_back_350_1.back
-rw-r----- 1 oracle dba 2506162176 Oct 1 20:39 DB_back_351_1.back
-rw-r----- 1 oracle dba 7176192 Oct 1 20:54 c-1157779562-20071001-
00
-rw-r----- 1 oracle dba 7176192 Oct 1 20:55 c-1157779562-20071001-
01
-rw-r----- 1 oracle dba 7127040 Oct 1 20:54 contol_file1.ctl
-rw-r----- 1 oracle dba 7127040 Oct 1 20:55 contol_file2.ctl
-rw-r----- 1 oracle dba 192151552 Oct 1 20:55 db_ARCH_353_1.back
-rw-r----- 1 oracle dba 195959808 Oct 1 20:55 db_ARCH_354_1.back
-rw-r----- 1 oracle dba 191335424 Oct 1 20:55 db_ARCH_355_1.back
-rw-r----- 1 oracle dba 37730304 Oct 1 20:54 db_ARCH_356_1.back
*******Arch location*******
hisdbs07--> /u01/app/oracle/product/10.2.0/dbs/arch # ll
total 1666538
-rw-rw---- 1 oracle dba 106724352 Sep 23 10:48 1_293_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 23 10:48 1_294_631212901.dbf
-rw-rw---- 1 oracle dba 129343488 Sep 23 13:02 1_301_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 23 13:02 1_302_631212901.dbf
-rw-rw---- 1 oracle dba 248541184 Sep 24 14:46 1_305_631212901.dbf
-rw-rw---- 1 oracle dba 7154688 Sep 24 14:45 1_306_631212901.dbf
-rw-rw---- 1 oracle dba 4096 Sep 24 14:45 1_307_631212901.dbf
-rw-rw---- 1 oracle dba 248541184 Sep 26 13:57 1_320_631212901.dbf
-rw-rw---- 1 oracle dba 1756160 Sep 26 13:56 1_321_631212901.dbf
-rw-rw---- 1 oracle dba 5120 Sep 26 13:56 1_322_631212901.dbf
-rw-rw---- 1 oracle dba 111086592 Oct 1 15:55 1_352_631212901.dbf
-rw-rw---- 1 oracle dba 50176 Oct 1 15:55 1_353_631212901.dbf
-rw-rw-r-- 1 root sys 11209 Sep 12 13:35 orcl_ora_19191.trc
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #271627 is a reply to message #271593] |
Tue, 02 October 2007 04:33 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
the message....
RMAN> recover database;
Starting recover at 02-OCT-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=360
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=361
channel ORA_DISK_1: reading from backup piece /u01/app/oraarch/RMAN/bakup/db_ARC
H_356_1.back
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oraarch/RMAN/bakup/db_ARCH_356_1.back tag=TAG20071001T2054
19
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_360_631212901.dbf
thread=1 sequence=360
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_361_631212901.dbf
thread=1 sequence=361
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_362_631212901.dbf
thread=1 sequence=362
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_363_631212901.dbf
thread=1 sequence=363
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_364_631212901.dbf
thread=1 sequence=364
archive log filename=/u01/app/oracle/product/10.2.0/dbs/arch/1_364_631212901.dbf
thread=1 sequence=365
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/02/2007 12:25:21
RMAN-11003: failure during parse/execution of SQL statement: alter database reco
ver logfile '/u01/app/oracle/product/10.2.0/dbs/arch/1_364_631212901.dbf'
ORA-00310: archived log contains sequence 364; sequence 365 required
ORA-00334: archived log: '/u01/app/oracle/product/10.2.0/dbs/arch/1_364_63121290
1.dbf'
RMAN>
destination archive dir contents...
total 1640714
-rw-rw---- 1 oracle dba 93710336 Oct 2 12:23 1_360_631212901.dbf
-rw-rw---- 1 oracle dba 129024 Oct 2 12:22 1_361_631212901.dbf
-rw-rw-rw- 1 root sys 248541184 Oct 2 11:06 1_362_631212901.dbf
-rw-rw-rw- 1 root sys 248541184 Oct 2 11:06 1_363_631212901.dbf
-rw-rw-rw- 1 root sys 249098240 Oct 2 11:07 1_364_631212901.dbf
drwxrwxrwx 2 root sys 1024 Oct 2 11:04 bak
source archive dir contents..
total 1457432
-rw-rw---- 1 oracle dba 248541184 Oct 2 00:52 1_362_631212901.dbf
-rw-rw---- 1 oracle dba 248541184 Oct 2 06:25 1_363_631212901.dbf
-rw-rw---- 1 oracle dba 249098240 Oct 2 11:00 1_364_631212901.dbf
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #271658 is a reply to message #268041] |
Tue, 02 October 2007 06:49 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
THANK YOU EVERYBODY....
at last i've found the problem....
i should have determined this at first but anyhow im just a beginner from this environment...
theres a lot to be learn...and i admit that...
life would not be better without you guys (ORACLE GURO's)
thank you Nandkhumar for not giving up on me...
thank you ebrian for the link
thank you dreamz for the inspiring caricature...
i love this forum....
i love you guys....
til next....
|
|
|
|
|
|
| Re: RMAN error in oracle 10g [message #272789 is a reply to message #271686] |
Sun, 07 October 2007 06:46 |
gunsbong
Messages: 44
Registered: May 2007
|
Member |
|
|
ebrian
RMAN> recover database until sequence=? thread=?;
that's it...
but,......
ok i manage to solve this one,but when i did the same routine the day after...i did not get the same result...
RMAN> recover database;
Starting recover at 07-OCT-07
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
using channel ORA_DISK_6
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 10/07/2007 14:39:48
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database reco
ver if needed
start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not readabl
e
ORA-00600: internal error code, arguments: [kcvsor_current_inc_rdfail], [0], [],
[], [], [], [], []
and again...until today...
i have done something like using the old incarnation...still it cannot recover the database....
restore is successful..only recovery....
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
..now I should have known DreamzZ could find one !!