oracle初始化dg备库命令,DG 备库不应用 - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

Media Recovery Waiting for thread 1 seq# 295305

Media Recovery Log /sfisarch/sfgp/1_295305.arc

Wed Dec 13 08:09:56 2017

alter database recover managed standby database cancel

Wed Dec 13 08:10:48 2017

ORA-1013 signalled during: alter database recover managed standby database ca...

Wed Dec 13 08:10:59 2017

alter database recover managed standby database disconnect from session

Wed Dec 13 08:11:30 2017

ORA-1153 signalled during: alter database recover managed standby database di...

Wed Dec 13 08:11:47 2017

alter database recover managed standby database cancel

Wed Dec 13 08:22:09 2017

alter database recover managed standby database disconnect from session

Wed Dec 13 08:22:39 2017

ORA-1153 signalled during: alter database recover managed standby database di...

Wed Dec 13 08:23:00 2017

alter database recover managed standby database cancel

Wed Dec 13 08:29:20 2017

ORA-1013 signalled during: alter database recover managed standby database ca...

Wed Dec 13 08:33:14 2017

Shutting down instance: further logons disabled

Wed Dec 13 08:47:38 2017

Shutting down instance (abort)

License high water mark = 6

Instance terminated by USER, pid = 13953

Wed Dec 13 08:47:44 2017

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 3

Using log_archive_dest parameter default value

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.8.0.

System parameters with non-default values:

processes                = 2000

timed_statistics         = TRUE

shared_pool_size         = 268435456

sga_max_size             = 5264873832

large_pool_size          = 117440512

java_pool_size           = 117440512

control_files            = /sfisdata/sfgp/control01.ctl, /sfisindex/sfgp/control02.ctl

db_block_size            = 8192

db_cache_size            = 419430400

compatible               = 9.2.0.0.0

remote_archive_enable    = true

log_archive_start        = TRUE

log_archive_dest_1       = LOCATION=/sfisarch/sfgp

standby_archive_dest     = /sfisarch/sfgp

fal_server               = pc38

fal_client               = tc38

log_archive_format       = %t_%s.arc

log_buffer               = 12582912

db_files                 = 1000

db_file_multiblock_read_count= 16

standby_file_management  = AUTO

fast_start_mttr_target   = 300

undo_management          = AUTO

undo_tablespace          = UNDOTBS2

undo_retention           = 10800

max_enabled_roles        = 60

remote_login_passwordfile= EXCLUSIVE

db_domain                =

instance_name            = sfgp

job_queue_processes      = 10

hash_join_enabled        = TRUE

background_dump_dest     = /oracle/app/oracle/admin/sfgp/bdump

user_dump_dest           = /oracle/app/oracle/admin/sfgp/udump

core_dump_dest           = /oracle/app/oracle/admin/sfgp/cdump

sort_area_size           = 524288

db_name                  = sfgp

open_cursors             = 800

star_transformation_enabled= FALSE

query_rewrite_enabled    = FALSE

pga_aggregate_target     = 419430400

PMON started with pid=2, OS id=13957

DBW0 started with pid=3, OS id=13959

DBW1 started with pid=4, OS id=13961

DBW2 started with pid=5, OS id=13963

LGWR started with pid=6, OS id=13965

CKPT started with pid=7, OS id=13967

SMON started with pid=8, OS id=13969

RECO started with pid=9, OS id=13971

CJQ0 started with pid=10, OS id=13973

Wed Dec 13 08:47:44 2017

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=11, OS id=13975

ARC0: Archival started

ARC1 started with pid=12, OS id=13977

ARC1: Archival started

Wed Dec 13 08:47:44 2017

ARCH: STARTING ARCH PROCESSES COMPLETE

Wed Dec 13 08:47:44 2017

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted

Wed Dec 13 08:47:44 2017

ARC0: Becoming the heartbeat ARCH

ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted

Wed Dec 13 08:47:51 2017

alter database mount standby database

Wed Dec 13 08:47:55 2017

Successful mount of redo thread 1, with mount id 1509804471

Wed Dec 13 08:47:55 2017

Standby Database mounted.

Completed: alter database mount standby database

Wed Dec 13 08:48:19 2017

alter database recover managed standby database disconnect from session

Attempt to start background Managed Standby Recovery process

MRP0 started with pid=14, OS id=13980

MRP0: Background Managed Standby Recovery process started

Media Recovery Log /sfisarch/sfgp/1_295305.arc

Wed Dec 13 08:48:26 2017

Completed: alter database recover managed standby database di

Wed Dec 13 08:48:32 2017

Media Recovery Log /sfisarch/sfgp/1_295306.arc

Media Recovery Log /sfisarch/sfgp/1_295307.arc