转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/30839817 ##########恢复前的准备工作 1、做个热备 select alter tablespace ||tablespace_name|| begin backup; ||chr(10)|| host cp ||file_name|| /backup ||chr(10)|| alter tablespace |
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/30839817
##########恢复前的准备工作
1、做个热备
select
'alter tablespace '||tablespace_name|| ' begin backup;' ||chr(10)||
'host cp '||file_name||' /backup' ||chr(10)||
'alter tablespace '||tablespace_name|| ' end backup;'
from dba_data_files order by tablespace_name;
sys@PROD> alter tablespace SYSAUX begin backup;
2、日志做切换
sys@PROD> alter system switch logfile;
System altered.
sys@PROD> alter system switch logfile;
System altered.
sys@PROD> alter system switch logfile;
System altered.
sys@PROD> conn gyj/gyj
Connected.
gyj@PROD> select * from gyj_test1;
ID NAME
---------- ----------------------------------------------------------------------------------------------------
1 guoyJ
2 BBBBB
gyj@PROD> insert into gyj_test1 values(3,'CCCCC');
1 row created.
gyj@PROD> commit;
Commit complete.
gyj@PROD> alter system switch logfile;
System altered.
gyj@PROD> alter system switch logfile;
System altered.
3、丢失参数文件，控制文件，redo日志文件
[oracle@jfdb dbs]$ rm -rf spfile.ora [oracle@jfdb dbs]$ rm -rf spfilePROD.ora [oracle@jfdb dbs]$ rm -rf initPROD.ora [oracle@jfdb PROD]$ rm -rf control0* [oracle@jfdb PROD]$ rm -rf redo0*
###########开始恢复
[oracle@jfdb trace]$ cat alert_PROD.log vi /tmp/pfile.ora processes = 150 sga_max_size = 900M sga_target = 900M control_files = "/u01/app/oracle/oradata/PROD/control01.ctl" control_files = "/u01/app/oracle/oradata/PROD/control02.ctl" _controlfile_update_check= "OFF" db_block_size = 8192 log_archive_dest_1 = "location=/arch" undo_tablespace = "UNDOTBS" _in_memory_undo = FALSE service_names = "PROD,crm,oa" local_listener = "(DESCRIPTION= (ADDRESS_LIST= (ADDRESS = (PROTOCOL=TCP)(HOST=jfdb)(PORT=1521)) (ADDRESS = (PROTOCOL=TCP)(HOST=jfdb)(PORT=1522))))" db_name = "PROD" pga_aggregate_target = 200M
2、启动实例 sys@PROD> startup pfile='/tmp/pfile.ora' nomount; ORACLE instance started. Total System Global Area 939495424 bytes Fixed Size 2233960 bytes Variable Size 251660696 bytes Database Buffers 679477248 bytes Redo Buffers 6123520 bytes sys@PROD> create spfile from pfile='/tmp/pfile.ora'; File created.3、开始还原数据文件
oracle@jfdb arch]$ cd /backup [oracle@jfdb backup]$ ll total 1664052 -rw-r-----. 1 oracle oinstall 340795392 Jun 8 06:01 sysaux01.dbf -rw-r-----. 1 oracle oinstall 524296192 Jun 8 06:01 system01.dbf -rw-r-----. 1 oracle oinstall 524296192 Jun 8 06:01 tp01.dbf -rw-r-----. 1 oracle oinstall 209723392 Jun 8 06:01 undotbs01.dbf -rw-r-----. 1 oracle oinstall 104865792 Jun 8 06:02 users01.dbf [oracle@jfdb backup]$ cp * -rf /u01/app/oracle/oradata/PROD
4、查数据库字符集
select distinct dbms_rowid.rowid_block_number(rowid) from props$;
DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID)
------------------------------------
801
[oracle@jfdb PROD]$ dd if=system01.dbf of=guoyJoe bs=8192 skip=801 count=1
1+0 records in
1+0 records out
8192 bytes (8.2 kB) copied, 0.000159113 s, 51.5 MB/s
[oracle@jfdb PROD]$ strings guoyJoe
NO_USERID_VERIFIER_SALT 0438054C4F979EC5A5F74990346F5327,
WORKLOAD_REPLAY_MODE
bPREPARE implies external replay clients can connect; REPLAY implies workload replay is in progress,
WORKLOAD_CAPTURE_MODE
/CAPTURE implies workload capture is in progress,
EXPORT_VIEWS_VERSION
Export views revision #,
DEFAULT_PERMANENT_TABLESPACE
USERS$Name of default permanent tablespace,
GLOBAL_DB_NAME
PROD
Global database name,
NLS_RDBMS_VERSION
11.2.0.3.0 RDBMS version for NLS parameters,
NLS_NCHAR_CHARACTERSET AL16UTF16
NCHAR Character set,
NLS_NCHAR_CONV_EXCP
FALSE
NLS conversion exception,
NLS_LENGTH_SEMANTICS
BYTE
NLS length semantics,
NLS_COMP
BINARY
NLS comparison,
NLS_DUAL_CURRENCY
Dual currency symbol,
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
Timestamp with timezone format,
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
Time with timezone format,
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
Time stamp format,
NLS_TIME_FORMAT
HH.MI.SSXFF AM
Time format,
NLS_SORT
BINARY
Linguistic definition,
NLS_DATE_LANGUAGE
AMERICAN
Date language,
NLS_DATE_FORMAT DD-MON-RR
Date format,
NLS_CALENDAR GREGORIAN
Calendar system,
NLS_CHARACTERSET
ZHS16GBK
Character set,
NLS_NUMERIC_CHARACTERS
Numeric characters,
NLS_ISO_CURRENCY
AMERICA
ISO currency,
NLS_CURRENCY
Local currency,
NLS_TERRITORY
AMERICA Territory,
NLS_LANGUAGE
AMERICAN
Language,
DEFAULT_TBS_TYPE SMALLFILE
Default tablespace type,
DST_SECONDARY_TT_VERSION
0'Version of secondary timezone data file,
DST_PRIMARY_TT_VERSION
14%Version of primary timezone data file,
DST_UPGRADE_STATE
NONE&State of Day Light Saving Time Upgrade,
DBTIMEZONE
+08:00
DB time zone,
TDE_MASTER_KEY_ID,
Flashback Timestamp TimeZone
GMT"Flashback timestamp created in GMT,
DEFAULT_EDITION
ORA$BASE$Name of the database default edition,
DEFAULT_PERMANENT_TABLESPACE
SYSTEM$Name of default permanent tablespace,
DEFAULT_TEMP_TABLESPACE
TEMPTS$Name of default temporary tablespace,
DICT.BASE
2 dictionary base tables version #
5、创建控制文件
sys@PROD> CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG 2 MAXLOGFILES 32 3 MAXLOGMEMBERS 2 4 MAXDATAFILES 32 5 MAXINSTANCES 1 6 MAXLOGHISTORY 449 7 LOGFILE 8 GROUP 1 '/u01/app/oracle/oradata/PROD/redo01.log' SIZE 50M, 9 GROUP 2 '/u01/app/oracle/oradata/PROD/redo02.log' SIZE 50M, 10 GROUP 3 '/u01/app/oracle/oradata/PROD/redo03.log' SIZE 50M 11 DATAFILE 12 '/u01/app/oracle/oradata/PROD/system01.dbf', 13 '/u01/app/oracle/oradata/PROD/sysaux01.dbf', 14 '/u01/app/oracle/oradata/PROD/undotbs01.dbf', 15 '/u01/app/oracle/oradata/PROD/users01.dbf', 16 '/u01/app/oracle/oradata/PROD/tp01.dbf' 17 CHARACTER SET ZHS16GBK; Control file created.
sys@PROD> select count(*) from v$archived_log;
COUNT(*)
----------
0
sys@PROD> alter database register physical logfile '/arch/1_134_842976958.dbf';
Database altered.
sys@PROD> alter database register physical logfile '/arch/1_135_842976958.dbf';
Database altered.
sys@PROD> alter database register physical logfile '/arch/1_136_842976958.dbf';
Database altered.
sys@PROD> alter database register physical logfile '/arch/1_137_842976958.dbf';
Database altered.
sys@PROD> alter database register physical logfile '/arch/1_138_842976958.dbf';
Database altered.
sys@PROD> select count(*) from v$archived_log;
COUNT(*)
----------
5
sys@PROD> select file#,checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1658759
2 1658739
3 1658788
4 1658802
5 1658774
sys@PROD> select file#,checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1658759
2 1658739
3 1658788
4 1658802
5 1658774
8、开始不完全恢复
sys@PROD> recover database using backup controlfile until cancel;
ORA-00279: change 1658739 generated at 06/08/2014 06:01:29 needed for thread 1
ORA-00289: suggestion : /arch/1_134_842976958.dbf
ORA-00280: change 1658739 for thread 1 is in sequence #134
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1658838 generated at 06/08/2014 06:02:46 needed for thread 1
ORA-00289: suggestion : /arch/1_135_842976958.dbf
ORA-00280: change 1658838 for thread 1 is in sequence #135
ORA-00278: log file '/arch/1_134_842976958.dbf' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1658841 generated at 06/08/2014 06:02:47 needed for thread 1
ORA-00289: suggestion : /arch/1_136_842976958.dbf
ORA-00280: change 1658841 for thread 1 is in sequence #136
ORA-00278: log file '/arch/1_135_842976958.dbf' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1658844 generated at 06/08/2014 06:02:50 needed for thread 1
ORA-00289: suggestion : /arch/1_137_842976958.dbf
ORA-00280: change 1658844 for thread 1 is in sequence #137
ORA-00278: log file '/arch/1_136_842976958.dbf' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1658856 generated at 06/08/2014 06:03:17 needed for thread 1
ORA-00289: suggestion : /arch/1_138_842976958.dbf
ORA-00280: change 1658856 for thread 1 is in sequence #138
ORA-00278: log file '/arch/1_137_842976958.dbf' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 1658859 generated at 06/08/2014 06:03:21 needed for thread 1
ORA-00289: suggestion : /arch/1_139_842976958.dbf
ORA-00280: change 1658859 for thread 1 is in sequence #139
ORA-00278: log file '/arch/1_138_842976958.dbf' no longer needed for this recovery
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
9、再次查看数据文件头的检查点与控制文件的检查点是否一致
sys@PROD> select file#,checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1658859
2 1658859
3 1658859
4 1658859
5 1658859
sys@PROD> select file#,checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1658859
2 1658859
3 1658859
4 1658859
5 1658859
10、用resetlogs打开数据库
sys@PROD> alter database open resetlogs; Database altered. #########恢复完成
PHP 5.4版本新功能：如何使用callable类型提示参数接受可调用的函数或方法Jul 29, 2023 pm 09:19 PMPHP5.4版本新功能：如何使用callable类型提示参数接受可调用的函数或方法引言：PHP5.4版本引入了一项非常便利的新功能-可以使用callable类型提示参数来接受可调用的函数或方法。这个新功能使得函数和方法可以直接指定相应的可调用参数，而无需进行额外的检查和转换。在本文中，我们将介绍callable类型提示的使用方法，并提供一些代码示例，
产品参数是什么意思Jul 05, 2023 am 11:13 AM产品参数是指产品属性的意思。比如服装参数有品牌、材质、型号、大小、风格、面料、适应人群和颜色等；食品参数有品牌、重量、材质、卫生许可证号、适应人群和颜色等；家电参数有品牌、尺寸、颜色、产地、适应电压、信号、接口和功率等。
怎样解决在 Windows 11/10 中缺失或找不到 Xlive.dll 的问题？May 08, 2023 pm 08:55 PM<p>Xlive.dll是Microsoft的一个动态链接库(DLL)，它是“WindowsLive游戏”的一部分。由Xlive.dll引起的错误可能是由于Xlive.dll文件的删除、放错位置、被恶意软件损坏或注册表项搞砸了。由于此错误而无法启动程序或游戏可能会令人沮丧。让我们看看解决这个问题的方法。此问题通常可以通过正确重新安装Xlive.dll文件来解决。</p><p><strong&
PHP Warning: in_array() expects parameter的解决方法Jun 22, 2023 pm 11:52 PM在开发过程中，我们可能会遇到这样一个错误提示：PHPWarning:in_array()expectsparameter。这个错误提示会在使用in_array()函数时出现，有可能是因为函数的参数传递不正确所导致的。以下我们来看看这个错误提示的解决方法。首先，需要明确in_array()函数的作用：检查一个值是否在数组中存在。该函数的原型为：in_a
Win10右键新建不见了Jan 07, 2024 pm 03:57 PM很多小伙伴用右键点击桌面的时候，发现列表里的新建不见了，这是怎么一回事呢?有可能是杀毒软件自动清理了一些文件，其实我们只要进入设置里调整一下数值就可以恢复了，具体的教程下面跟小编一起来看看吧。恢复Win10右键新建的步骤第一步，“win+R”打开运行，输入：regedit，点击“确定”，打开注册表编辑器第二步，在打开的注册表编辑器窗口，展开HKEY_CLASSES_ROOT，在HKEY_CLASSES_ROOT展开项中找到：Directory，再依次展开：Directory\Background
d3dx9_43.dll丢失在win7计算机中的解决方案Jul 16, 2023 pm 08:13 PM如何解决win7计算机中d3dx9_43.dll丢失的问题？3dx9_43.dll是计算机系统组件中directX9的dl组件。没有这个组件玩游戏，就会有游戏无法启动这个程序的提示。想解决的用户应该看看win7计算机中d3dx9_43.dl丢失的解决方案。d3dx9_43.dll丢失在win7计算机中的解决方案。1.从网上下载或复制d3dx9_43.dll文件_43.dll文件。将d3dx9_43.dll文件保存到系统中的System32目录下；3.按Win+R打开操作，输入regsvr32d3
机器学习超参数调优总结(PySpark ML)Apr 08, 2023 pm 07:21 PMML中的一个重要任务是模型选择，或者使用数据为给定任务找到最佳的模型或参数。这也称为调优。可以对单个的估计器(如LogisticRegression)进行调优，也可以对包括多种算法、特性化和其他步骤的整个pipeline进行调优。用户可以一次调优整个Pipeline，而不是分别调优 Pipeline 中的每个元素。ML中的一个重要任务是模型选择，或者使用数据为给定任务找到最佳的模型或参数。这也称为调优。可以对单个的Estimator(如LogisticRegression)进行调优，也
100亿参数的语言模型跑不动？MIT华人博士提出SmoothQuant量化，内存需求直降一半，速度提升1.56倍！Apr 13, 2023 am 09:31 AM大型语言模型（LLM）虽然性能强劲，但动辄几百上千亿的参数量，对计算设备还是内存的需求量之大，都不是一般公司能承受得住的。量化（Quantization）是常见的压缩操作，通过降低模型权重的精度（如32bit降为8bit），牺牲一部分模型的性能来换取更快的推理速度，更少的内存需求。但对于超过1000亿参数量的LLM来说，现有的压缩方法都无法保持模型的准确率，也无法在硬件上高效地运行。最近，麻省理工学院和英伟达的研究人员联合提出了一个通用后训练的量化（GPQ, general-purpose po
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Dreamweaver Mac version
Visual web development tools
Atom editor mac version download
The most popular open source editor
WebStorm Mac version
Useful JavaScript development tools
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
Notepad++7.3.1
Easy-to-use and free code editor
