Oracle 最简单的RMAN配置、备份及恢复(2) - 删除数据库
博客首页 » Oracle 最简单的RMAN配置、备份及恢复(2) - 删除数据库
发布于 08 Jun 2014 03:37
标签 blog
Oracle无疑是一个复杂的软件,不过它的基本使用远没有这么复杂。其中RMAN是Oracle的备份软件。在上一篇文章中介绍了它的最简单的配置。为了进一步介绍恢复,我们先删除数据库。rman提供了一个干净地删除数据库的方法,使用方法如下。(注意这个方法会完全删除数据库,生产环境上慎用!)
删除数据库
[scripts oracle@test03] sqlplus "/ as sysdba" SQL*Plus: Release 10.2.0.4.0 - Production on Wed Sep 4 16:50:01 2013 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount exclusive; ORACLE instance started. Total System Global Area 2097152000 bytes Fixed Size 2085224 bytes Variable Size 553651864 bytes Database Buffers 1526726656 bytes Redo Buffers 14688256 bytes Database mounted. SQL> alter system enable restricted session; System altered. SQL> quit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [scripts oracle@test03] rman target / nocatalog Recovery Manager: Release 10.2.0.4.0 - Production on Wed Sep 4 16:51:40 2013 Copyright (c) 1982, 2007, Oracle. All rights reserved. connected to target database: test02t (DBID=2513594778, not open) using target database control file instead of recovery catalog RMAN> drop database; database name is "test02t" and DBID is 2513594778 Do you really want to drop the database (enter YES or NO)? yes database dropped RMAN> quit
删除SPFILE
rm $ORACLE_HOME/dbs/sp$ORACLE_SID.ora
本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。
系列文章
文章列表
- Oracle 最简单的RMAN配置、备份及恢复(2) - 删除数据库
这篇文章对你有帮助吗,投个票吧?
page revision: 0, last edited: 08 Jun 2014 03:37
留下你的评论