Home » Server Options » Data Guard » pls help me
pls help me [message #237724] Tue, 15 May 2007 09:28 Go to next message
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 1899 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 Go to previous messageGo to next message
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.
Re: pls help me [message #237732 is a reply to message #237728] Tue, 15 May 2007 09:42 Go to previous messageGo to next message
sanjay_kant
Messages: 25
Registered: February 2007
Junior Member

how to do it...

can u tell me in detail?
Re: pls help me [message #237734 is a reply to message #237732] Tue, 15 May 2007 09:46 Go to previous messageGo to next message
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.
Re: pls help me [message #237773 is a reply to message #237724] Tue, 15 May 2007 12:40 Go to previous messageGo to next message
mlgoins
Messages: 116
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."
Re: pls help me [message #238288 is a reply to message #237773] Thu, 17 May 2007 05:57 Go to previous messageGo to next message
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
Re: pls help me [message #238600 is a reply to message #237724] Fri, 18 May 2007 12:24 Go to previous message
mlgoins
Messages: 116
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'

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


Current Time: Thu Mar 28 10:52:08 CDT 2024