基于scn号恢复oracle数据库测试

发布时间：2020-12-12 13:25:02 所属栏目：百科来源：网络整理

导读：oracle11g 数据库? RMAN backup database plus archivelog delete all input; (首先做一次数据库全备) [ [email?protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 16 16:52:01 2018 Copyright (c) 1982,2013,Oracle.

oracle11g 数据库?

RMAN> backup database plus archivelog delete all input; (首先做一次数据库全备)

[ [email?protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 16 16:52:01 2018 Copyright (c) 1982,2013,Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning,OLAP,Data Mining and Real Application Testing options [email?protected]> conn scott/oracle （连接到数据库scott用户，新建一张表格） Connected. [email?protected]> create table t1 (x int); Table created. [email?protected]> insert into t1 values (1); 1 row created. [email?protected]> commit ; （表格中插入数据，提交） Commit complete. [email?protected]> select * from t1; X ---------- 1 [email?protected]> conn / as sysdba Connected. [email?protected]> select timestamp_to_scn(sysdate) from v$database; （查看当前状态的SCN号） TIMESTAMP_TO_SCN(SYSDATE) ------------------------- 1026157 [email?protected]> [email?protected]> conn scott/oracle Connected. [email?protected]> insert into t1 values (2); 1 row created. [email?protected]> commit ; Commit complete. [email?protected]> select * from t1; X ---------- 1 2 [email?protected]> conn / as sysdba Connected. [email?protected]> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. [email?protected]> startup mount; ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size 2253664 bytes Variable Size 1006636192 bytes Database Buffers 587202560 bytes Redo Buffers 7319552 bytes Database mounted. [email?protected]> [email?protected]> quit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning,Data Mining and Real Application Testing options [ [email?protected] ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Mon Jul 16 16:58:23 2018 Copyright (c) 1982,2011,Oracle and/or its affiliates. All rights reserved. connected to target database: TESTDB (DBID=2764677489,not open) RMAN> run{ （基于SCN号恢复数据库到scn所指状态） 2> set until scn = 1026157 ; 3> restore database; 4> recover database; 5> alter database open resetlogs; 6> } executing command: SET until clause Starting restore at 2018-07-16 16:59:43 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=63 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/TESTDB/datafile/o1_mf_system_fnhjdl8q_.dbf channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/TESTDB/datafile/o1_mf_sysaux_fnhjdl9x_.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/TESTDB/datafile/o1_mf_undotbs1_fnhjdlb1_.dbf channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/TESTDB/datafile/o1_mf_users_fnhjdlbo_.dbf channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/TESTDB/datafile/o1_mf_example_fnhjj8l9_.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/TESTDB/backupset/2018_07_16/o1_mf_nnndf_TAG20180716T164512_fnrprryw_.bkp channel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/TESTDB/backupset/2018_07_16/o1_mf_nnndf_TAG20180716T164512_fnrprryw_.bkp tag=TAG20180716T164512 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete,elapsed time: 00:02:06 Finished restore at 2018-07-16 17:01:50 Starting recover at 2018-07-16 17:01:50 using channel ORA_DISK_1 starting media recovery media recovery complete,elapsed time: 00:00:02 Finished recover at 2018-07-16 17:01:52 database opened RMAN> RMAN> quit Recovery Manager complete. [ [email?protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 16 17:05:00 2018 Copyright (c) 1982,Data Mining and Real Application Testing options [email?protected]> conn scott/oracle Connected. [email?protected]> select * from t1; （查看，已经恢复） X ---------- 1 [email?protected]> [email?protected]> conn / as sysdba Connected. [email?protected]> select timestamp_to_scn(sysdate) from v$database; TIMESTAMP_TO_SCN(SYSDATE) ------------------------- 1026598 [email?protected]>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!