cold back up an oracle database

最新推荐文章于 2025-11-27 13:57:04 发布

最新推荐文章于 2025-11-27 13:57:04 发布 · 117 阅读

文章标签：

#数据库

Oracle 专栏收录该内容

8 篇文章

订阅专栏

本文详细介绍了如何使用OracleDBA进行11g数据库的冷备份操作，包括设置SID、关闭数据库、备份文件到其他位置、启动数据库等步骤。

Refrence:

search "Oracle DBA Justin - How to backup an 11g Oracle database cold" on YouTube
http://www.youtube.com/watch?v=iH0E-g9qj90&feature=relmfu

"Cold Backup" means to shutdown the Oracle database first and then backup the database files.

1. set oracle sid
export ORACLE_SID=AWCC

2. shutdown the database AWCC
sqlplus / as sysdba
SQL>shutdown;

3. backup (copy the database files of AWCC to another location/medium)

4. start the database
SQL>startup;

To restore, just shutdown the database and copy back all the files to the database's data file directory and restart the database.

Warning: this is only the record of the steps in the video, not tested yet.