怎么将oracle数据库脱机,Oracle学习系列—数据库备份—脱机备份

Microsoft Windows [Version

5.2.3790]

(C) Copyright 1985-2003

Microsoft Corp.

C:/Documents and Settings/Administrator>sqlplus

/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 26 01:23:22 2007

Copyright (c) 1982, 2002,

Oracle Corporation.All rights

reserved.

SQL> connect

sys/change_on_install as sysdba;

Connected.

SQL> select file_name

from dba_data_files;

FILE_NAME

--------------------------------------------------------------------

C:/ORACLE/ORADATA/WBQ/SYSTEM01.DBF

C:/ORACLE/ORADATA/WBQ/UNDOTBS01.DBF

C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE01.DBF

C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE02.DBF

C:/ORACLE/ORADATA/WBQ/MYDATABLESPACE03.DBF

SQL> select * from

v$logfile;

GROUP# STATUSTYPEMEMBER

---------- ------- -------

------------------------------------------

1ONLINE C:/ORACLE/ORADATA/WBQ/REDO01.LOG

2ONLINE C:/ORACLE/ORADATA/WBQ/REDO02.LOG

3ONLINE C:/ORACLE/ORADATA/WBQ/REDO03.LOG

SQL> select * from

v$controlfile;

STATUS NAME

---------------------------------------------------------------------

C:/ORACLE/ORADATA/WBQ/CONTROL01.CTL

C:/ORACLE/ORADATA/WBQ/CONTROL02.CTL

C:/ORACLE/ORADATA/WBQ/CONTROL03.CTL

SQL>shutdown immediate

Datebase clodes.

Datebase dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle9i Enterprise Edition

Release 9.2.0.1.0 - Production

With the Partitioning, OLAP

and Oracle Data Mining options

JServer Release 9.2.0.1.0 -

Production

C:/Documents and Settings/Administrator>cd/

C:/>cd C:/oracle/oradata/wbq

C:/oracle/oradata/wbq>md backup

C:/oracle/oradata/wbq>copy

control01.ctl backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

control02.ctl backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

control03.ctl backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy REDO01.LOG backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy REDO02.LOG backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy REDO03.LOG backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy SYSTEM01.DBF backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

UNDOTBS01.DBF backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

MYDATABLESPACE01.DBF backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

MYDATABLESPACE02.DBF backup

1 file(s) copied.

C:/oracle/oradata/wbq>copy

MYDATABLESPACE03.DBF backup

1 file(s) copied.

C:/oracle/oradata/wbq>sqlplus

/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 26 01:37:07 2007

Copyright (c) 1982, 2002,

Oracle Corporation.All rights

reserved.

SQL> connect

sys/change_on_install as sysdba;

Connected to an idle

instance.

SQL> startup

ORACLE instance started.

Total System Global

Area105978600 bytes

Fixed Size453352 bytes

Variable Size79691776 bytes

Database Buffers25165824 bytes

Redo Buffers667648 bytes

Database mounted.

Database opened.

SQL>