RE: Dataguard setup

Previous post got barfed....!



SQL> startup nomount pfile=init_standby.ora 


SQL> alter database mount standy database;



& to start managed recovery



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


[/steve]
  
 

> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx 
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Laskey Steve
> Sent: 12 March 2009 10:35
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: RE: Dataguard setup
> 
> Kalyan,
> 
> Are you trying to start the standby for normal use?
> 
> If not, then you have to start the standby thus:-
> 
> SQL> startup nomount pfile=init_standby.ora alter database 
> mount standy 
> SQL> database;
> 
> 
> & to start managed recovery
> 
> SQL> alter database recover managed standby database disconnect from
> session;
> 
> 
> [/steve]
>  
> 
> > -----Original Message-----
> > From: ora-apps-dba-bounce@xxxxxxxxxxxxx 
> > [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of 
> Kalyan Sundar
> > Sent: 12 March 2009 10:12
> > To: ora-apps-dba@xxxxxxxxxxxxx
> > Subject: Dataguard setup
> > 
> > Hi All,
> > I am in a process of implementing datagaurd on one of our test 
> > database.
> > Please advice.
> > 
> > Where in I recieve following error when starting the stand-by
> > database:
> > SQL> startup
> > ORACLE instance started.
> > 
> > Total System Global Area 1073741824 bytes
> > Fixed Size        1264892 bytes
> > Variable Size     427819780 bytes
> > Database Buffers      633339904 bytes
> > Redo Buffers       11317248 bytes
> > ORA-01102: cannot mount database in EXCLUSIVE mode
> > 
> > 
> > Kalyan
> > 
> > 
> 
> 

Other related posts: