OraFAQ Forum: Backup & Recovery » Automatic or Managed Recovery

Home » RDBMS Server » Backup & Recovery » Automatic or Managed Recovery

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

Automatic or Managed Recovery [message #258720]

Mon, 13 August 2007 08:09

preet_kumar
Messages: 204
Registered: March 2007

Senior Member

On a 8i standby database i used the below given command
startup nomount
alter database mount standby database;
recover automatic standby database;
cancel
alter database open read only;

On 10gR2 should i use the same command for a standby or
alter database recover managed standby database disconnect from session;

Note:Standby is using a script to download all archive log from primary as the standby is with internal IP not visible to primary.

Report message to a moderator

Re: Automatic or Managed Recovery [message #258723 is a reply to message #258720]

Mon, 13 August 2007 08:17

NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad

Member

In 10g for physical standby database, this is the command

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

If you are using real time apply, you can use:

SQL> alter database recover managed standby database using current logfile disconnect from session;

For the second one, you need to have standby redo logfiles

Get more at:

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i63561

Report message to a moderator

Re: Automatic or Managed Recovery [message #258827 is a reply to message #258723]

Mon, 13 August 2007 11:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

If your standby is not connected with PRIMARY i-e means not set the parameters for DATAGUARD i guess you cant use the DG commands.

Report message to a moderator

Previous Topic:	RMAN Clone Operation Fails with RMAN-05001
Next Topic:	What is the ideal backup? (oracle 10gR2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 10:39:31 CST 2024