Creating Standby database [message #425562] |
Fri, 09 October 2009 12:03 |
ankush_chawla
Messages: 136 Registered: November 2006
|
Senior Member |
|
|
hi
We followed the metalink doc and try to create the standby database.
We took the hot backup of production and starting preparing for standby database
We faced following issues
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-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1:
Kindly help .
in one of the Forum soln provided was to executed the below command
SQL> alter database recover managed standby database;
However it ran endlessly for hours(>10hrs) doesnot seeems to show any results. So we cancelled and tried again to build the standby database however still the same issue
|
|
|