数据库RMAN不完全恢复-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

数据库RMAN不完全恢复

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:29 PM

oraclerecoverdatabaseEnter

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入之前介绍了：Oracle数据库RMAN不完全恢复之基于SCN恢复，本文我们主要介绍一下Oracle数据库RMAN不完全恢复之基于日志序列号恢复的相关知识，希望能够对您有所帮助。 --查看归档日志信息 SQL select

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

之前介绍了：Oracle数据库RMAN不完全恢复之基于SCN恢复，本文我们主要介绍一下Oracle数据库RMAN不完全恢复之基于日志序列号恢复的相关知识，希望能够对您有所帮助。

--查看归档日志信息 SQL> select * from t_user;

TEXT --------------------

java_ spring_ spring mvc_

SQL> insert into t_user select 'oracle_' from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select sequence#,name,first_change# from v$archived_log where status='A' order by sequence#;

SEQUENCE# NAME

FIRST_CHANGE#

SQL> insert into t_user select 'oracle_seq3' from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

--生成日志序列号为2的归档日志

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select sequence#,name,first_change# from v$archived_log where status='A' order by sequence#;

SEQUENCE# NAME

FIRST_CHANGE#

---------- ---------------------------------------------------------------------------------------------------- ------------- 2 /oracle/10g/oracle/log/archive_log2/archive_1_2_760487985.arclog 1216167 2 /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_2_7 1216167 5q9cvt1_.arc 9 rows selected.

SQL> insert into t_user select 'oracle_seq3_act' from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> alter system switch logfile;

--生成日志序列号为3的归档日志

System altered.

SQL> alter system checkpoint;

System altered.

SQL> select sequence#,name,first_change# from v$archived_log where status='A' order by sequence#;

SEQUENCE# NAME

FIRST_CHANGE#

---------- ---------------------------------------------------------------------------------------------------- ------------- 1 /oracle/10g/oracle/log/archive_log/archive_1_1_760487088.arclog 1214497 1 /oracle/10g/oracle/log/archive_log2/archive_1_1_760487088.arclog 1214497 1 /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_7 1214497 5q95ksf_.arc 1 /oracle/10g/oracle/log/archive_log/archive_1_1_760487985.arclog 1214498 1 /oracle/10g/oracle/log/archive_log2/archive_1_1_760487985.arclog 1214498 1 /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_7 1214498 5q9bh9d_.arc 2 /oracle/10g/oracle/log/archive_log/archive_1_2_760487985.arclog 1216167 SEQUENCE# NAME FIRST_CHANGE# ---------- ---------------------------------------------------------------------------------------------------- ------------- 2 /oracle/10g/oracle/log/archive_log2/archive_1_2_760487985.arclog 1216167 2 /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_2_7 1216167 5q9cvt1_.arc 3 /oracle/10g/oracle/log/archive_log/archive_1_3_760487985.arclog 1216186 3 /oracle/10g/oracle/log/archive_log2/archive_1_3_760487985.arclog 1216186 3 /oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_3_7 1216186 5q9f4d6_.arc 12 rows selected.

--恢复到日志序列号为3时的状态

[oracle@localhost ~]$ rman target sys/oracle@oralife nocatalog RMAN> run { startup force mount;

set until sequence=3;

restore database;

recover database;

sql 'alter database open resetlogs';

}

--查看，可见不包括日志序列号为3的归档日志信息（oracle_seq3_act），即恢复到日志序列号为2的归档日志

SQL> conn sys/oracle@oralife as sysdba Connected.

SQL> select * from t_user;

TEXT

--------------------

java_

spring_

oracle_

oracle_seq3

spring mvc_

数据库RMAN不完全恢复

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AM

MySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma

Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AM

ProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)

What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AM

MySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M

MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AM

Yes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe

MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AM

Adding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.

MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AM

MySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand

MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AM

ToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith

MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AM

ToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters

See all articles