Shulou(Shulou.com)06/01 Report--

C:\ Users\ Administrator > rman target /

Recovery Manager: Release 11.2.0.1.0-Production on Monday August 15 23:46:24 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connect to the target database: ORCL (DBID=1275817864)

RMAN >

RMAN >

RMAN > backup database

Start backup on 15-August-11 to replace the channel assigned by the recovery directory with the target database control file: ORA_DISK_1 channel ORA_DISK_1: SID=143 device type = DISKRMAN-06169: file header 7 unable to read data file error reason 1RMAN-00571: = = RMAN-00569: = ERROR MESSAGE STACK FOLLOWS = RMAN-00571: = = RMAN-03002: backup command (at 23:46:35 on 08ORA_DISK_1 15ther 2011) RMAN-06056: unable to access data file 7

SQL > select file#,name from v$datafile

FILE# NAME- 1 D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSTEM01.DBF2 D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSAUX01.DBF3 D:\ APP\ ADMINISTRATOR \ ORADATA\ ORCL\ TEBS.DBF4 D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ USERS01.DBF5 D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ UNDO.DATA16 D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ UNDO.DATA27 D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ MISSING000078 D:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ MISSING00008

Eight rows have been selected.

SQL > select TS#,name from v$tablespace

TS# NAME- 0 SYSTEM1 SYSAUX7 TEBS4 USERS3 TEMP6 PSAPUNDO18 GGX9 GGX1

Eight rows have been selected.

SQL > SQL > col file_name for a100SQL > col tablespace_name for a100SQL > select file_name,tablespace_name from dba_data_files order by file_name

FILE_NAME TABLESPACE_NAME-- -D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSAUX01.DBF SYSAUXD:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSTEM01.DBF SYSTEMD:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ TEBS.DBF TEBSD:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ UNDO.DATA1 PSAPUNDO1D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL \ UNDO.DATA2 PSAPUNDO1D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ USERS01.DBF USERSD:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ MISSING00007 GGXD:\ APP\ ADMINISTRATOR\ PRODUCT\ 11.2.0\ DBHOME_1\ DATABASE\ MISSING00008 GGX1

Eight rows have been selected.

Error in line 1 of SQL > drop tablespace ggx;drop tablespace ggx*: ORA-01549: the table space is not empty, please use the INCLUDING CONTENTS option

SQL > drop tablespace ggx including contents

The tablespace was deleted.

SQL > drop tablespace ggx1

The tablespace was deleted.

RMAN > backup database

Start backup on 16-August-11 to replace the channel assigned by the recovery directory with the target database control file: ORA_DISK_1 channel ORA_DISK_1: SID=145 device type = DISK channel ORA_DISK_1: starting all data files backup set channel ORA_DISK_1: specifying data files in backup set input data file: file number = 00005 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ UNDO.DATA1 input data file: file number = 00001 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSTEM01.DBF input data file: file number = 00002 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ SYSAUX01.DBF input data file: file number = 00004 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ USERS01.DBF input data file: file number = 00003 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ TEBS.DBF input number According to file: file number = 00006 name = D:\ APP\ ADMINISTRATOR\ ORADATA\ ORCL\ UNDO.DATA2 channel ORA_DISK_1: starting segment 1 on 16-August-11 channel ORA_DISK_1: completed segment 1 on 16-August-11 segment handle = D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ ORCL\ BACKUPSET\ 2011 / 08 / 16\ O1_MF_NNNDF_TAG20110816T000346_74LJV49J_.BKP tag = TAG20110816T000346 comment = NONE channel ORA_DISK_1: backup set is complete Time elapsed: 00:09:16 channel ORA_DISK_1: starting all data files backup set channel ORA_DISK_1: data file backup set in the specified backup set including the current control file channel ORA_DISK_1: starting segment 1 from 16 to August to 11 channel ORA_DISK_1: completed segment 1 from 16 to August to 11 handle = D:\ APP\ ADMINISTRATOR\ FLASH_RECOVERY_AREA\ ORCL\ BACKUPSET\ 2011 / 08 / 16\ O1_MF_NCNNF_TAG20110816T000346_74LKDHJL_.BKP tag = TAG20110816T000346 comment = NONE channel ORA_DISK_1: backup set completed Elapsed time: 00:00:01 completion of backup 16-August-11

RMAN >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.