ajaybelde
asked on
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/sy stem.382.7 64328493'
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_7404 61103.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.
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/sy
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_
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.
Are you sure the archival of the file with sequence 25224 is complete?
ASKER
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..?
i didn;t understand what exactly ur asking,
are you asking production or physical standby..?
On Production.
ASKER
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.
what is the output of the command archive log list on the Production please?
ASKER
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
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
ASKER
can anyone help me very urgently..?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for Your help reliabledba, and the solution i got it from oracle support it worked.