冷备份----不完全恢复cancel

最新推荐文章于 2024-12-06 11:07:16 发布

原创最新推荐文章于 2024-12-06 11:07:16 发布 · 561 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#thread #database #sql #oracle #数据库 #insert

备份与恢复专栏收录该内容

26 篇文章

订阅专栏

1.冷备份所有文件

SQL> shutdown immediate

[oracle@asm demo1]$ cp * /u01/ubackup/cold/

2.插入数据，并提交

SQL> insert into tt values(8,'loters');

1 row created.

SQL> commit;

SQL>alter system switch logfile;

SQL> alter system checkpoint;

SQL> insert into tt values(9,'eclipse');

1 row created.

SQL> commit;

Commit complete.

3.备份控制文件

SQL> alter database backup controlfile to trace as '/tmp/c.sql';

4.删除所有文件

[oracle@asm demo1]$ rm -f *

5.关闭数据库

SQL> shutdown abort

6.还原所有数据文件

[oracle@asm demo1]$ cp /u01/ubackup/cold/*.dbf .

7.修改备份控制文件，并生成控制文件

SQL> @c1.sql

8.恢复数据库

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 706201 generated at 02/02/2012 13:37:23 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/DEMO1/archivelog/2012_02_02/o1_mf_1_1_%u_.ar
c
ORA-00280: change 706201 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: change 706681 generated at 02/02/2012 13:43:33 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/flash_recovery_area/DEMO1/archivelog/2012_02_02/o1_mf_1_2_%u_.ar
c
ORA-00280: change 706681 for thread 1 is in sequence #2
ORA-00278: log file
'/u01/app/oracle/flash_recovery_area/DEMO1/archivelog/2012_02_02/o1_mf_1_1_7ln8n
666_.arc' no longer needed for this recovery

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.

9.打开数据库

SQL> alter database open resetlogs;

10.重建临时表空间

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oracle/oradata/demo1/temp02.dbf' SIZE 104857600 REUSE AUTOEXTEND OFF;