Open the database and reset the logs - alter database open resetlogs.
打开数据库并重新设置日志——alter database open resetlogs。
Open the database and reset the logs - alter database open resetlogs (Note after opening using resetlogs will create online log files).
打开数据库并重新设置日志——alter databaseopenresetlogs(注意,使用resetlogs打开后将创建联机日志文件)。
Since the redo log group is inactive and is archived, just clear the redo log - alter database clear logfile group N (where N is the group # of the lost redo log)
由于重做日志组是不活动和归档的,所以只需清除重做日志即可 ——alter databaseclear logfilegroupN(其中 N 是丢失的重做日志的组 #)。
SQL> alter database open resetlogs;
打开数据库。
SQL> alter database open read only;
在只读模式下打开备用数据库。
The ALTER DATABASE command is used to add storage paths.
使用ALTER DATABASE命令来添加存储路径。
Thus, to modify an existing database named TEST_DB so that it USES automatic storage, you would execute an ALTER database command that looks like this.
这样,要修改一个名为test_db的现有数据库,使其使用自动存储,则可以执行如下所示的ALTER DATABASE命令。
You are advised to issue the ALTER DATABASE partition GROUP statement to customize the tablespace setting and to control the container layout in the new partition.
建议发出ALTER DATABASEPARTITIONgroup语句来定制表空间设置,并控制新分区中的容器布局。
You are advised to issue the ALTER DATABASE partition GROUP statement to customize the tablespace setting and to control the container layout in the new partition.
建议发出ALTER DATABASEPARTITIONgroup语句来定制表空间设置,并控制新分区中的容器布局。
应用推荐