Home » RDBMS Server » Backup & Recovery » RMAN error in oracle 10g
RMAN error in oracle 10g [message #268041] Mon, 17 September 2007 05:20 Go to next message
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 #268044 is a reply to message #268041] Mon, 17 September 2007 05:35 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Have you performed a resetlogs operation after the backup you are trying to restore was taken? What does the following show:

RMAN> list incarnation;
Re: RMAN error in oracle 10g [message #268054 is a reply to message #268044] Mon, 17 September 2007 06:14 Go to previous messageGo to next message
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 #268072 is a reply to message #268054] Mon, 17 September 2007 07:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
When you same the server has the same configuration, are you referring to the exact directory structure? Do you receive appropriate output with:

RMAN> list backup;

You may also want to review Restore and Recovery of the Database on a New Host.
Re: RMAN error in oracle 10g [message #268189 is a reply to message #268041] Mon, 17 September 2007 22:33 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
just copied the backup file from production UNIX server to another UNIX server.

You wanted to take restore in another database which was backed up in one database?
Re: RMAN error in oracle 10g [message #268396 is a reply to message #268189] Tue, 18 September 2007 07:40 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Try this

RMAN> catalog backuppiece '<name and path of backup>' ;


then do the restore
Re: RMAN error in oracle 10g [message #268569 is a reply to message #268041] Wed, 19 September 2007 02:09 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
Nandkumar
RMAN> catalog backuppiece '/u01/app/oraarch/RMAN/bakup';

using target database control file instead of recovery catalog
ORA-19870: error reading backup piece /u01/app/oraarch/RMAN/bakup
ORA-19505: failed to identify file "/u01/app/oraarch/RMAN/bakup"
ORA-27037: unable to obtain file status
Additional information: 5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 09/19/2007 10:01:06
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece /u01/app/oraarch/RMAN/bakup

RMAN>

Arju
yes sir...if posible

ebrian


RMAN> list backup;


RMAN>


both have uniform directories and configuration

tanx Embarassed
Re: RMAN error in oracle 10g [message #268584 is a reply to message #268041] Wed, 19 September 2007 02:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

This is not possible without setting DBID. Have you ever set DBID of new database with the DBID of your production one?

How you have taken backup?

[Updated on: Wed, 19 September 2007 02:36]

Report message to a moderator

Re: RMAN error in oracle 10g [message #268590 is a reply to message #268041] Wed, 19 September 2007 02:30 Go to previous messageGo to next message
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 #268593 is a reply to message #268041] Wed, 19 September 2007 02:33 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
DBID in production and the target server are the same
Re: RMAN error in oracle 10g [message #268604 is a reply to message #268041] Wed, 19 September 2007 02:50 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Cool!, Start from first. Tell me what you have done in your new(test) database?
Re: RMAN error in oracle 10g [message #268608 is a reply to message #268041] Wed, 19 September 2007 02:53 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
nothing much.....just copied the backup file from the production then attempting to restore it using rman...
Re: RMAN error in oracle 10g [message #268610 is a reply to message #268593] Wed, 19 September 2007 02:55 Go to previous messageGo to next message
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 #268612 is a reply to message #268041] Wed, 19 September 2007 02:57 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Then how you said you have setted both database DBID is same?
Do you know what is DBID? It can be found by querying?

Select dbid from v$database;
Re: RMAN error in oracle 10g [message #268649 is a reply to message #268569] Wed, 19 September 2007 04:51 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
If your directory structure is IDENTICAL then you don't have to concern yourself with cataloging any backup pieces. You should ensure that the appropriate permissions are set on the directory where you are copying the backup files on the new server.

Following the example in Restore and Recovery of the Database on a New Host should walk you completely thru the process.

If you are concerned about the DBID of the new database, then you can use Creating a Duplicate Database with RMAN as another method.

However, the first method gives you the opportunity to run thru the process of truly documenting, exercising and validating your backups and B&R procedures.

[Updated on: Wed, 19 September 2007 05:21]

Report message to a moderator

Re: RMAN error in oracle 10g [message #268664 is a reply to message #268041] Wed, 19 September 2007 05:31 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
arju

dbid is positively uniform...even without using select command...i could easily identify it...
Re: RMAN error in oracle 10g [message #268691 is a reply to message #268041] Wed, 19 September 2007 06:52 Go to previous messageGo to next message
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 #268698 is a reply to message #268691] Wed, 19 September 2007 07:14 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is wrong with simply reading the docs?

As anacedent would say, "You can lead some folks to knowledge, but you can not make them think."
Re: RMAN error in oracle 10g [message #268708 is a reply to message #268691] Wed, 19 September 2007 07:46 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Now do the restore using the command

RMAN> restore database;

[Updated on: Wed, 19 September 2007 07:46]

Report message to a moderator

Re: RMAN error in oracle 10g [message #268737 is a reply to message #268698] Wed, 19 September 2007 09:19 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
ebrian wrote on Wed, 19 September 2007 06:14
What is wrong with simply reading the docs?

As anacedent would say, "You can lead some folks to knowledge, but you can not make them think."



Being Lazy I guess !!! Cool
Re: RMAN error in oracle 10g [message #268755 is a reply to message #268737] Wed, 19 September 2007 10:45 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
DreamzZ wrote on Wed, 19 September 2007 10:19

Being Lazy I guess !!! Cool


I guess...time to break out the spoon !!

That's what we need, a message icon for spoon feeding.
Re: RMAN error in oracle 10g [message #268758 is a reply to message #268755] Wed, 19 September 2007 10:57 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
./fa/3087/0/
  • Attachment: spoon.jpg
    (Size: 32.32KB, Downloaded 3562 times)
Re: RMAN error in oracle 10g [message #268796 is a reply to message #268758] Wed, 19 September 2007 14:13 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Laughing ..now I should have known DreamzZ could find one !!
Re: RMAN error in oracle 10g [message #268840 is a reply to message #268041] Wed, 19 September 2007 22:06 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Nice demonstration by Dream.
Re: RMAN error in oracle 10g [message #269433 is a reply to message #268041] Sat, 22 September 2007 04:44 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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_DIS
K_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 #270445 is a reply to message #268041] Wed, 26 September 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
unable to find archive log


Ensure that you have catalog the archive log if the log is available.

If archive log is not available then perform point in time recovery and open resetlogs.
Re: RMAN error in oracle 10g [message #271327 is a reply to message #270445] Mon, 01 October 2007 05:27 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #271593 is a reply to message #268041] Tue, 02 October 2007 02:27 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
unable to find archive log
Re: RMAN error in oracle 10g [message #271627 is a reply to message #271593] Tue, 02 October 2007 04:33 Go to previous messageGo to next message
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 #271636 is a reply to message #271627] Tue, 02 October 2007 04:53 Go to previous messageGo to next message
gunsbong
Messages: 44
Registered: May 2007
Member
ORA-00310: archived log contains sequence 364; sequence 365 required

why is it requiring 365? its clear that the source don't have this file....

Re: RMAN error in oracle 10g [message #271658 is a reply to message #268041] Tue, 02 October 2007 06:49 Go to previous messageGo to next message
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 #271686 is a reply to message #271658] Tue, 02 October 2007 08:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
gunsbong wrote on Tue, 02 October 2007 07:49

at last i've found the problem....


And the problem was ??
Re: RMAN error in oracle 10g [message #272789 is a reply to message #271686] Sun, 07 October 2007 06:46 Go to previous messageGo to next message
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....

Re: RMAN error in oracle 10g [message #272828 is a reply to message #268041] Sun, 07 October 2007 23:17 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORA-00600:=> oracle bug=> contact metalink or call oracle support.
Previous Topic: timestamp in RMAN backup logs
Next Topic: RMAN - shutdown clone hanging
Goto Forum:
  


Current Time: Sun Dec 04 17:04:55 CST 2016

Total time taken to generate the page: 0.20924 seconds