如何清理RMAN备份数据中的过期数据
来源:优易学  2011-9-3 17:11:53   【优易学:中国教育考试门户网】   资料下载   IT书店

 好几天没开VM学习ORACLE
  今天启动出现下面错误:
  [root@web1 bdump]# pwd
  /opt/oracle/admin/testdb2/bdump
  [root@web1 bdump]# cat alert_oradb.log
  undo_tablespace = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain =
  dispatchers = (PROTOCOL=TCP) (SERVICE=testdb2XDB)
  job_queue_processes = 10
  background_dump_dest = /opt/oracle/admin/testdb2/bdump
  user_dump_dest = /opt/oracle/admin/testdb2/udump
  core_dump_dest = /opt/oracle/admin/testdb2/cdump
  audit_file_dest = /opt/oracle/admin/testdb2/adump
  db_name = testdb2
  open_cursors = 300
  pga_aggregate_target = 16777216
  MMAN started with pid=4, OS id=3760
  PSP0 started with pid=3, OS id=3758
  PMON started with pid=2, OS id=3756
  LGWR started with pid=6, OS id=3764
  DBW0 started with pid=5, OS id=3762
  CKPT started with pid=7, OS id=3766
  SMON started with pid=8, OS id=3768
  RECO started with pid=9, OS id=3770
  CJQ0 started with pid=10, OS id=3772
  MMON started with pid=11, OS id=3774
  Fri Aug 21 07:51:00 2009
  starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
  MMNL started with pid=12, OS id=3776
  Fri Aug 21 07:51:00 2009
  starting up 1 shared server(s) ...
  Fri Aug 21 07:51:01 2009
  ALTER DATABASE MOUNT
  Fri Aug 21 07:51:05 2009
  Setting recovery target incarnation to 5
  Fri Aug 21 07:51:05 2009
  Successful mount of redo thread 1, with mount id 1017141349
  Fri Aug 21 07:51:05 2009
  Database mounted in Exclusive Mode
  Completed: ALTER DATABASE MOUNT
  Fri Aug 21 07:51:05 2009
  ALTER DATABASE OPEN
  Fri Aug 21 07:51:06 2009
  LGWR: STARTING ARCH PROCESSES
  ARC0 started with pid=16, OS id=3784
  Fri Aug 21 07:51:06 2009
  ARC0: Archival started
  ARC1: Archival started
  LGWR: STARTING ARCH PROCESSES COMPLETE
  ARC1 started with pid=17, OS id=3786
  Fri Aug 21 07:51:06 2009
  ARC0: STARTING ARCH PROCESSES
  Fri Aug 21 07:51:06 2009
  ARC1: Becoming the 'no FAL' ARCH
  ARC1: Becoming the 'no SRL' ARCH
  Fri Aug 21 07:51:06 2009
  Thread 1 opened at log sequence 14
  Current log# 1 seq# 14 mem# 0: /oradata/testdb2/redo01.log
  Successful open of redo thread 1
  Fri Aug 21 07:51:06 2009
  MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
  Fri Aug 21 07:51:06 2009
  SMON: enabling cache recovery
  Fri Aug 21 07:51:06 2009
  ARC2: Archival started
  ARC0: STARTING ARCH PROCESSES COMPLETE
  ARC0: Becoming the heartbeat ARCH
  ARC2 started with pid=18, OS id=3788
  Fri Aug 21 07:51:08 2009
  Successfully onlined Undo Tablespace 1.
  Fri Aug 21 07:51:08 2009
  SMON: enabling tx recovery
  Fri Aug 21 07:51:08 2009
  Database Characterset is WE8ISO8859P1
  replication_dependency_tracking turned off (no async multimaster replication found)
  Starting background process QMNC
  QMNC started with pid=19, OS id=3790
  Fri Aug 21 07:51:16 2009
  Completed: ALTER DATABASE OPEN
  Fri Aug 21 07:51:17 2009

[1] [2] [3] 下一页

责任编辑:小草

文章搜索:
 相关文章
热点资讯
热门课程培训