shenghuiping2001的专栏

本文章是关于 联机日志 恢复的实验。oracle@aoracle ezhou]$ mv redo01.log ./bak[oracle@aoracle ezhou]$ ls -lrttotal 1516148drwxr-xr-x 3 oracle oinstall      4096 Sep 28 16:34 patch-rw-r----- 1 oracle oinstall

Below workshop, I will perform some workshops about the database recovery:Step1:   when the database in not open status:    1: when the database open, remove all the datafile.  2: shutdown t

今天碰到：ORA-00600: 内部错误代码, 参数: [2662], [0], [583782], [0], [631878], [4194313], [], []ORA-600 [2662] [a] [c] [d] [e]Arg [a] Current SCN WRAPArg Current SCN BASEArg [c] dependent SCN WRAPArg [

下面有原来的controlfile 来试试：具体步骤如下:startup force;alter system set "_allow_resetlogs_corruption"=true scope=spfile;recover database using backup controlfile until cancel;alter databse open resetlog

今天测试 rman 的回归测试：RMAN> list backup summary;List of Backups===============Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag------- -- -- - ----------- ---------------

今天试验了resetlog 跨越时间段进行恢复：先备份：C:\Documents and Settings\Jonup>rman target /恢复管理器: Release 10.2.0.1.0 - Production on 星期三 1月 11 10:53:14 2012Copyright (c) 1982, 2005, Oracle.  All rights reserved

今天发现 control file的问题，和datafile 里的checkpoint 不一致，导致database 不能open ,下面来说说啥时要用到using backup controlfile:SQL> select checkpoint_change# from v$datafile;CHECKPOINT_CHANGE#------------------

重建controlfile:alter database backup controlfile to trace;oradebug setmypidoradebug tracefile_name 可以得到trace 的name打开trace 文件：修改： reuse ---> set,   nosetlogs ---> setlogsCREATE CONTROLFILE s

一点说明：媒体恢复分完全恢复和不完全恢复。不完全恢复可以恢复到指定的时刻或系统更改号，但不完全恢复之后剩余日志文件就不可用，必须重置日志序列号，用RESETLOGS选项打开数据库，此后数据库变成一个新形体，为了将来的恢复，必须重做一致备份。而且，RESETLOGS之前的备份已不可用。但是，很可能在RESETLOGS后没有做数据库的一致备份，而数据库又不认识RESETLOGS之前的备份，此时该如

本文章是关于control 控制文件的恢复：oracle@aoracle ezhou]$ ls -l | wc -l18[oracle@aoracle ezhou]$ ls -l *.ctl-rw-r----- 1 oracle oinstall 7061504 Dec  6 21:43 control01.ctl-rw-r----- 1 oracle oinstall 706

Backup and Recovery best practices dictate that we must use a RMAN recovery catalog and also have the controlfile AUTOBACKUP enabled.If we do not do either and we lose all the controlfiles, we canno

本实验室做当数据库在 open 和shutdown 的两种情况下spfile 和pfile 丢失的情况下的恢复。oracle@aoracle dbs]$ rman target rman_user/rman_user;Recovery Manager: Release 10.2.0.1.0 - Production on Thu Dec 8 19:21:38 2011Copyright

本实验是恢复spfile:SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup nomount;ORACLE instance started.Total System Global Area  335544320 bytes

关于数据文件的回复：1： 先备份：RMAN> backup full database;Starting backup at 06-DEC-11using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=1

There are two type ways of backup:  After completing this lesson, you should be able to do the following:  1: Describe media recovery.2: Perform recovery in NOARCHIVELOG mode.3: Perform comp