首页 » ORACLE 9i-23c » 1z0-042 259题实验

1z0-042 259题实验

259.
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.)
A. SYSAUX
B. TOOLS
C. UNDO
D. INDEX
E. SYSTEM
F. USERS
G. TEMP

答案e肯定对那a和c会是哪个呢,通过下面的实验你就明白了
步骤
1,rman bakcup database
2,database open,os rm sysaux tablespace file
3,recovery sysaux
4,database open,os rm undo tablespace file
5,recovery undo try
6,database mount,os rm undo tablespace file
6,recovery undo retry

RMAN> backup database;


Recovery Manager complete.
[oracle@orazhang ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 14 12:03:24 2011

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

sys@ORCL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /backup
Oldest online log sequence     13
Next log sequence to archive   16
Current log sequence           16

sys@ORCL> desc dba_data_files;
 Name                                                        Null?    Type
 ----------------------------------------------------- -------- --------------------------------------------------------
 FILE_NAME                                                            VARCHAR2(513)
 FILE_ID                                                              NUMBER
 TABLESPACE_NAME                                                       VARCHAR2(30)
 BYTES                                                                 NUMBER
 BLOCKS                                                                NUMBER
 STATUS                                                                VARCHAR2(9)
 RELATIVE_FNO                                                          NUMBER
 AUTOEXTENSIBLE                                                       VARCHAR2(3)
 MAXBYTES                                                               NUMBER
 MAXBLOCKS                                                              NUMBER
 INCREMENT_BY                                                           NUMBER
 USER_BYTES                                                            NUMBER
 USER_BLOCKS                                                             NUMBER
 ONLINE_STATUS                                                          VARCHAR2(7)

sys@ORCL> col file_name for a50
sys@ORCL> col tablespace_name for a20
sys@ORCL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                                          TABLESPACE_NAME
-------------------------------------------------- --------------------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf UNDOTBS2
/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf      TT
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslog TBSLOGMNR
mn_6vdjocp1_.dbf

/u01/app/oracle/oradata/ORCL/datafile/tt.dbf       TT
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_exampl EXAMPLE
e_6cgckxc7_.dbf

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_ USERS
6cgckxds_.dbf

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux SYSAUX
_6cgckx9p_.dbf

/u01/app/oracle/oradata/ORCL/datafile/test.dbf     TEST
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system SYSTEM
_6cgckx95_.dbf

/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf SMAILTBS

10 rows selected.

sys@ORCL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

sys@ORCL> col file_name for a70

sys@ORCL> col file_name for a70
sys@ORCL> select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                              TABLESPACE_NAME
---------------------------------------------------------------------- --------------------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf                     UNDOTBS2
/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf                          TT
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf     TBSLOGMNR
/u01/app/oracle/oradata/ORCL/datafile/tt.dbf                           TT
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf      EXAMPLE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf        USERS
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf       SYSAUX
/u01/app/oracle/oradata/ORCL/datafile/test.dbf                         TEST
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf       SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf                     SMAILTBS

10 rows selected.

sys@ORCL> ! rm /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf

sys@ORCL> alter system checkpoint;

System altered.

sys@ORCL> alter tablespace sysaux offline;
alter tablespace sysaux offline
*
ERROR at line 1:
ORA-01191: file 3 is already offline - cannot do a normal offline
ORA-01110: data file 3: '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf'

sys@ORCL> select file_name,tablespace_name,online_status from dba_data_files;

FILE_NAME                                                              TABLESPACE_NAME      ONLINE_
---------------------------------------------------------------------- -------------------- -------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf                     UNDOTBS2             ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf                          TT                   ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf     TBSLOGMNR            ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt.dbf                           TT                   ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf      EXAMPLE              ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf        USERS                ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf       SYSAUX               RECOVER
/u01/app/oracle/oradata/ORCL/datafile/test.dbf                         TEST                 ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf       SYSTEM               SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf                     SMAILTBS             ONLINE

10 rows selected.

[oracle@orazhang ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on 星期四 7月 14 12:12:10 2011

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

connected to target database: ORCL (DBID=1246063822)

RMAN> restore tablespace sysaux;

Starting restore at 2011-07-14 12:12:40
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_6cgckx9p_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1 tag=TAG20110714T120128
channel ORA_DISK_1: restore complete, elapsed time: 00:00:56
Finished restore at 2011-07-14 12:13:38

RMAN> recover tablespace sysaux;

Starting recover at 2011-07-14 13:00:15
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:02

Finished recover at 2011-07-14 13:00:17

RMAN> exit


Recovery Manager complete.
[oracle@orazhang ~]$ ora

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 14 13:00:25 2011

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

sys@ORCL> col file_name for a80
sys@ORCL> select file_name,tablespace_name,online_status from dba_data_files;

FILE_NAME                                                                        TABLESPACE_NAME                ONLINE_
-------------------------------------------------------------------------------- ------------------------------ -------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf                               UNDOTBS2                       ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf                                    TT                             ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf               TBSLOGMNR                      ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt.dbf                                     TT                             ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf                EXAMPLE                        ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf                  USERS                          ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf                 SYSAUX                         OFFLINE
/u01/app/oracle/oradata/ORCL/datafile/test.dbf                                   TEST                           ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf                 SYSTEM                         SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf                               SMAILTBS                       ONLINE

10 rows selected.


sys@ORCL> alter tablespace sysaux online;

Tablespace altered.

sys@ORCL> select file_name,tablespace_name,online_status from dba_data_files;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
TABLESPACE_NAME                ONLINE_
------------------------------ -------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf
UNDOTBS2                       ONLINE

/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf
TT                             ONLINE

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf
TBSLOGMNR                      ONLINE

/u01/app/oracle/oradata/ORCL/datafile/tt.dbf
TT                             ONLINE

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf
EXAMPLE                        ONLINE

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf
USERS                          ONLINE

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf
SYSAUX                         OFFLINE

/u01/app/oracle/oradata/ORCL/datafile/test.dbf
TEST                           ONLINE

/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf
SYSTEM                         SYSTEM

/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf
SMAILTBS                       ONLINE


10 rows selected.

sys@ORCL> ! rm /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf

sys@ORCL> alter system checkpoint;

System altered.

sys@ORCL> select file_name,tablespace_name,online_status from dba_data_files;

FILE_NAME                                                                        TABLESPACE_NAME                ONLINE_
-------------------------------------------------------------------------------- ------------------------------ -------
/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf                               UNDOTBS2                       ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt1.dbf                                    TT                             ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_tbslogmn_6vdjocp1_.dbf               TBSLOGMNR                      ONLINE
/u01/app/oracle/oradata/ORCL/datafile/tt.dbf                                     TT                             ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_6cgckxc7_.dbf                EXAMPLE                        ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_6cgckxds_.dbf                  USERS                          ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_71wv5vkw_.dbf                 SYSAUX                         ONLINE
/u01/app/oracle/oradata/ORCL/datafile/test.dbf                                   TEST                           ONLINE
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_6cgckx95_.dbf                 SYSTEM                         SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/smailtbs.dbf                               SMAILTBS                       ONLINE

10 rows selected.

sys@ORCL> alter tablespace undotbs2 offline;
alter tablespace undotbs2 offline
*
ERROR at line 1:
ORA-30042: Cannot offline the undo tablespace


sys@ORCL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

sys@ORCL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2
sys@ORCL> create table anbob.obj as select object_id from dba_objects;

Table created.

sys@ORCL> delete anbob.obj;
delete anbob.obj
             *
ERROR at line 1:
ORA-01116: error in opening database file 12
ORA-01110: data file 12: '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3


sys@ORCL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@orazhang ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on 星期四 7月 14 13:07:09 2011

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

connected to target database: ORCL (DBID=1246063822)

RMAN> restore tablespace undotbs2;

Starting restore at 2011-07-14 13:07:20
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00012 to /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/14/2011 13:07:21
ORA-19870: error reading backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1
ORA-19573: cannot obtain exclusive enqueue for datafile 12

RMAN> exit


Recovery Manager complete.
[oracle@orazhang ~]$ ora

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 14 13:08:16 2011

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

sys@ORCL> shutdown immediate
ORA-01116: error in opening database file 12
ORA-01110: data file 12: '/u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
sys@ORCL> shutdown abort
ORACLE instance shut down.
sys@ORCL> startup mount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  1219184 bytes
Variable Size             385877392 bytes
Database Buffers          855638016 bytes
Redo Buffers               15556608 bytes
Database mounted.
sys@ORCL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@orazhang ~]$ rman target/

Recovery Manager: Release 10.2.0.1.0 - Production on 星期四 7月 14 13:09:15 2011

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

connected to target database: ORCL (DBID=1246063822, not open)

RMAN> restore tablespace undotbs2;

Starting restore at 2011-07-14 13:09:26
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00012 to /u01/app/oracle/oradata/ORCL/datafile/undotbs2.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/1tmhdpcp_1_1 tag=TAG20110714T120128
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 2011-07-14 13:09:52

RMAN> recover tablespace undotbs2;

Starting recover at 2011-07-14 13:10:06
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:03

Finished recover at 2011-07-14 13:10:09

RMAN> exit


Recovery Manager complete.
[oracle@orazhang ~]$ ora

SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 14 13:10:14 2011

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 database open;

Database altered.

idle> delete anbob.obj;

50741 rows deleted.

idle> commit;

Commit complete.
打赏

目前这篇文章有2条评论(Rss)评论关闭。

  1. Meta Capes | #1
    2011-12-21 at 02:42

    Thanks for the auspicious writeup. It in fact used to be a amusement account it. Look complicated to far brought agreeable from you! However, how could we keep in touch?

  2. backlink popularity | #2
    2011-11-19 at 14:04

    whats up http://www.anbob.com admin found your site via Google but it was hard to find and I see you could have more visitors because there are not so many comments yet. I have found site which offer to dramatically increase traffic to your site http://xrumerservice.org they claim they managed to get close to 1000 visitors/day using their services you could also get lot more targeted traffic from search engines as you have now. I used their services and got significantly more visitors to my blog. Hope this helps 🙂 They offer webmaster service bad seo backlink service backlinks seo Take care. Jay