D:\Script>cd d:\backup
D:\backup>md -12-17
D:\backup>sqlplus /nolog @D:\script\cold_backup.sql -12-17
SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 12月 17 10:50:55 2009
Copyright (c) 1982, 2004, Oracle.
已连接。
*** spooling to D:\script\cold_backup_command.sql
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\DUREX.ORA D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\PERFSTAT.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEST.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEST01.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEST02.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEST02_COPY.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\UNDOTBS01.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\USERS01.DBF D:\backup\
host copy D:\TEST\JERRY_UNDO.DBF D:\backup\
host copy D:\DISK3\REDO01A.LOG D:\backup\
host copy D:\DISK3\REDO02A.LOG D:\backup\
host copy D:\DISK3\REDO03A.LOG D:\backup\
host copy D:\DISK3\REDO04A.LOG D:\backup\
host copy D:\DISK3\REDO05A.LOG D:\backup\
host copy D:\DISK6\REDO01B.LOG D:\backup\
host copy D:\DISK6\REDO02B.LOG D:\backup\
host copy D:\DISK6\REDO03B.LOG D:\backup\
host copy D:\DISK6\REDO04B.LOG D:\backup\
host copy D:\DISK6\REDO05B.LOG D:\backup\
host copy D:\DISK9\REDO01C.LOG D:\backup\
host copy D:\DISK9\REDO02C.LOG D:\backup\
host copy D:\DISK9\REDO03C.LOG D:\backup\
host copy D:\DISK9\REDO04C.LOG D:\backup\
host copy D:\DISK9\REDO05C.LOG D:\backup\
host copy D:\DISK3\CONTROL01.CTL D:\backup\
host copy D:\DISK6\CONTROL02.CTL D:\backup\
host copy D:\DISK9\CONTROL03.CTL D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEMP01.DBF D:\backup\
host copy D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\TEMP1129.DBF D:\backup\
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
已复制
ORA-12528: TNS: 监听程序: 所有适用的例程都不允许建立新的连接
SQL> show sga
ERROR:
ORA-03114: 未连接到 ORALCE
SQL> connect sys/test;
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
SQL> startup
ORA-01031: insufficient privileges
SQL> show user;
USER 为 ""
ALERTLOG:
Archive process shutdown avoided: 0 active
Thu Dec 17 10:56:31 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values: