Home » RDBMS Server » Backup & Recovery » auto specified any value after ran RECOVER STANDBY DATABASE;
auto specified any value after ran RECOVER STANDBY DATABASE; [message #269903] Tue, 25 September 2007 01:47 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

When i ran the RECOVER STANDBY DATABASE command.It 's will prompt as
below :
SQL> RECOVER STANDBY DATABASE;
ORA-00279: change 302927 generated at 09/10/2007 14:08:24 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\ORADATA\DB817\ARCHIVE\DB817T001S00021.ARC
ORA-00280: change 302927 for thread 1 is in sequence #21

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Is there anyway to force specified "AUTO" automatically ?
Because i will to create a scripts file for run automatic .

Thanks for advance !
Chara
Re: auto specified any value after ran RECOVER STANDBY DATABASE; [message #269913 is a reply to message #269903] Tue, 25 September 2007 02:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
RECOVER AUTOMATIC STANDBY DATABASE

Regards
Michel
Re: auto specified any value after ran RECOVER STANDBY DATABASE; [message #269914 is a reply to message #269913] Tue, 25 September 2007 02:16 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can also previously use:
"SET AUTORECOVERY ON"

Regards
Michel
Previous Topic: Rman not open
Next Topic: To test the restore of a database to new host
Goto Forum:
  


Current Time: Tue Nov 26 09:48:09 CST 2024