OraFAQ Forum: Server Utilities » SCN/data doesn't update after the restore

Home » RDBMS Server » Server Utilities » SCN/data doesn't update after the restore (Oracle, 10.2.0.4.0, Windows Server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SCN/data doesn't update after the restore [message #398170]

Wed, 15 April 2009 08:31

shekharnegi12
Messages: 52
Registered: October 2008

Member

Hello,

I came across a issue where whenever I perform a restore it restores the same data again and again. To confirm I run

select current_scn from v$database

and its never up to date? I tried copying the control file over from the production DB (source) over to test1 (destination)and re tried the restore but no luck. To make sure that the data in the backupset is correct I restored it on the different DB say test2 and the DB has the correct data.

The RMAN configuration is exactly the same on test1 and test2. The only difference between these 2 is that test uses init.ora file during startup and test2 uses spfile, but the parameters and the values are exactly the same.

Any ideas.

Thanks,
SN

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398203 is a reply to message #398170]

Wed, 15 April 2009 12:19

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Exactly what's your problem???

Babu

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398211 is a reply to message #398203]

Wed, 15 April 2009 12:53

shekharnegi12
Messages: 52
Registered: October 2008

Member

Babu,

When I perform a restore, it runs fine but the data eventually that its dumping is not up to date. I want to know what might be the reason that its not restoring/recovering the DB with current data. Please let me know if you need some more explanation.

Thanks,
SN

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398212 is a reply to message #398211]

Wed, 15 April 2009 12:59

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>I tried copying the control file over from the production DB (source) over to test1 (destination)and re tried the restore but no luck

Post your backup script with logfile.

Post your restore/recover step with your logfile.

>> data eventually that its dumping is not up to date

Proff ??

Babu

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398224 is a reply to message #398212]

Wed, 15 April 2009 13:19

shekharnegi12
Messages: 52
Registered: October 2008

Member

Here's the backup:


 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=172.27.2.105,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={D09A7B8F-583A-49F4-A1DC-15A36973010B},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\FL-CPBACK\Prod';
 BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     DATABASE FORCE PLUS ARCHIVELOG FORCE NOT BACKED UP;
 
 RELEASE CHANNEL ch0;
 }
 
connected to target database: Prod (DBID=803771630)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=187 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0


Starting backup at 15-APR-09
current log archived
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_01\O1_76J_.ARC; already backed on 15-APR-09
.
.
.
.
.
.
skipping archive log file E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_15\O1_MF_GO8_.ARC; already backed on 15-APR-09
channel ch0: starting archive log backupset
channel ch0: specifying archive log(s) in backup set
input archive log thread=1 sequence=420 recid=14884 stamp=684248423
channel ch0: starting piece 1 at 15-APR-09
channel ch0: finished piece 1 at 15-APR-09
piece handle=BE_brkchjbd_1_1 tag=TAG20090415T130024 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:00:26
Finished backup at 15-APR-09

Starting backup at 15-APR-09
channel ch0: starting incremental level 0 datafile backupset
channel ch0: specifying datafile(s) in backupset
input datafile fno=00002 name=D:\ORACLE\ORADATA\Prod\UNDOTBS01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\Prod\USERS01.DBF
input datafile fno=00011 name=D:\ORACLE\ORADATA\Prod\pd1db_D01.DBF
input datafile fno=00012 name=D:\ORACLE\ORADATA\Prod\pd1db_D02.DBF
input datafile fno=00013 name=D:\ORACLE\ORADATA\Prod\pd1db_D03.DBF
input datafile fno=00014 name=D:\ORACLE\ORADATA\Prod\pd1db_D04.DBF
input datafile fno=00015 name=D:\ORACLE\ORADATA\Prod\pd1db_D05.DBF
input datafile fno=00016 name=D:\ORACLE\ORADATA\Prod\pd1db_D06.DBF
input datafile fno=00017 name=D:\ORACLE\ORADATA\Prod\pd1db_D07.DBF
input datafile fno=00018 name=D:\ORACLE\ORADATA\Prod\pd1db_D08.DBF
.
.
.
.
.
.
input datafile fno=00033 name=D:\ORACLE\ORADATA\Prod\pd1db_I06.DBF
input datafile fno=00037 name=D:\ORACLE\ORADATA\Prod\pd1db_I07.DBF
input datafile fno=00001 name=D:\ORACLE\ORADATA\Prod\SYSTEM01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\Prod\SYSAUX01.DBF
input datafile fno=00030 name=D:\ORACLE\ORADATA\Prod\TE_MASTER01.DBF
input datafile fno=00010 name=D:\ORACLE\ORADATA\Prod\XDB01.DBF
input datafile fno=00008 name=D:\ORACLE\ORADATA\Prod\TOOLS01.DBF
channel ch0: starting piece 1 at 15-APR-09
channel ch0: finished piece 1 at 15-APR-09
piece handle=BE_bskchjc8_1_1 tag=TAG20090415T130056 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:36:26
Finished backup at 15-APR-09

Starting backup at 15-APR-09
current log archived
channel ch0: starting archive log backupset
channel ch0: specifying archive log(s) in backup set
input archive log thread=1 sequence=421 recid=14885 stamp=684250647
channel ch0: starting piece 1 at 15-APR-09
channel ch0: finished piece 1 at 15-APR-09
piece handle=BE_btkchlgo_1_1 tag=TAG20090415T133727 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:00:08
Finished backup at 15-APR-09

Starting Control File and SPFILE Autobackup at 15-APR-09
piece handle=c-803771630-20090415-02 comment=API Version 2.0,MMS Version 1.1.0.0
Finished Control File and SPFILE Autobackup at 15-APR-09
released channel: ch0
Recovery Manager complete.

Here's the restore:

RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=172.27.2.105,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={16037E05-53AE-41A4-AF86-C1A3DD5EBCEF},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\FL-CP\Prod,NBBSA_SOURCE_MACHINE_NAME=FL-CPBACK';
 
 RESTORE CONTROLFILE FROM 'c-803771630-20090415-01';
 
 ALTER DATABASE MOUNT;
 
 RESTORE
     DATABASE;
 
 RECOVER
     DATABASE;
 
 RELEASE CHANNEL ch0;
 alter database open resetlogs;
 }
 
connected to target database: Prod (not mounted)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=482 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 15-APR-09

channel ch0: restoring control file
channel ch0: restore complete, elapsed time: 00:00:03
output filename=C:\ORACLE\ORADATA\Prod\SNCFProd.ORA
Finished restore at 15-APR-09

database mounted

Starting restore at 15-APR-09
Starting implicit crosscheck backup at 15-APR-09
Crosschecked 8 objects
Finished implicit crosscheck backup at 15-APR-09

Starting implicit crosscheck copy at 15-APR-09
Finished implicit crosscheck copy at 15-APR-09

searching for all files in the recovery area
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_02\O1_MF_1_1_4X9DOPRO_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_02\O1_MF_1_1_4X9W271K_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_02\O1_MF_1_2_4X9W27BT_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_08\O1_MF_1_8_4XQMJ6M4_.ARC
.
.
.
.
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_13\O1_MF_1_5_4Y74LMMB_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_13\O1_MF_1_6_4Y755K7H_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_13\O1_MF_1_7_4Y75KTVG_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_13\O1_MF_1_8_4Y75VRPZ_.ARC
File Name: E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_13\O1_MF_1_9_4Y76FSG2_.ARC


channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\Prod\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\ORADATA\Prod\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\Prod\pd1db_I08.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\Prod\SYSAUX01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\Prod\pd1db_I09.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\Prod\USERS01.DBF
restoring datafile 00008 to D:\ORACLE\ORADATA\Prod\TOOLS01.DBF
restoring datafile 00010 to D:\ORACLE\ORADATA\Prod\XDB01.DBF
restoring datafile 00011 to D:\ORACLE\ORADATA\Prod\pd1db_D01.DBF
restoring datafile 00012 to D:\ORACLE\ORADATA\Prod\pd1db_D02.DBF
restoring datafile 00013 to D:\ORACLE\ORADATA\Prod\pd1db_D03.DBF
.
.
.
.
.
restoring datafile 00038 to D:\ORACLE\ORADATA\Prod\pd1db_D17.DBF
restoring datafile 00039 to D:\ORACLE\ORADATA\Prod\pd1db_D18.DBF
restoring datafile 00040 to D:\ORACLE\ORADATA\Prod\pd1db_D19.DBF
restoring datafile 00041 to D:\ORACLE\ORADATA\Prod\pd1db_D20.DBF
channel ch0: reading from backup piece BE_59kbe322_1_1
channel ch0: restored backup piece 1
piece handle=BE_59kbe322_1_1 tag=TAG20090402T014746
channel ch0: restore complete, elapsed time: 00:45:45
Finished restore at 15-APR-09

Starting recover at 15-APR-09

starting media recovery

archive log thread 1 sequence 315 is already on disk as file E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_09\O1_MF_1_315_4XW77MVW_.ARC
archive log thread 1 sequence 8 is already on disk as file E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_08\O1_MF_1_8_4XQMJ6M4_.ARC
archive log filename=E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_09\O1_MF_1_315_4XW77MVW_.ARC thread=1 sequence=315
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/15/2009 13:02:33
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'E:\ORACLE\FLASH_RECOVERY_AREA\Prod\ARCHIVELOG\2009_04_09\O1_MF_1_315_4XW77MVW_.ARC'
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [krhpfh_03-1209], [1], [683117203], [679699656], [459524607], [0], [0], [0]
ORA-01110: data file 1: 'D:\ORACLE\ORADATA\Prod\SYSTEM01.DBF'

Recovery Manager complete.

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398227 is a reply to message #398224]

Wed, 15 April 2009 13:22

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>ORA-00600: internal error code, arguments: [krhpfh_03-1209], [1], [683117203], [679699656], [459524607], [0], [0], [0]

Refer : Metalink Doc ID: 5701695.8

Babu

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398228 is a reply to message #398224]

Wed, 15 April 2009 13:23

shekharnegi12
Messages: 52
Registered: October 2008

Member

Proff ??

Test> select current_scn from v$database;

CURRENT_SCN
-----------
  460109262

Production> select current_scn from v$database;

CURRENT_SCN
-----------
  476816224

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398229 is a reply to message #398228]

Wed, 15 April 2009 13:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>>>ORA-00600: internal error code, arguments: [krhpfh_03-1209], [1], [683117203], [679699656], [459524607], [0], [0], [0]

Refer : Metalink Doc ID: 5701695.8

Recover NOT completed. Becuase of internal error. Check the above metalink note.

Babu

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398239 is a reply to message #398229]

Wed, 15 April 2009 13:45

shekharnegi12
Messages: 52
Registered: October 2008

Member

Woo.. that was fast. Thanks for your quick response! I totally agree that its a bug associated with 10.2.0.4. However if you check my first post in this thread I had mentioned about test2 DB and that I'd performed the restore to test2 DB successfully. Test2 DB is on ver 10.2.0.4 as well. Any suggestions....

Thanks,
SN

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398240 is a reply to message #398239]

Wed, 15 April 2009 13:48

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>that I'd performed the restore to test2 DB successfully. Test2 DB is on ver 10.2.0.4 as well. Any suggestions.

Can you post your successfull restore logfile.

Babu

Report message to a moderator

Re: SCN/data doesn't update after the restore [message #398252 is a reply to message #398240]

Wed, 15 April 2009 14:18

shekharnegi12
Messages: 52
Registered: October 2008

Member

 Connected.
 ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
 ORACLE instance started.

Total System Global Area 1795162112 bytes
Fixed Size    1299844 bytes
Variable Size  838863484 bytes
Database Buffers  947912704 bytes
Redo Buffers    7086080 bytes
 Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Recovery Manager: Release 10.2.0.4.0 - Production on Fri Apr 10 17:06:09 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 
 # -----------------------------------------------------------------
 # RMAN command section
 # -----------------------------------------------------------------
 
 RUN {
 ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
 SEND 'BSA_SERVICE_HOST=172.27.2.105,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={78A9BCCB-1F3C-4F27-9AAF-B4ADB8E85A4D},NBBSA_DB_DEVICE_NAME=Oracle-Win::\\FL-CPTEST10\test2,NBBSA_SOURCE_MACHINE_NAME=FL-CPBACK';

 RESTORE CONTROLFILE FROM 'c-803771630-20090410-04';

 ALTER DATABASE MOUNT;
 
 RESTORE
     DATABASE;
 
 RECOVER
     DATABASE;
 
 RELEASE CHANNEL ch0;
 alter database open resetlogs;
 }
 
connected to target database: test2 (not mounted)

using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=486 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0

sent command to channel: ch0

Starting restore at 10-APR-09

channel ch0: restoring control file
channel ch0: restore complete, elapsed time: 00:00:27
output filename=D:\ORACLE\ORADATA\test2\CONTROL01.CTL
output filename=D:\ORACLE\ORADATA\test2\CONTROL02.CTL
output filename=D:\ORACLE\ORADATA\test2\CONTROL03.CTL
Finished restore at 10-APR-09

database mounted

Starting restore at 10-APR-09

channel ch0: starting datafile backupset restore
channel ch0: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORADATA\test2\SYSTEM01.DBF
restoring datafile 00002 to D:\ORACLE\ORADATA\test2\UNDOTBS01.DBF
restoring datafile 00003 to D:\ORACLE\ORADATA\test2\tsdb1_I08.DBF
restoring datafile 00004 to D:\ORACLE\ORADATA\test2\SYSAUX01.DBF
restoring datafile 00005 to D:\ORACLE\ORADATA\test2\tsdb1_I09.DBF
restoring datafile 00006 to D:\ORACLE\ORADATA\test2\USERS01.DBF
.
.
.
restoring datafile 00037 to D:\ORACLE\ORADATA\test2\tsdb1_I07.DBF
restoring datafile 00038 to D:\ORACLE\ORADATA\test2\tsdb1_D17.DBF
restoring datafile 00039 to D:\ORACLE\ORADATA\test2\tsdb1_D18.DBF
restoring datafile 00040 to D:\ORACLE\ORADATA\test2\tsdb1_D19.DBF
restoring datafile 00041 to D:\ORACLE\ORADATA\test2\tsdb1_D20.DBF
channel ch0: reading from backup piece BE_9okc4o1s_1_1
channel ch0: restored backup piece 1
piece handle=BE_9okc4o1s_1_1 tag=TAG20090410T160059
channel ch0: restore complete, elapsed time: 01:30:05
Finished restore at 10-APR-09

Starting recover at 10-APR-09

starting media recovery

channel ch0: starting archive log restore to default destination
channel ch0: restoring archive log
archive log thread=1 sequence=391
channel ch0: reading from backup piece BE_9pkc4rar_1_1
channel ch0: restored backup piece 1
piece handle=BE_9pkc4rar_1_1 tag=TAG20090410T165659
channel ch0: restore complete, elapsed time: 00:00:16
archive log filename=E:\ORACLE\FLASH_RECOVERY_AREA\1_391_679699656.ARC thread=1 sequence=391
unable to find archive log
archive log thread=1 sequence=392
released channel: ch0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/10/2009 18:37:43
RMAN-06054: media recovery requesting unknown log: thread 1 seq 392 lowscn 472016237

Recovery Manager complete.

Although the recovery fails but still DB opens after

alter database open resetlogs

. in this one I've realized that it doesn't do cataloging and uses control file instead. Can I tweak the restore to test1 the similar way?

Thanks,
SN

Report message to a moderator