[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 871
  • Last Modified:

I am getting error when i am creating a standby for production

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '+DATA/solfho2/datafile/system.382.764328493'


RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 10/12/2011 13:04:06

RMAN-03015: error occurred in stored script Memory Script

RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/arch/SOLFHO2/PROLHO01_1_25224_740461103.arc'

ORA-16145: archival for thread# 1 sequence# 25224 in progress


i used following command to duplicate the database from production

duplicate target database to standby dorecover;




can anyone please help me how to resolve the issue.
0
ajaybelde
Asked:
ajaybelde
  • 6
  • 5
2 Solutions
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Are you sure the archival of the file with sequence 25224 is complete?
0
 
ajaybeldeAuthor Commented:
Are you sure the archival of the file with sequence 25224 is complete?

i didn;t understand what exactly ur asking,

are you asking production or physical standby..?
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
On Production.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ajaybeldeAuthor Commented:
in production i have seen the archived log file. in the archived log destination, becuase it worked yesterday for another database since i am creating two standbys, first one is working but when i am doing for second standbys i got above error.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
what is the output of the command archive log list on the Production please?
0
 
ajaybeldeAuthor Commented:
SYS@PROLHO01> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     25442
Next log sequence to archive   25445
Current log sequence           25445
0
 
ajaybeldeAuthor Commented:
can anyone help me very urgently..?
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
is the size of this file same on Primary and the new standby you are trying to build?
Can you please do a cksum for the file on Primary and Standby?
reship the file, if the cksum is not same.
that should take you further.
0
 
ajaybeldeAuthor Commented:
i used this command in standby side

alter database recover managed standby database disconnect from session

after issuing this command everything is working..

it tried to sink to production

i also tried running refresh scripts
it is working now..


thanks guys for your quick response...
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
ok. nice.
0
 
ajaybeldeAuthor Commented:
Thanks for Your help reliabledba, and the solution i got it from oracle support it worked.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now