1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)
A - The database files are synchronized.
B - Uncommitted changes are no rolled back.
C - The database is closed,but the instance is still started.
D - Database buffers and redo buffers are not written to the disk.
E - The data base undergose automatic media recovery during the next startup.
Loading...
1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)
A - The database files are synchronized.
B - Uncommitted changes are no rolled back.
C - The database is closed,but the instance is still started.
D - Database buffers and redo buffers are not written to the disk.
E - The data base undergose automatic media recovery during the next startup.
More…
Popularity: 38% [?]
if you get ORA-00600 or the following error message on your Oracle standby database:
Fri Mar 09 10:57:49 2007
Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
ORA-10564: tablespace UNDOTBS2
ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
ORA-10560: block type ‘KTU SMU HEADER BLOCK’
Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
More…
Popularity: 53% [?]
9.获取日志组和日志成员的信息
V$LOG
V$LOGFILE
这两个视图都存在STATUS这个列，下面主要讲一下这两个列存在的一些状态以及这些状态所表示的含义。
More…
Popularity: 57% [?]
1.基本日志结构
重做日志记录所有对数据库所作的数据修改。当数据库系统或者介质失败时，给数据库提供一种恢复机制。
.重做日志以日志组的形式管理。
.ORACLE数据库最少要有两个日志组
.每个日志组里面的日志文件称为日志成员。
.重做日志组和其成员的数量由参数MAXLOGFILES和MAXLOGMENGERS控制
More…
Popularity: 56% [?]
控制文件的数量设定取决数据库事务的数量大小。每一个事务对数据库所作的修改都会被记录在重做日志文件中，日志文件的大小决定于数据库可以丢失数据
的承受能力。如果数据库中的数据不重要，你可以承受丢失几个小时的数据，那么你就可以使用大重做日志文件，较少的日志文件数。
如果你不能承受任何数据的丢失，那么你就需要使用小的重做日志文件，多个日志文件。
在Oracle7, Oracle8-8i 和 Oracle9i,中最少要有两个重做日志文件组，建议使用三个。同时重做日志的镜像机制保证了重做日志文件几乎可以不遭受丢失。
More…
Popularity: 53% [?]