喜欢就来多看看

logical standby create from physical standby

上一篇 / 下一篇  2007-01-29 00:00:00 / 个人分类:11g&Grid

alter database open resetlogs
RESETLOGS after complete recovery through change 822158
Mon Jan 29 11:58:37 2007
Setting recovery target incarnation to 2
Mon Jan 29 11:58:38 2007
Assigning activation ID 793653207 (0x2f4e2fd7)
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=14, OS id=22567
Mon Jan 29 11:58:38 2007
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Mon Jan 29 11:58:38 2007
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1 started with pid=15, OS id=22569
ARC1: Becoming the heartbeat ARCH
Mon Jan 29 11:58:38 2007
Thread 1 opened at log sequence 1
Current log# 3 seq# 1 mem# 0: /u01/app/oracle/oradata/grid/redo03.log
Successful open of redo thread 1
Mon Jan 29 11:58:38 2007
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jan 29 11:58:38 2007
SMON: enabling cache recovery
Mon Jan 29 11:58:39 2007
Successfully onlined Undo Tablespace 1.
Dictionary check beginning
Dictionary check complete
Mon Jan 29 11:58:40 2007
SMON: enabling tx recovery
Mon Jan 29 11:58:40 2007
Database Characterset is ZHS16GBK
Threshold validation cannot be done before catproc is loaded.
**********************************************************
WARNING: Files may exists in db_recovery_file_dest
that are not known to the database. Use the RMAN command
CATALOG RECOVERY AREA to re-catalog any such files.
One of the following events caused this:
1. A backup controlfile was restored.
2. A standby controlfile was restored.
3. The controlfile was re-created.
4. db_recovery_file_dest had previously been enabled and
then disabled.
**********************************************************
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=22575
Mon Jan 29 11:58:42 2007
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation skipped -- detected logical instantiation
Mon Jan 29 11:58:42 2007
LOGSTDBY: Validation complete
Global Name changed to LGGRID
Mon Jan 29 11:58:46 2007
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Mon Jan 29 11:58:47 2007
Completed: alter database open resetlogs
Mon Jan 29 12:03:18 2007
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 22699
RFS[1]: Identified database type as 'logical standby'
Mon Jan 29 12:03:18 2007
RFS LogMiner: Client enabled and ready for notification
Mon Jan 29 12:05:42 2007
ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE
Mon Jan 29 12:05:42 2007

RFS[1]: Assigned to RFS process 24917
RFS[1]: Identified database type as 'logical standby'
Mon Jan 29 13:22:27 2007
RFS LogMiner: Client enabled and ready for notification
RFS[1]: Archived Log: '/u01/app/oracle/arch/1_65_612723204.dbf'
Mon Jan 29 13:22:28 2007
RFS LogMiner: Registered logfile [/u01/app/oracle/arch/1_65_612723204.dbf] to LogMiner session id [1]
Mon Jan 29 13:22:28 2007
LOGMINER: Begin mining logfile: /u01/app/oracle/arch/1_65_612723204.dbf
Mon Jan 29 13:22:29 2007
LOGMINER: End mining logfile: /u01/app/oracle/arch/1_65_612723204.dbf
Mon Jan 29 13:22:32 2007
LOGMINER: Log Auto Delete - deleting: /u01/app/oracle/arch/1_64_612723204.dbf
Deleted file /u01/app/oracle/arch/1_64_612723204.dbf



TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2009-01-09  
    123
45678910
11121314151617
18192021222324
25262728293031

数据统计

  • 访问量: 12315
  • 日志数: 1129
  • 图片数: 1
  • 书签数: 1
  • 建立时间: 2007-12-13
  • 更新时间: 2008-06-02

RSS订阅

Open Toolbar