Solutions to flashback standby database in oracle

Source: Internet
Author: User

How to open the standby database after Flashback:

SQL> flashback database to restore point myrs1;
 
Flashback complete.
 
SQL> shutdown immediate
ORA-01109: database not open
 
 
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
 
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 356517912 bytes
Database Buffers 159383552 bytes
Redo Buffers 3780608 bytes
Database mounted.
SQL>
SQL> alter database recover managed standby database using current logfile disconnect;
Alter database recover managed standby database using current logfile disconnect
*
ERROR at line 1:
ORA-01665: control file is not a standby control file
 
 
SQL>
SQL>
SQL> alter database convert to physical standby;
 
Database altered.
 
SQL>
SQL>
SQL> shutdown immediate
ORA-01109: database not open
 
 
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.
 
Total System Global Area 521936896 bytes
Fixed Size 2254824 bytes
Variable Size 356517912 bytes
Database Buffers 159383552 bytes
Redo Buffers 3780608 bytes
Database mounted.
Database opened.
SQL> alter database recover managed standby database using current logfile disconnect;
 
Database altered.
 
SQL>

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.