OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » pls help me

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

pls help me [message #237724]

Tue, 15 May 2007 09:28

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

Hi !

I’m configuring Physical standby database on my stand-alone PC.
I have done completed:
>standby controlfile
>consistent copy of database
>Pfile for standby database and configured parameter in that.
> configured Tns.ora, sql.ora and listner.ora

Now I mount my standby database….and done these things>>>>>>>

Attachment: error.doc
(Size: 25.50KB, Downloaded 212 times)

[Updated on: Tue, 15 May 2007 09:30]

Report message to a moderator

Re: pls help me [message #237728 is a reply to message #237724]

Tue, 15 May 2007 09:37

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

From you alert log, it seems it requires archive logs

""""""""""""Media Recovery Waiting for thread 49476 seq# 1"""""""

Supply archive logs on target node and try again.

Report message to a moderator

Re: pls help me [message #237732 is a reply to message #237728]

Tue, 15 May 2007 09:42

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

how to do it...

can u tell me in detail?

Report message to a moderator

Re: pls help me [message #237734 is a reply to message #237732]

Tue, 15 May 2007 09:46

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

What you have to do is , just copy respective archive logs on standby node and mount your database in standby recover mode and switch logs on primary side and check the behaviour of standby database, if it's working fine, then try to open up your database in read only mode.

Report message to a moderator

Re: pls help me [message #237773 is a reply to message #237724]

Tue, 15 May 2007 12:40

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

Perhaps the Standby Control file was created BEFORE the backup of the data files?

"The filename for the newly created standby control file must be different from the filename of the current control file of the primary database. The control file must also be created after the last time stamp for the backup datafiles."

Report message to a moderator

Re: pls help me [message #238288 is a reply to message #237773]

Thu, 17 May 2007 05:57

sanjay_kant
Messages: 25
Registered: February 2007

Junior Member

i think u r right molgin. let me check. i think i have created it before taking backup. Cool

Report message to a moderator

Re: pls help me [message #238600 is a reply to message #237724]

Fri, 18 May 2007 12:24

mlgoins
Messages: 115
Registered: March 2007
Location: Denver, CO

Senior Member

I had the exact same experience today, and it may have been because I tried to open the Standby Database read-only before the initial recovery had completed. I'm hoping that once the initial recovery completes, I won't see this error.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/opt/ora9/oradata/stdby/system01.dbf'

Report message to a moderator

Previous Topic:	Setup Logical Database using Oracle enterprise manager Grid
Next Topic:	Monitoring Data Guard with SNMP?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 11:13:45 CDT 2013

Total time taken to generate the page: 0.19925 seconds