常规方法是什么样的啊?你看看我这样子做是不是常规方法,怎么不可以阿?SQL> recover database ORA-01507: database not mounted SQL> shutdown immediate; ORA-01507: database not mounted ORACLE instance shut down. SQL> startup mount; ORACLE instance started.Total System Global Area 135338868 bytes Fixed Size 453492 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes ORA-00205: error in identifying controlfile, check alert log for more info
恢复过程: 1. rman nocatalog target / 2. startup nomount; 看看你有多少个控制文件就写多少行: 3. RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control01.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729'; RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control02.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729'; RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control03.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729';4. alter database mount; 5. RUN { ALLOCATE CHANNEL ch00 TYPE DISK; RESTORE DATABASE; RECOVER DATABASE; RELEASE CHANNEL ch00; } 6. alter database open resetlogs;
ORA-01507: database not mounted
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
1. rman nocatalog target /
2. startup nomount;
看看你有多少个控制文件就写多少行:
3. RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control01.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729';
RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control02.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729';
RESTORE CONTROLFILE TO '/home/oracle/oradata/jyc/control03.ctl' FROM '/home/oracle/rman/full03_cntrl_17_1_593532729';4. alter database mount;
5. RUN {
ALLOCATE CHANNEL ch00 TYPE DISK;
RESTORE
DATABASE;
RECOVER
DATABASE;
RELEASE CHANNEL ch00;
}
6. alter database open resetlogs;
用操作系统复制的呢?还是RMAN全备份的?不同方式不同处理啊~
不过反正全备份了,肯定能恢复
backup database;
backup current controlfile;有这两个备份, 整台服务器烧掉都没事..