DataGuard ORA-01194

ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/usr/local/oracle/oradata/orcl/system01.dbf'

重新将数据文件，控制文件，日志文件拷贝。

[oracle@localhost ~]$ df -hT
Filesystem Type Size Used Avail Use% Mounted on
/dev/sda2 ext3 12G 11G 61M 100% /
/dev/sda5 ext3 2.0G 36M 1.9G 2% /tmp
/dev/sda3 ext3 2.0G 40M 1.8G 3% /home
/dev/sda1 ext3 99M 12M 83M 12% /boot
tmpfs tmpfs 506M 0 506M 0% /dev/shm
[oracle@localhost ~]$ cd /oracle/oradata/pszx_by/
[oracle@localhost pszx_by]$ ls
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
control02.ctl redo02.log system01.dbf users01.dbf
control03.ctl redo03.log temp01.dbf
[oracle@localhost pszx_by]$ rm -rf *
[oracle@localhost pszx_by]$ ls
[oracle@localhost pszx_by]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 28 11:42:17 2012

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

Connected to an idle instance.

SQL> select instance_name,status from v$instance;
select instance_name,status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL> exit
Disconnected
[oracle@localhost pszx_by]$ cd ../
[oracle@localhost oradata]$ cd pszx_db/
[oracle@localhost pszx_db]$ ls
control01.ctl redo01.log sysaux01.dbf undotbs01.dbf
control02.ctl redo02.log system01.dbf users01.dbf
control03.ctl redo03.log temp01.dbf
[oracle@localhost pszx_db]$ cp * ../pszx_by/
[oracle@localhost pszx_db]$ df -hT
Filesystem Type Size Used Avail Use% Mounted on
/dev/sda2 ext3 12G 11G 59M 100% /
/dev/sda5 ext3 2.0G 36M 1.9G 2% /tmp
/dev/sda3 ext3 2.0G 40M 1.8G 3% /home
/dev/sda1 ext3 99M 12M 83M 12% /boot
tmpfs tmpfs 506M 0 506M 0% /dev/shm
[oracle@localhost pszx_db]$ export ORACLE_SID=pszx_by
[oracle@localhost pszx_db]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 28 11:54:17 2012

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 62916852 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oradata/pszx_by/
Oldest online log sequence 27
Next log sequence to archive 29
Current log sequence 29

SQL> alter database open
2 ;

Database altered.

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.