oracle 恢复 time,rman时间点恢复（until time）完整例子

最新推荐文章于 2022-04-21 22:59:44 发布
最新推荐文章于 2022-04-21 22:59:44 发布
阅读量545 收藏
点赞数
文章标签： oracle 恢复 time

一、步骤：

1、一次全备

2、记录时间，增加表空间，查询新增加的数据文件

3、再次全备

4、执行时间点恢复，恢复到2记录的时间之前

5、查询数据文件，发现2增加的数据文件不存在，时间点恢复成功。

二、操作日志：

]> export ORACLE_SID=orcl

]> rman target / catalog

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 15 15:36:47 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1210313093)

connected to recovery catalog database

RMAN> run{

2> ALLOCATE CHANNEL ch00 TYPE disk;

3> BACKUP INCREMENTAL LEVEL=0 SKIP INACCESSIBLE FILESPERSET 5 FORMAT '/rman/bk_%s_%p_%t' DATABASE;

4> sql 'alter system archive log current';

5> BACKUP FORMAT '/rman/archvelog_%s_%p_%t' FILESPERSET 10 ARCHIVELOG ALL DELETE INPUT;

6> BACKUP FORMAT '/rman/cntrl_%s_%p_%t' CURRENT CONTROLFILE;

backup FORMAT '/rman/spfile_%s_%p_%t' spfile;

7> 8> RELEASE CHANNEL ch00;

9> }

allocated channel: ch00

channel ch00: sid=158 devtype=DISK

Starting backup at 15-JUN-09

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

input datafile fno=00001 name=/oracle/oradata/orcl/system01.dbf

input datafile fno=00004 name=/oracle/oradata/orcl/users01.dbf

input datafile fno=00003 name=/oracle/oradata/orcl/sysaux01.dbf

input datafile fno=00005 name=/oracle/oradata/orcl/example01.dbf

input datafile fno=00002 name=/oracle/oradata/orcl/undotbs01.dbf

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/bk_9_1_689614839 tag=TAG20090615T154036 comment=NONE

channel ch00: backup set complete, elapsed time: 00:03:06

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/bk_10_1_689615027 tag=TAG20090615T154036 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:05

Finished backup at 15-JUN-09

sql statement: alter system archive log current

Starting backup at 15-JUN-09

current log archived

channel ch00: starting archive log backupset

channel ch00: specifying archive log(s) in backup set

input archive log thread=1 sequence=3 recid=1 stamp=682556439

input archive log thread=1 sequence=4 recid=2 stamp=682561319

input archive log thread=1 sequence=5 recid=3 stamp=682561346

input archive log thread=1 sequence=6 recid=4 stamp=682561375

input archive log thread=1 sequence=7 recid=5 stamp=682561574

input archive log thread=1 sequence=8 recid=6 stamp=682561674

input archive log thread=1 sequence=9 recid=7 stamp=682561779

input archive log thread=1 sequence=10 recid=8 stamp=682561881

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/archvelog_11_1_689615084 tag=TAG20090615T154439 comment=NONE

channel ch00: backup set complete, elapsed time: 00:01:36

channel ch00: deleting archive log(s)

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_26/o1_mf_1_3_4wq64g05_.arc recid=1 stamp=682556439

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_4_4wqbwcjj_.arc recid=2 stamp=682561319

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_5_4wqbxsxx_.arc recid=3 stamp=682561346

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_6_4wqbymmx_.arc recid=4 stamp=682561375

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_7_4wqc50dg_.arc recid=5 stamp=682561574

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_8_4wqc84l6_.arc recid=6 stamp=682561674

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_9_4wqccchy_.arc recid=7 stamp=682561779

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_10_4wqcglvb_.arc recid=8 stamp=682561881

channel ch00: starting archive log backupset

channel ch00: specifying archive log(s) in backup set

input archive log thread=1 sequence=11 recid=9 stamp=682561986

input archive log thread=1 sequence=12 recid=10 stamp=682562104

input archive log thread=1 sequence=13 recid=11 stamp=682562214

input archive log thread=1 sequence=14 recid=12 stamp=682562323

input archive log thread=1 sequence=15 recid=13 stamp=682569554

input archive log thread=1 sequence=16 recid=14 stamp=682600498

input archive log thread=1 sequence=17 recid=15 stamp=689594745

input archive log thread=1 sequence=18 recid=16 stamp=689595123

input archive log thread=1 sequence=19 recid=17 stamp=689595413

input archive log thread=1 sequence=20 recid=18 stamp=689605569

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/archvelog_12_1_689615185 tag=TAG20090615T154439 comment=NONE

channel ch00: backup set complete, elapsed time: 00:01:07

channel ch00: deleting archive log(s)

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_11_4wqckwr3_.arc recid=9 stamp=682561986

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_12_4wqcokn5_.arc recid=10 stamp=682562104

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_13_4wqcs023_.arc recid=11 stamp=682562214

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_14_4wqcw9of_.arc recid=12 stamp=682562323

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_15_4wqly88p_.arc recid=13 stamp=682569554

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_03_27/o1_mf_1_16_4wrk5d2j_.arc recid=14 stamp=682600498

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_17_53cc3po5_.arc recid=15 stamp=689594745

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_18_53cchlqx_.arc recid=16 stamp=689595123

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_19_53ccro3s_.arc recid=17 stamp=689595413

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_20_53coovtq_.arc recid=18 stamp=689605569

channel ch00: starting archive log backupset

channel ch00: specifying archive log(s) in backup set

input archive log thread=1 sequence=21 recid=19 stamp=689615061

input archive log thread=1 sequence=22 recid=20 stamp=689615071

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/archvelog_13_1_689615255 tag=TAG20090615T154439 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:02

channel ch00: deleting archive log(s)

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_21_53cyymx7_.arc recid=19 stamp=689615061

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_22_53cyyzpd_.arc recid=20 stamp=689615071

Finished backup at 15-JUN-09

Starting backup at 15-JUN-09

channel ch00: starting full datafile backupset

channel ch00: specifying datafile(s) in backupset

including current control file in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/cntrl_14_1_689615270 tag=TAG20090615T154750 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:02

Finished backup at 15-JUN-09

Starting backup at 15-JUN-09

channel ch00: starting full datafile backupset

channel ch00: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/spfile_15_1_689615279 tag=TAG20090615T154759 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:02

Finished backup at 15-JUN-09

released channel: ch00

RMAN>

RMAN>

RMAN>

RMAN> exit

Recovery Manager complete.

]> date

Mon Jun 15 15:49:09 CST 2009

]>

]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 15 15:49:33 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

>

> create tablespace test datafile '/oracle/oradata/orcl/test01.dbf' size 10m;

Tablespace created.

> col name format a60

> select file#,name from v$datafile;

FILE# NAME

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

1 /oracle/oradata/orcl/system01.dbf

2 /oracle/oradata/orcl/undotbs01.dbf

3 /oracle/oradata/orcl/sysaux01.dbf

4 /oracle/oradata/orcl/users01.dbf

5 /oracle/oradata/orcl/example01.dbf

6 /oracle/oradata/orcl/test01.dbf

6 rows selected.

> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

]> date

Mon Jun 15 15:52:50 CST 2009

]> rman target / catalog

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 15 15:53:10 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORCL (DBID=1210313093)

connected to recovery catalog database

RMAN> run{

2> ALLOCATE CHANNEL ch00 TYPE disk;

3> BACKUP INCREMENTAL LEVEL=0 SKIP INACCESSIBLE FILESPERSET 5 FORMAT '/rman/bk_%s_%p_%t' DATABASE;

4> sql 'alter system archive log current';

5> BACKUP FORMAT '/rman/archvelog_%s_%p_%t' FILESPERSET 10 ARCHIVELOG ALL DELETE INPUT;

6> BACKUP FORMAT '/rman/cntrl_%s_%p_%t' CURRENT CONTROLFILE;

7> backup FORMAT '/rman/spfile_%s_%p_%t' spfile;

8> RELEASE CHANNEL ch00;

9> }

starting full resync of recovery catalog

full resync complete

allocated channel: ch00

channel ch00: sid=159 devtype=DISK

Starting backup at 15-JUN-09

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

input datafile fno=00001 name=/oracle/oradata/orcl/system01.dbf

input datafile fno=00005 name=/oracle/oradata/orcl/example01.dbf

input datafile fno=00006 name=/oracle/oradata/orcl/test01.dbf

input datafile fno=00002 name=/oracle/oradata/orcl/undotbs01.dbf

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/bk_16_1_689615663 tag=TAG20090615T155422 comment=NONE

channel ch00: backup set complete, elapsed time: 00:01:26

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

input datafile fno=00004 name=/oracle/oradata/orcl/users01.dbf

input datafile fno=00003 name=/oracle/oradata/orcl/sysaux01.dbf

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/bk_17_1_689615750 tag=TAG20090615T155422 comment=NONE

channel ch00: backup set complete, elapsed time: 00:01:36

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

including current control file in backupset

including current SPFILE in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/bk_18_1_689615847 tag=TAG20090615T155422 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:06

Finished backup at 15-JUN-09

sql statement: alter system archive log current

Starting backup at 15-JUN-09

current log archived

channel ch00: starting archive log backupset

channel ch00: specifying archive log(s) in backup set

input archive log thread=1 sequence=23 recid=21 stamp=689615871

input archive log thread=1 sequence=24 recid=22 stamp=689615877

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/archvelog_19_1_689615883 tag=TAG20090615T155802 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:02

channel ch00: deleting archive log(s)

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_23_53czqzhv_.arc recid=21 stamp=689615871

archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_24_53czr5oc_.arc recid=22 stamp=689615877

Finished backup at 15-JUN-09

Starting backup at 15-JUN-09

channel ch00: starting full datafile backupset

channel ch00: specifying datafile(s) in backupset

including current control file in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/cntrl_20_1_689615895 tag=TAG20090615T155815 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:02

Finished backup at 15-JUN-09

Starting backup at 15-JUN-09

channel ch00: starting full datafile backupset

channel ch00: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ch00: starting piece 1 at 15-JUN-09

channel ch00: finished piece 1 at 15-JUN-09

piece handle=/rman/spfile_21_1_689615904 tag=TAG20090615T155823 comment=NONE

channel ch00: backup set complete, elapsed time: 00:00:01

Finished backup at 15-JUN-09

released channel: ch00

RMAN> exit

Recovery Manager complete.

]> date

Mon Jun 15 15:58:44 CST 2009

]>

]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 15 16:03:17 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

> startup nomount

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1218292 bytes

Variable Size 88082700 bytes

Database Buffers 71303168 bytes

Redo Buffers 7168000 bytes

> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

]>

]> rman target / catalog

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jun 15 16:07:45 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: orcl (not mounted)

connected to recovery catalog database

RMAN>

RMAN> run{

2> ALLOCATE CHANNEL t1 TYPE disk;

3> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';

4> sql 'alter session set NLS_LANGUAGE=American';

5> set until time='2009-06-15 15:49:00';

6> restore controlfile;

7> release channel t1;

8> }

allocated channel: t1

channel t1: sid=156 devtype=DISK

sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

sql statement: alter session set NLS_LANGUAGE=American

executing command: SET until clause

Starting restore at 15-JUN-09

channel t1: starting datafile backupset restore

channel t1: restoring control file

channel t1: reading from backup piece /rman/cntrl_14_1_689615270

channel t1: restored backup piece 1

piece handle=/rman/cntrl_14_1_689615270 tag=TAG20090615T154750

channel t1: restore complete, elapsed time: 00:00:04

output filename=/oracle/oradata/orcl/control01.ctl

output filename=/oracle/oradata/orcl/control02.ctl

output filename=/oracle/oradata/orcl/control03.ctl

Finished restore at 15-JUN-09

released channel: t1

RMAN>

RMAN> alter database mount;

database mounted

RMAN> run{

2> ALLOCATE CHANNEL t1 TYPE disk;

3> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';

sql 'alter session set NLS_LANGUAGE=American';

4> set until time='2009-06-15 15:49:00';

5> 6> restore database;

restore archivelog all;

7> 8> release channel t1;

9> }

allocated channel: t1

channel t1: sid=156 devtype=DISK

sql statement: alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

sql statement: alter session set NLS_LANGUAGE=American

executing command: SET until clause

Starting restore at 15-JUN-09

Starting implicit crosscheck backup at 15-JUN-09

Crosschecked 5 objects

Finished implicit crosscheck backup at 15-JUN-09

Starting implicit crosscheck copy at 15-JUN-09

Finished implicit crosscheck copy at 15-JUN-09

searching for all files in the recovery area

cataloging files...

no files cataloged

channel t1: starting datafile backupset restore

channel t1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oracle/oradata/orcl/system01.dbf

restoring datafile 00002 to /oracle/oradata/orcl/undotbs01.dbf

restoring datafile 00003 to /oracle/oradata/orcl/sysaux01.dbf

restoring datafile 00004 to /oracle/oradata/orcl/users01.dbf

restoring datafile 00005 to /oracle/oradata/orcl/example01.dbf

channel t1: reading from backup piece /rman/bk_9_1_689614839

channel t1: restored backup piece 1

piece handle=/rman/bk_9_1_689614839 tag=TAG20090615T154036

channel t1: restore complete, elapsed time: 00:02:16

Finished restore at 15-JUN-09

Starting restore at 15-JUN-09

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=3

channel t1: restoring archive log

archive log thread=1 sequence=4

channel t1: restoring archive log

archive log thread=1 sequence=5

channel t1: restoring archive log

archive log thread=1 sequence=6

channel t1: restoring archive log

archive log thread=1 sequence=7

channel t1: restoring archive log

archive log thread=1 sequence=8

channel t1: restoring archive log

archive log thread=1 sequence=9

channel t1: restoring archive log

archive log thread=1 sequence=10

channel t1: reading from backup piece /rman/archvelog_11_1_689615084

channel t1: restored backup piece 1

piece handle=/rman/archvelog_11_1_689615084 tag=TAG20090615T154439

channel t1: restore complete, elapsed time: 00:00:46

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=11

channel t1: restoring archive log

archive log thread=1 sequence=12

channel t1: restoring archive log

archive log thread=1 sequence=13

channel t1: restoring archive log

archive log thread=1 sequence=14

channel t1: restoring archive log

archive log thread=1 sequence=15

channel t1: restoring archive log

archive log thread=1 sequence=16

channel t1: restoring archive log

archive log thread=1 sequence=17

channel t1: restoring archive log

archive log thread=1 sequence=18

channel t1: restoring archive log

archive log thread=1 sequence=19

channel t1: restoring archive log

archive log thread=1 sequence=20

channel t1: reading from backup piece /rman/archvelog_12_1_689615185

channel t1: restored backup piece 1

piece handle=/rman/archvelog_12_1_689615185 tag=TAG20090615T154439

channel t1: restore complete, elapsed time: 00:00:45

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=21

channel t1: restoring archive log

archive log thread=1 sequence=22

channel t1: reading from backup piece /rman/archvelog_13_1_689615255

channel t1: restored backup piece 1

piece handle=/rman/archvelog_13_1_689615255 tag=TAG20090615T154439

channel t1: restore complete, elapsed time: 00:00:03

channel t1: starting archive log restore to default destination

channel t1: restoring archive log

archive log thread=1 sequence=23

channel t1: reading from backup piece /rman/archvelog_19_1_689615883

channel t1: restored backup piece 1

piece handle=/rman/archvelog_19_1_689615883 tag=TAG20090615T155802

channel t1: restore complete, elapsed time: 00:00:01

Finished restore at 15-JUN-09

released channel: t1

RMAN>

RMAN> exit

Recovery Manager complete.

]> sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 15 16:49:29 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

idle> alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"

2 ;

Session altered.

idle> alter session set NLS_LANGUAGE=American;

Session altered.

idle> recover database using backup controlfile until time '2009-06-15 15:49:00';

ORA-00279: change 704477 generated at 06/15/2009 15:40:40 needed for thread 1

ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_21_%u_.arc

ORA-00280: change 704477 for thread 1 is in sequence #21

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 704589 generated at 06/15/2009 15:44:18 needed for thread 1

ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_22_%u_.arc

ORA-00280: change 704589 for thread 1 is in sequence #22

ORA-00278: log file

'/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_21_53d0wd9m_.arc' no longer needed

for this recovery

ORA-00279: change 704631 generated at 06/15/2009 15:44:31 needed for thread 1

ORA-00289: suggestion : /oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_23_%u_.arc

ORA-00280: change 704631 for thread 1 is in sequence #23

ORA-00278: log file

'/oracle/flash_recovery_area/ORCL/archivelog/2009_06_15/o1_mf_1_22_53d0wdoj_.arc' no longer needed

for this recovery

Log applied.

Media recovery complete.

idle>

idle> alter database open resetlogs;

Database altered.

idle>

idle> col name format a60

idle> select file#,name from v$datafile;

FILE# NAME

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

1 /oracle/oradata/orcl/system01.dbf

2 /oracle/oradata/orcl/undotbs01.dbf

3 /oracle/oradata/orcl/sysaux01.dbf

4 /oracle/oradata/orcl/users01.dbf

5 /oracle/oradata/orcl/example01.dbf

idle>[@more@]

weixin_39931390
关注
rman时间点恢复（until time）完整例子
csdn_0706的博客
07-10 984
一、步骤：1、一次全备2、记录时间，增加表空间，查询新增加的数据文件3、再次全备4、执行时间点恢复，恢复到2记录的时间之前5、查询数据文件，发现2增加的数据文件不存在，时间点恢复成功。二、操作日志：oracle@oracle[/...
oracle rman部分恢复,Oracle中使用RMAN备份及一些恢复方法
weixin_35983968的博客
04-05 884
使用RMAN备份并恢复Backup 备份命令生成 Backup sets (备份集合)，以 oracle 专有的格式保存，由一个完全的所有的备份片集合构成，构成一个完全备份或增量备份。1.1.1 BACKUP 备份命令选项设置标记(TAG)RMAN> backup database tag='test backup';限制备份集大小RMAN> backup database max...
oracle数据表按时间恢复,RMAN基于时间点恢复Oracle数据库
weixin_33251169的博客
04-03 296
1 查DBIDSQL> select dbid fromv$database;DBID----------15227214702 关闭数据库SQL> shutdown immediate3 进rman环境> rman target /4 设置DBIDRMAN> set DBID=15227214705 数据库启动到未挂载状态RMAN> startup nomount6...
Oracle恢复（七）------基于时间的恢复
Cages的专栏
04-10 156
首先有备份 其次知道自己想要恢复到的历史时间 拷贝备份的所有数据文件回来， startup mount;启动到mount状态 recover database until time'2012-04-10:16:43:01';//穿越到今天 呵呵 因为10号发工资，所以喜欢穿越到10号 Mediarecovery complete. 恢复ok，这个不要一个alter databa...
oracle until,recover database until time
weixin_29130369的博客
04-16 623
recover database until time using backup controlfile is not working it is taking current log file onlyto recover upto perticular time what to doi used recover database using backup controlfile until t...
oracle rman介质恢复数据库到历史上的某个时间点（不完全恢复的一种）
u011529483的博客
04-21 2650
oracle rman介质恢复数据库到历史上的某个时间点（不完全恢复的一种），比如恢复数据库到昨天上午9点10分的状态
oracle指定tag恢复,Oracle RMAN的备份与恢复命令详解
weixin_39813200的博客
04-02 1123
4.3 Copy 镜像拷贝与恢复Copy镜像拷贝命令可以创建数据库数据文件、归档重做日志或者控制文件的精确副本。 RMAN 副本与这些文件的区别仅在于名称和(或)位置的区别。功能相当于用户管理的备份恢复中的热备份。备份副本的好处是恢复比较快，恢复时可以不用拷贝，指定新位置即可。Copy镜像拷贝至少要在mount 状态下运行。Copy镜像拷贝可作为增量备份的 Level 0Oracle10g开始，允...
oracle跨平台备份恢复,Rman_异地、跨平台、跨版本的恢复总结及案例
weixin_29973493的博客
04-07 1444
结论：1.Rman可以跨平台，网上有资料基于ID 413586.1(metalink上有),但是还是少用rman来进行跨平台操作。2.Rman可以跨版本，但是一般只能从低到高，且要执行catupgrd.sql。不能从高到低，唯一成功的是低版本升级到高版本后备份可以恢复到同样的低版本跨平台的实例：Solaris上的9i的DB通过rman备份后恢复到RHEL5.4上的11.2.0.1跨版本的实例：RM...
ORACLE 备份恢复之RMAN详解
DoubleJing的博客
06-13 3478
一、连接方式 (一)、连接本地数据库 [oracle@oracle ~]$ rman target / (二)、连接远程数据库 [oracle@oracle ~]$ rman target sys/oracle@orcl 二、基本指令 (一)、执行 SQL 语句 RMAN>SQL ‘ALTER SYSTEM SWITCH LOGFILE’; (二)、RMAN 默认配置 1．显示 RMAN 默认配置 RMAN>SHOW ALL; 2．RMAN 默认配置详解 using target dat
Oracle下rman备份和还原到数据库任意一个时间点
weixin_30799995的博客
06-25 959
Rman备份为物理备份，启用rman备份必须开启数据库归档，开启归档后相当于给数据库加了一层双保险。Rman备份主要备份数据库的数据文件，控制文件，归档日志。 RMAN 备份 一、检查数据库是否启用归档状态。服务器上在Cmd下用sysdba身份登录。查询数据库是否启用归档模式。 Sqlplus / as sysdba Select dbid,name...
RMAN恢復数据库到指定時間點
05-09
RMAN恢復数据库到指定時間點，本文详细描述了如何通过RMAN将数据库恢复的指定时间点的流程及方法
oracle，RMAN恢复数据库数据到指定时间，RMAN不完全恢复shell脚本
搬砖的鱼的博客
11-17 578
oracle，RMAN恢复数据库数据到指定时间，RMAN不完全恢复 RMAN定时备份配置，shell脚本见https://blog.csdn.net/weixin_43614067/article/details/109647639 su - oracle sqlplus / as sysdba #设置时间格式 SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'; #查看数据库原型（当前原型为2） SQL> SELECT
没有设置oracle的环境变量.recover until time会报文字上出错ORA-01861: literal does not match format string...
csdn20142014的博客
09-04 281
没有设置oracle的环境变量.recover until time会报字符出错su - oracleexport NLS_LANG=export NLS_DATE_FORMAT=rman target /;run{set un...
oracle迁移时间点恢复,rman迁移时间点恢复
weixin_39946274的博客
04-12 160
本来今天请假休息了，晚上8点吃饭的时候，主管打来电话让我恢复一个数据库，中午12点的时候开发人员不当操作，其中一个schema用来接收其他工厂的的数据，搞乱套了。~让我恢复到今天中午12点左右的数据，但是其他schema没问题，只恢复这一个schema，这个数据库1.7T大小，突然想到这套服务器是RAC，1节点数据泵中午12点备份，2节点是rman晚上8点备份，吃完饭马上去找1节点备份，-_-||...
RMAN中使用until time子句对Non-CDB中的表执行按时间点恢复
01-11 344
在RMAN中使用until time子句对Non-CDB中的表执行按时间点恢复操作步骤如下 1.对整个Non-CDB(orcl)生成RMAN备份 RMAN> backup as compressed back...
oracle RMAN不完全恢复database到指定时间点（简单模拟）
firefly的专栏
03-04 941
测试database不完全恢复到2012-03-01 cmd>sqlplus / as sysdba; SQL>shutdown immediate SQL>alter database archivelog; SQL>conn squirrel/squirrel; SQL>CREATE TABLE a(id number(10) not null primary key, name
Oracle数据库的不完全恢复：Recover Database Until
first10010的专栏
10-20 8868
什么叫“不完全”恢复呢？不是很理解。Recover Database有3种基本命令形式：Recover Database Until TimeRecover Database Until Change SCNRecover Database Until Cancel基于时间和变化的恢复基本相同，不同之处，还需要进一步理解http://www.eygle.com/archives
oracle全库基于时间点的恢复,使用RMAN进行基于时间点的不完全恢复
weixin_36090805的博客
04-09 131
[oracle@stat ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'[oracle@stat ~]$ rman target /Recovery Manager: Release 10.2.0.2.0 - Production on Thu Sep 14 22:50:22 2006Copyright (c) 1982, 2005, Orac...
recover database until time
cqhiabc50405的博客
04-19 538
1 建立测试表 [oracle@node1 ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.1.0 - Production on Tue Apr 19 21:46:...
Oracle 11g RMAN 备份与恢复指南
5. **恢复策略**：RMAN提供多种恢复策略，如不完全恢复、时间点恢复等，以满足不同场景下的恢复需求。在发生数据丢失后，可以使用RMAN来恢复到特定的时间点或状态。 6. **归档日志管理**：RMAN能够管理归档日志，这...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值