Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1114554
  • 博文数量: 227
  • 博客积分: 6860
  • 博客等级: 准将
  • 技术积分: 2688
  • 用 户 组: 普通用户
  • 注册时间: 2010-07-02 16:06
文章分类

全部博文(227)

文章存档

2015年(7)

2014年(8)

2012年(5)

2011年(62)

2010年(145)

分类: Oracle

2011-01-16 17:14:54

SQL> shutdown immediate
ORA-01116: error in opening database file 3
ORA-01110: data file 3: '/oracle/oradata/orcl/sysaux01.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@server ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on Sun Jan 16 09:46:29 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area     285212672 bytes

Fixed Size                     1218968 bytes
Variable Size                 88082024 bytes
Database Buffers             188743680 bytes
Redo Buffers                   7168000 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 16-JAN-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

recovery area destination: /oracle/flash_recovery_area
database name (or database unique name) used for search: ORCL
channel ORA_DISK_1: no autobackups found in the recovery area
autobackup search outside recovery area not attempted because DBID was not set
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/16/2011 09:47:42
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece


RMAN> restore controlfile from '/oracle/orabak/ctlbak/c-1268348214-20110116-08';

Starting restore at 16-JAN-11
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output filename=/oracle/oradata/orcl/control01.ctl
output filename=/oracle/oradata/orcl/control02.ctl
output filename=/oracle/oradata/orcl/control03.ctl
Finished restore at 16-JAN-11

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 16-JAN-11
Starting implicit crosscheck backup at 16-JAN-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
Crosschecked 13 objects
Finished implicit crosscheck backup at 16-JAN-11

Starting implicit crosscheck copy at 16-JAN-11
using channel ORA_DISK_1
Finished implicit crosscheck copy at 16-JAN-11

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to /oracle/oradata/orcl/example01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/orabak/databak/20110116_02m28b6s.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/orabak/databak/20110116_02m28b6s.dbf tag=TAG20110116T092444
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 16-JAN-11

RMAN> recover database;

Starting recover at 16-JAN-11
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 4 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2011_01_16/o1_mf_1_4_6m4l7zn4_.arc
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2011_01_16/o1_mf_1_4_6m4l7zn4_.arc thread=1 sequence=4
unable to find archive log
archive log thread=1 sequence=5
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/16/2011 09:49:53
RMAN-06054: media recovery requesting unknown log: thread 1 seq 5 lowscn 484211

RMAN> exit


Recovery Manager complete.
[oracle@server ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 16 09:50:16 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> create pfile from spfile;

File created.

SQL> !
[oracle@server ~]$ cd /oracle/product/10.2.0/db_1/dbs/
[oracle@server dbs]$ ls
hc_orcl.dat  init.ora      lkORCL     snapcf_orcl.f   spfileorcl.ora
initdw.ora   initorcl.ora  orapworcl  spfileorcl.bak
[oracle@server dbs]$ vi initorcl.ora

orcl.__db_cache_size=188743680
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=79691776
orcl.__streams_pool_size=0
*.audit_file_dest='/oracle/admin/orcl/adump'
*.background_dump_dest='/oracle/admin/orcl/bdump'
*.compatible='10.2.0.1.0'
*.control_files='/oracle/oradata/orcl/control01.ctl','/oracle/oradata/orcl/control02.ctl','/oracle/oradata/orcl/control03.ctl'#Restore Controlfile
*.core_dump_dest='/oracle/admin/orcl/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=94371840
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=285212672
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/admin/orcl/udump'
*._allow_resetlogs_corruption='TURE'
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
"initorcl.ora" 27L, 985C written   
如上添加*._allow_resetlogs_corruption='TURE'                          
[oracle@server dbs]$ pwd
/oracle/product/10.2.0/db_1/dbs
[oracle@server dbs]$ exit
exit

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount pfile='/oracle/product/10.2.0/db_1/dbs/initorcl.ora';
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              88082024 bytes
Database Buffers          188743680 bytes
Redo Buffers                7168000 bytes
Database mounted.
SQL> alter database open resetlogs;

Database altered.

SQL> !
[oracle@server ~]$ cd /oracle/oradata/
[oracle@server oradata]$ cd orcl/
[oracle@server orcl]$ ls -l
total 1051020
-rw-r-----  1 oracle oinstall   7061504 Jan 16 10:08 control01.ctl
-rw-r-----  1 oracle oinstall   7061504 Jan 16 10:08 control02.ctl
-rw-r-----  1 oracle oinstall   7061504 Jan 16 10:08 control03.ctl
-rw-r-----  1 oracle oinstall 104865792 Jan 16 10:07 example01.dbf
-rw-r-----  1 oracle oinstall  52429312 Jan 16 10:07 redo01.log
-rw-r-----  1 oracle oinstall  52429312 Jan 16 10:07 redo02.log
-rw-r-----  1 oracle oinstall  52429312 Jan 16 10:07 redo03.log
-rw-r-----  1 oracle oinstall 251666432 Jan 16 10:07 sysaux01.dbf
-rw-r-----  1 oracle oinstall 503324672 Jan 16 10:07 system01.dbf
-rw-r-----  1 oracle oinstall  20979712 Jan 16 10:07 temp01.dbf
-rw-r-----  1 oracle oinstall  31465472 Jan 16 10:07 undotbs01.dbf
-rw-r-----  1 oracle oinstall   5251072 Jan 16 10:07 users01.dbf
[oracle@server orcl]$
阅读(1799) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~