_minimum_giga_scn 隐含参数测试

最新推荐文章于 2024-11-01 12:20:35 发布

cntkcn4698

最新推荐文章于 2024-11-01 12:20:35 发布

阅读量150

点赞数

文章标签：数据库网络

--隐含参数递增SCN（10015有时候不成功用隐含参数）
SQL> startup force
ORACLE instance started.

Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 71305364 bytes
Database Buffers 109051904 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select a.checkpoint_change# from v$database a;

CHECKPOINT_CHANGE#
------------------
595109 --递增前的scn

SQL> create pfile from spfile;
File created.
SQL> alter system set "_minimum_giga_scn"=1 scope=spfile
2 ;
System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 184549376 bytes
Fixed Size 1218412 bytes
Variable Size 79693972 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> select a.checkpoint_change# from v$database a;

CHECKPOINT_CHANGE#
------------------
1073741825 --递增后的SCN
SQL>
--------最后要吧参数去掉一下是启动时候的部分LOG

ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 71303168
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
sga_target = 184549376
control_files = /u01/app/oracle/oradata/test/control01.ctl, /u01/app/oracle/oradata/test/control02.ctl, /u01/app/oracle
/oradata/test/control03.ctl
db_block_size = 8192
__db_cache_size = 100663296
_minimum_giga_scn = 1
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=testXDB)
job_queue_processes = 10
background_dump_dest = /u01/app/oracle/admin/test/bdump
user_dump_dest = /u01/app/oracle/admin/test/udump
core_dump_dest = /u01/app/oracle/admin/test/cdump
audit_file_dest = /u01/app/oracle/admin/test/adump
db_name = test
open_cursors = 300
pga_aggregate_target = 60817408
PMON started with pid=2, OS id=20806
PSP0 started with pid=3, OS id=20808
MMAN started with pid=4, OS id=20810
DBW0 started with pid=5, OS id=20812
LGWR started with pid=6, OS id=20814
CKPT started with pid=7, OS id=20816
SMON started with pid=8, OS id=20818
RECO started with pid=9, OS id=20820
CJQ0 started with pid=10, OS id=20822
MMON started with pid=11, OS id=20824
Mon Oct 17 23:03:43 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=20826
Mon Oct 17 23:03:43 2011
starting up 1 shared server(s) ...
Mon Oct 17 23:03:44 2011
ALTER DATABASE MOUNT
Mon Oct 17 23:03:48 2011
Setting recovery target incarnation to 2
Mon Oct 17 23:03:48 2011
Successful mount of redo thread 1, with mount id 2062974800
Mon Oct 17 23:03:48 2011
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Mon Oct 17 23:03:49 2011
ALTER DATABASE OPEN
Advancing SCN to 1073741824 according to _minimum_giga_scn ---这个是log里面的提示