Oracle 最简单的RMAN配置、备份及恢复(2) - 删除数据库

博客首页 » Oracle 最简单的RMAN配置、备份及恢复(2) - 删除数据库

发布于 08 Jun 2014 03:37
标签 blog
Oracle无疑是一个复杂的软件,不过它的基本使用远没有这么复杂。其中RMAN是Oracle的备份软件。在上一篇文章中介绍了它的最简单的配置。为了进一步介绍恢复,我们先删除数据库。rman提供了一个干净地删除数据库的方法,使用方法如下。(注意这个方法会完全删除数据库,生产环境上慎用!)

Table of Contents

删除数据库

[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) - 删除数据库

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License