《Oracle 11g数据库编程入门与实战》习题答案 第十一章

第十一章 简单备份和恢复

1．ABCD

2．AD

3．CD

4．C

5．C

6．D

7．Bc

8．B

9．C

10．

SQL> Conn sys/oracle as sysdba

SQL> SELECT instance_name, status FROM v$instance;

SQL> SELECT name FROM v$bgprocess WHERE paddr != '00';

SQL> SELECT name, log_mode, current_scn FROM v$database;

SQL> SELECT tablespace_name, status

FROM dba_tablespaces;

SQL> SELECT file_name FROM dba_data_files

WHERE tablespace_name = 'SYSTEM';

SQL> SELECT name, bytes, checkpoint_change#

FROM v$datafile;

SQL> SELECT group#, members, status, bytes FROM v$log;

SQL> SELECT group#, member, status FROM v$logfile;

SQL> SELECT name FROM v$controlfile;

11．

SQL> Conn sys/oracle as sysdba

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP MOUNT

SQL> ALTER DATABASE ARCHIVELOG;

SQL> ALTER DATABASE OPEN;

SQL> ARCHIVE LOG LIST;

12．

SQL> REPORT SCHEMA

SQL> REPORT NEED BACKUP DAYS 3;

SQL> BACKUP DATABASE;

13．

SQL> LIST BACKUP OF TABLESPACE data01;

SQL> LIST BACKUP

SQL> LIST COPY OF DATABASE;

SQL> LIST COPY OF ARCHIVELOG ALL;

14．

SQL> BACKUP TABLESPACE data01

FORMAT ‘d:databak%N_%s.bak’;

SQL> LIST BACKUP OF TABLESPACE data01;

15．

SQL> CREATE TABLE temp (id NUMBER) TABLESPACE data01;

SQL> DECLARE

V_count NUMBER := 1;

BEGIN

WHILE v_count < 10 Loop

INSERT INTO temp VALUES(v_count);

V_count := v_count + 1;

End LOOP;

COMMIT;

End;

--模拟表空间数据文件损坏：

SQL> SHUTDOWN IMMEDIATE

SQL> HOST DEL ‘d:oradatadata01.dbf’

SQL> STARTUP

--恢复data01表空间：

SQL> Run{

Sql 'alter database datafile 4 offline';

Restore tablespace data01;

Recover tablespace data01;

Sql 'alter tablespace data01 online';

}

--检查：

SELECT * FROM temp;

16．

SQL> REPORT SCHEMA;

SQL> COPY DATAFILE 5 TO ‘d:databakdf_5.bak’

17．

SQL> conn system/oracle

SQL> CREATE DIRECTORY dump AS 'd:dump';

SQL> GRANT READ,WRITE ON DIRECTORY dump TO scott;

18．

D:> expdp scott/tiger directory=dump

Dumpfile=scott_tab.dmp logfile=tab.log

tables=emp, dept

D:> expdp scott/tiger Directory=dump

Dumpfile=scott_schema.dmp logfile= scott_schema.log

schemas=scott

D:> expdp system/oracle directory=dump

dumpfile=tb_users.dmp logfile=tb_users.log

tablespaces=users

D:> expdp system/oracle directory=dump

dumpfile=orcl.dmp logfile=orcl.log full=y

19．

D:> impdp scott/tiger directory=dump

dumpfile=scott_tab.dmp tables=dept,emp

D:> impdp scott/tiger directory=dump

dumpfile=schema_schema.dmp schemas=scott

D:> impdp system/oracle directory=dump

dumpfile=tb_users.dmp tablespaces=users

D:> impdp system/oracle directory=dump

dumpfile=orcl.dmp full=y

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11168/viewspace-1035535/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11168/viewspace-1035535/