[root@hp6200 tmp]# su - oracle
[oracle@hp6200 ~]$
[oracle@hp6200 ~]$
[oracle@hp6200 ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Mon May 5 10:37:03 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect /as sysdba
Connected.
SQL>
SQL>
SQL>
SQL> alter database datafile '/data1/soft/owprojects/TEST02003066518A.dbs' offline drop;
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 303633588 bytes
Fixed Size 451764 bytes
Variable Size 167772160 bytes
Database Buffers 134217728 bytes
Redo Buffers 1191936 bytes
Database mounted.
SQL> alter database datafile '/data1/soft/owprojects/TEST02003066518A.dbs' offline drop;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 15 - see DBWR trace file
ORA-01110: data file 15: '/data1/soft/owprojects/LIUWEIYONG0492543972A.dbs'
SQL> alter database datafile'/data1/soft/owprojects/LIUWEIYONG0492543972A.dbs' offline drop;
Database altered.
SQL> alter database open;
Database altered.
SQL> quit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
[oracle@hp6200 ~]$
分享到:
相关推荐
详细介绍如何正常删除Oracle 数据库表空间数据文件,OFFLINE和OFFLINE DROP的区别,OS级别删除了数据文件后的恢复,删除数据库表空间数据文件演示示例
Oracle Sales Offline Implementation Guide Release 11i Part No. B14390-03
SQL>alter database datafile 19 offline drop; 提示:数据库已更改。 循环使用最后两步,直到alter database open;后不再提示错误,出现“数据库已更改”。 然后接着输入即可 SQL>shutdown normal 提示:数据库...
Oracle Sales Offline User Guide Release 11i Part No. B14391-03
主要描述几种方式下得... svrmgrl> alter database datafile filename offline drop; svrmgrl> alter database open; svrmgrl> drop tablespace tablespace_name including contents; 重建表空间及所有对象.
ember-data-offline, 离线模式下,Ember数据是一个插件,它将Ember数据扩展到工作 Ember-data-offline Ember-data-offline是扩展ember数据以在脱机模式下工作的插件。它在本地存储( IndexedDB或者等价) 中缓存记录。...
ORACLE_表空间操作(有图有真相)
fhbngbejdkgjnfndbgnghn
su - oracle -c "exp system/manager full=y inctype=complete file=/oracle/export/db_comp$rq.dmp" 累计备份的SH文件:exp_cumu.sh rq=` date +"%m%d" ` su - oracle -c "exp system/manager full=y inctype=...
alter database datafile ‘datafile_name’ offline; recover datafile ‘datafile_name’ alter database datafile ‘datafile_name’ online; alter database open; 再次在Rman里面操作停起数据库(sql_...
8 Configuring HP Data Protector for Oracle Ch. 9 RMAN and Tivoli Storage Manager Ch. 10 Using the Recovery Catalog Ch. 11 RMAN Backups Ch. 12 RMAN Restore and Recovery Part III. Using RMAN ...
bbed工具(三个包,用于linux服务器)+bbed安装使用方法,详细的案例恢复:oracle非归档数据库offline的数据文件恢复。做完后可掌握bbed及故障恢复。值得推荐。
When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database ...
Android studio离线组件最新版本的 Google Maven 依赖项offline-gmaven-stable,文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Android studio离线组件offline-gmaven-stable.part1.rar ...
Android studio离线组件最新版本的 Google Maven 依赖项offline-gmaven-stable,文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Android studio离线组件offline-gmaven-stable.part1.rar ...
Sql Offline 手册Sql Offline 手册Sql Offline 手册Sql Offline 手册Sql Offline 手册Sql Offline 手册Sql Offline 手册Sql Offline 手册
Android studio离线组件最新版本的 Google Maven 依赖项offline-gmaven-stable,文件分割成 三个 压缩包,必须集齐 三个 文件后才能一起解压一起使用: Android studio离线组件offline-gmaven-stable.part1.rar ...
用Offline_Explorer下载整个网站的方法
IAR Offline License Generator v1.4 by unis用于IAR注册