Home » RDBMS Server » Backup & Recovery » Automatic or Managed Recovery
Automatic or Managed Recovery [message #258720] Mon, 13 August 2007 08:09 Go to next message
preet_kumar
Messages: 195
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.
Re: Automatic or Managed Recovery [message #258723 is a reply to message #258720] Mon, 13 August 2007 08:17 Go to previous messageGo to next message
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

Re: Automatic or Managed Recovery [message #258827 is a reply to message #258723] Mon, 13 August 2007 11:26 Go to previous message
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.
Previous Topic: RMAN Clone Operation Fails with RMAN-05001
Next Topic: What is the ideal backup? (oracle 10gR2)
Goto Forum:
  


Current Time: Sat Dec 03 13:44:03 CST 2016

Total time taken to generate the page: 0.11734 seconds