这个alter log是什么意思

haihaiff

看不到动 我原来的system01。dbf 被我剪切到另外的文件夹里  现在复制回去 结果就进不了oacle了 不知道为什么

Mon Mar 08 20:21:29 2010
Shutting down instance: further logons disabled
Mon Mar 08 20:21:29 2010
Stopping background process CJQ0
Mon Mar 08 20:21:29 2010
Stopping background process MMNL
Mon Mar 08 20:21:29 2010
Stopping background process MMON
Mon Mar 08 20:21:29 2010
Shutting down instance (immediate)
License high water mark = 1
Mon Mar 08 20:21:29 2010
Stopping Job queue slave processes
Mon Mar 08 20:21:29 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Mon Mar 08 20:21:30 2010
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Mar 08 20:21:30 2010
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Mar 08 20:21:40 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
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       = 58720256
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
  sga_target               = 188743680
  control_files            = D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 117440512
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = D:\oracle\product\10.2.0/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  _allow_resetlogs_corruption= TRUE
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  O7_DICTIONARY_ACCESSIBILITY= TRUE
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ORCLXDB)
  job_queue_processes      = 10
  audit_file_dest          = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
  background_dump_dest     = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
  user_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
  core_dump_dest           = D:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
  db_name                  = ORCL
  open_cursors             = 300
  pga_aggregate_target     = 62914560
PMON started with pid=2, OS id=6332
PSP0 started with pid=3, OS id=7312
MMAN started with pid=4, OS id=7348
DBW0 started with pid=5, OS id=7504
LGWR started with pid=6, OS id=8096
CKPT started with pid=7, OS id=6204
SMON started with pid=8, OS id=6636
RECO started with pid=9, OS id=1380
CJQ0 started with pid=10, OS id=6376
MMON started with pid=11, OS id=1224
Mon Mar 08 20:21:40 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=860
Mon Mar 08 20:21:40 2010
starting up 1 shared server(s) ...
Mon Mar 08 20:21:40 2010
ALTER DATABASE   MOUNT

renxiao2003

你是在ORACLE启动的时候剪切的文件吗？

haihaiff

lz英明 是的 但是数据库打不开SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01245: RESETLOGS 完成时脱机文件 1 将丢失
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'

haihaiff

SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01245: RESETLOGS 完成时脱机文件 1 将丢失
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'


SQL>  recover database using backup controlfile;
ORA-00279: 更改 2019895 (在 02/28/2010 12:14:10 生成) 对于线程 1 是必需的
ORA-00289: 建议:
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2010_03_08\O1_MF_1_

115_%U_.ARC
ORA-00280: 更改 2019895 (用于线程 1) 在序列 #115 中


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\product\10.2.0\oradata\ORCL\REDO01.LOG
ORA-00310: 归档日志包含序列 113; 要求序列 115
ORA-00334: 归档日志: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'


SQL> recover database using backup controlfile;
ORA-00279: 更改 2019895 (在 02/28/2010 12:14:10 生成) 对于线程 1 是必需的
ORA-00289: 建议:
D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2010_03_08\O1_MF_1_

115_%U_.ARC
ORA-00280: 更改 2019895 (用于线程 1) 在序列 #115 中


指定日志: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracle\product\10.2.0\oradata\ORCL\REDO02.LOG
ORA-00310: 归档日志包含序列 114; 要求序列 115
ORA-00334: 归档日志: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'


SQL> alter database open resetlogs;
alter database open resetlogs
*
第 1 行出现错误:
ORA-01245: RESETLOGS 完成时脱机文件 1 将丢失
ORA-01110: 数据文件 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF'


SQL>

blue_stone

recover database;
alter database open

wmxcn2000

拷走后,你是不是又对数据库做过 DDL 操作? 那样的话,SYSTEM 表空间记录的东西,和实际的就不一样了;

dingning239

需要进行恢复，你的system01.dbf 文件头部与控制文件中记录不符了，按照blue_stone的方法做吧

haihaiff

如果recover database;
alter database open 也无效的话是不是就完蛋了

fixlee

1.将数据库置为mount状态
2.将以前备份的数据库文件拷贝到当前目录
3.利用归档日志及redo log恢复system表空间
4.alter database open