oracle scn隐藏参数,_minimum_giga_scn 隐含参数测试

--隐含参数递增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里面的提示[@more@]