1753772 Members
5121 Online
108799 Solutions
New Discussion юеВ

Re: database recover

 
shabir_1
Occasional Advisor

database recover

Hi,
We have restored backup on test server nd opened database with resetlogs
We have shiped log from prod databse and
catalog in test database. like
List of Archived Logs in backup set 316
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 666 10998716 06-APR-10 10998732 06-APR-10
1 667 10998732 06-APR-10 11025847 06-APR-10
1 668 11025847 06-APR-10 11030976 06-APR-10
1 669 11030976 06-APR-10 11030995 06-APR-10
1 670 11030995 06-APR-10 11036346 06-APR-10
1 671 11036346 06-APR-10 11040589 06-APR-10
1 672 11040589 06-APR-10 11045257 06-APR-10
1 673 11045257 06-APR-10 11079846 06-APR-10

while try to apply all these archivelogs to test database we face issue like
RMAN> run
2> {
3> set archivelog destination to 'archivelog/archive';
4> restore archivelog from sequence 666;
5> }
RMAN-20242: specification does not match any archive log in the recovery catalog

Any input to resolve this issue

Thanks
(Shabir)

2 REPLIES 2
Michal Kapalka (mikap)
Honored Contributor

Re: database recover

hi,

check the error message : RMAN-20242

http://www.error-code.org.uk/view.asp?e=ORACLE-RMAN-20242

some advices :

http://forums.oracle.com/forums/thread.jspa?threadID=617188

hope it will help you.

mikap

shabir_1
Occasional Advisor

Re: database recover

Hi mikap.
it didn't work

Thanks
(Shabir)