Refresh Issues

Hi,

i am trying to perform refresh for the database, i am getting issues with

10/05/11 10:20:02: Last Restore point is PS_AFTER_EOD_20111004_0405
Last Log at Primary is 25059279739
10/05/11 10:20:02: About to restore database to last flash point and start recover

STARTUP MOUNT FORCE;

FLASHBACK DATABASE TO RESTORE POINT
PS_AFTER_EOD_20111004_0405;

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

STARTUP MOUNT FORCE;

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

ORACLE instance started.

Total System Global Area 1996488704 bytes
Fixed Size                2085032 bytes
Variable Size              285216600 bytes
Database Buffers       1694498816 bytes
Redo Buffers               14688256 bytes
Database mounted.
FLASHBACK DATABASE TO RESTORE POINT
*
ERROR at line 1:
ORA-38753: Cannot flashback data file 16; no flashback log data.
ORA-01110: data file 16: '+DATA/psolho01/datafile/bg_endur_clean.275.763414029'
ORA-38753: Cannot flashback data file 15; no flashback log data.
ORA-01110: data file 15: '+DATA/psolho01/datafile/bg_endur_clean.267.763403495'
ORA-38753: Cannot flashback data file 14; no flashback log data.
ORA-01110: data file 14: '+DATA/psolho01/datafile/undotbs1.263.763398409'
ORA-38753: Cannot flashback data file 13; no flashback log data.
ORA-01110: data file 13: '+DATA/psolho01/datafile/bg_endur_clean.271.763408663'
ORA-38753: Cannot flashback data file 12; no flashback log data.
ORA-01110: data file 12: '+DATA/psolho01/datafile/bg_endur_clean.259.763394451'
ORA-38753: Cannot flashback data file 11; no flashback log data.
ORA-01110: data file 11: '+DATA/psolho01/datafile/bg_endur_clean.285.763432437'
ORA-38753: Cannot flashback data file 10; no flashback log data.
ORA-01110: data file 10: '+DATA/psolho01/datafile/bg_endur_clean.278.763419935'
ORA-38753: Can


Error while synching the database with primary

ajaybeldeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
Are the recent archived redo logs from the primary database available to the standby databse server?
0
ajaybeldeAuthor Commented:
yes.
0
ajaybeldeAuthor Commented:
i am unable to create guarantee resore point
below is the error..

SQL> create restore point G_PS_20111004_05 guarantee flashback database;
create restore point G_PS_20111004_05 guarantee flashback database
*
ERROR at line 1:
ORA-38784: Cannot create restore point 'G_PS_20111004_05'.
ORA-38788: More standby database recovery is needed
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mark GeerlingsDatabase AdministratorCommented:
That makes it look like the main problem is:

ORA-38788: More standby database recovery is needed

We have to do a lot of guessing.  We don't know what happened in your standby database prior to this.  Was it working as expected for some time?  If yes, did someone intentionally stop applying the archived redo logs there?  If yes, when, why, how?

How are the archived redo log files normally transferred from your primary to the standby?
0
ajaybeldeAuthor Commented:
the archived redo logs are generate as expected, but it has been stoped yesterday for some time and then started archiveing again, so what i have to do now can anyone help me i am unable to figure it out from morning please.
0
johnsoneSenior Oracle DBACommented:
If the standby was down for some time, then it is possible that some archive logs need to be manually registered with the standby.

The documentation on how to determine which files are missing and how to register them is here:

http://download.oracle.com/docs/cd/E11882_01/server.112/e22491/log_transport.htm#BABIDDDC

0
ajaybeldeAuthor Commented:
when i rebuilding the database it is taking lvl0 backups and it is not taking lvl1 and arch backups. so can any one tell me the command how to do it.
0
ajaybeldeAuthor Commented:
i used the


duplicate target database to standby dorecover

then it got resolved

thanks guys for all your help..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ajaybeldeAuthor Commented:
it is working after i issued the below command

duplicate target database to standby dorecover.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.