源数据库的每个日志组各有两个成员。通过rman备份后恢复到另一台机器上。由于在目标机器上日志组其中一个成员对应的路径不存在,所以执行alter database open resetlogs会出错。请问能不能在此时删除路径不存在的日志组成员?谢谢!
解决方案 »
- 哪位大侠有mysql到oracle的数据库的转换软件?给个mysql to oracle
- Oracl中的使用utl_file来读取txt文件,数据插入数据库
- 关于oracle得plsql中使用操作系统命令,急!急!急! (100分)
- 怎么设成自动归档的呢?我的init.ora这个文件中没有log_archive_start这个参数呀。
- 请问如何exp备份一张表的一些数据?
- 请问OracleXMLSave类对要导入的XML文件格式有什么要求(实例说明最好)
- sql语句
- ORA-04031 错误!
- Job的两个参数Nextdate, interval的真正涵义
- 这个触发器怎么写?
- 冷备份恢复到异机,安装位置不同.
- C#链接Oracle数据库以及tnsnames.ora文件的问题
sql>alter database drop logfile member '/u01/oracle/product/10.0.2/oradata/ORCL/redo42.log';
sql>alter system switch logfile;
SYS AS SYSDBA> startup mount;
ORACLE instance started.Total System Global Area 612368384 bytes
Fixed Size 2074664 bytes
Variable Size 276826072 bytes
Database Buffers 327155712 bytes
Redo Buffers 6311936 bytes
Database mounted.
SYS AS SYSDBA> alter database drop logfile member '/home/oracle/redo01.log';
alter database drop logfile member '/home/oracle/redo01.log'
*
ERROR at line 1:
ORA-01609: log 1 is the current log for thread 1 - cannot drop members
ORA-00312: online log 1 thread 1: '/opt/app/oracle/oradata/orcl/redo01.log'
ORA-00312: online log 1 thread 1: '/home/oracle/redo01.log'
SYS AS SYSDBA> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-01109: database not open