Shulou(Shulou.com)06/01 Report--

Execute the following statement to report an error:

SQL > alter tablespace system begin backup;ERROR at line 1:ORA-01123: cannot start online backup; media recovery not enabled

When you check the data and find that the filing is not open, open the archiving procedure:

SQL > alter database close normal;Database altered.SQL > select open_mode from vested database is open, and alter database archivelog;Database altered is the most important one.

It is found that you need to restart the database at this time, otherwise you cannot directly switch to read-write mode:

SQL > alter database open;alter database open*ERROR at line 1:ORA-16196: database has been previously opened and closedSQL > shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL > startup;ORACLE instance started.Total System Global Area 6680915968 bytesFixed Size 2213936 bytesVariable Size 3556771792 bytesDatabase Buffers 3087007744 bytesRedo Buffers 34922496 bytesDatabase mounted.Database opened.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.