zhouweifeng

«	八月 2008	»
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

===========================================================

RMAN备份进度

===========================================================

RMAN备份进度查询：

查看全文

zhouwf0726 发表于:2007.09.28 15:54 ::分类: ( oracle备份恢复 ) ::阅读:(307次) :: 评论 (0) :: 引用 (0)

===========================================================

RMAN(转)

===========================================================

RMAN备份概述

采用数据库提供的RMAN备份工具有以下的优点：

支持在线热备份

支持多级增量备份

支持并行备份，恢复

减小所需要备份量

备份，恢复使用简单

在线热备份

是指备份不需要关闭数据库进行，在备份的同时可以进行正常的数据库的各种操作，满足了7*24的系统的需要,对于本系统而言，数据库的备份将不会影响INTERNET或INTRANET用户对数据库的访问。

多级增量备份

多级增量备份是指第N级的备份只需要备份最后一次同级或N-1级备份以后发生的改变的数据。可以通过下图来说明：

上图是一个增量备份的例子，即在第一个星期天做一个增量的0级备份，然后在星期一，星期二做一个增量的2级备份，在星期三做一个增量的1级备份，然后类推。假设现在在星期五数据库需要做恢复，则可以先恢复第一个星期天的0级备份，，然后恢复星期三的1级备份，再恢复星期四和星期五的2级备份就可以完成数据库的恢复。

因为在本系统录入后的数据数据进入数据库后将大部分变为只读状态，所以采用对这些表空间只备份一次或比经常改变的表空间备份次数更少的方法，将能够很大地减少备份的数据量。具体的方案如下：

对于表PROD_CONTENT_CN_TBL，PROD_VALUE_TBL由于做了关于序列号的分区，采取的当一个分区满了以后，在数据库里把该分区改成只读状态，然后做一个该表空间的备份，然后在做数据库的日常增量备份时忽略该表空间的数据则能够大大减少要备份的数据量。

并行备份，恢复

RMAN是通过启动数据库的SERVER进程来进行备份和恢复，而且支持启动多个SERVER进程来进行备份和恢复，在同一个SERVER进程内还支持多个BACKUPSET（备份集）的同时产生。主要是通过设置多个通道及filesperset参数来达到并行的目的。

分配多个通道的语句（以下语句分配两个通道）

Allocate channel ‘dev_1’ type disk;

Allocate channel ‘dev_2’ type disk;

设置在一个通道同时打开的备份文件语句(以下语句设置在一个通道下同时打开3个文件)

backup filesperset 3。。。

减少所需要的备份数据量

因为RMAN是工作在数据快一级，所以能够只备份分配的数据快，这样就大大地减少了所需要的备份的数据量，特别是对于预先分配空间的数据库而言。

使用简单

RMAN的使用特别简单，在进行备份和恢复时都不需要指定需要备份或需要恢复的数据文件，RMAN会自动地把备份或恢复所需要的数据文件进行备份或进行恢复。减少了人为操作可能产生的错误。

如以下是备份整个数据库的语句

backup full tag 'basicdb' format '/bak/bak/basic/basic%u_%p_%c' database ;

以下是备份一个表空间的语句

backup tag 'tsusers' format '/bak/bak/basic/basic%u_%p_%c' tablespace users ;

以下是备份归档文件的语句

backup filesperset 3 archivelog all delete input;

归档文件会在备份后自动删除。

查看全文

zhouwf0726 发表于:2007.04.09 14:59 ::分类: ( oracle备份恢复 ) ::阅读:(780次) :: 评论 (2) :: 引用 (0)

===========================================================

RMAN 备份集在异机异路径下恢复过程(转)

===========================================================

RMAN 备份集在异机异路径下恢复过程详解! 查看全文

zhouwf0726 发表于:2007.04.04 17:51 ::分类: ( oracle备份恢复 ) ::阅读:(1125次) :: 评论 (0) :: 引用 (0)

===========================================================

ORACLE备份脚本

===========================================================

@set ORACLE_HOME=d:\oracle\ora92
@rem echo %ORACLE_HOME%
@set ORACLE_SID=dw
@rem echo %ORACLE_SID%
@set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
@rem echo %NLS_LANG%
@set PATH=%ORACLE_HOME%\bin
@rem echo %PATH%

@set RMAN=%ORACLE_HOME%\bin\rman.exe
@set MONTH=%date:~4,7%
@set BACKUP_DIR=D:\BACKUP\%MONTH%
@IF NOT EXIST %BACKUP_DIR% (
mkdir %BACKUP_DIR%
)

@set RQ=%date:~4,10%
@set RMAN_LOG_FILE=%BACKUP_DIR%\rman_%RQ%.log
@rem echo %RMAN_LOG_FILE%
@set TARGET_CONNECT_STR=sys/sys@dw

@set DAY=%date:~12,2%

@REM 0级备份就是进行全库备份，level 1就是备份level 0后改变的数据，level 2就是备份level 1或level 0后改变的数据
@REM 如果前一个备份是level 1那么就备份这之后修改的数据，如果前个备份是level 0那么就备份level 0后的数据

@echo ==== started on %DATE% ==== >> %RMAN_LOG_FILE%

@set BACKUPTYPE=incremental level 2 database
@set NAME=L2_%%d_%%T_%%s

@if "%DAY%" EQU "05" (
set BACKUPTYPE=incremental level 1 database
set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@if "%DAY%" EQU "10" (
set BACKUPTYPE=incremental level 1 database
set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@if "%DAY%" EQU "15" (
set BACKUPTYPE=incremental level 1 database
set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@if "%DAY%" EQU "20" (
set BACKUPTYPE=incremental level 1 database
set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@if "%DAY%" EQU "25" (
set BACKUPTYPE=incremental level 1 database
set NAME=L1_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@if "%DAY%" EQU "01" (
set BACKUPTYPE=incremental level 0 database
set NAME=F_%%d_%%T_%%s
set ARCHIVE=L1_%%d_%%T
)

@REM backup format 'd:\backup\dbL0_%d_%T.arc' archivelog all delete input;
@rem echo backup %BACKUPTYPE% include current controlfile;
@rem echo sql "ALTER SYSTEM ARCHIVE LOG CURRENT";

@(
echo run {
echo allocate channel Channel1 type disk format '%BACKUP_DIR%\%NAME%';
echo backup %BACKUPTYPE% include current controlfile;
echo sql "ALTER SYSTEM ARCHIVE LOG CURRENT";
echo backup format '%BACKUP_DIR%\%ARCHIVE%' archivelog all delete input;
echo backup current controlfile format '%BACKUP_DIR%\ctl_%d_%T_%s';
echo release channel Channel1;
echo }
) | %RMAN% target %TARGET_CONNECT_STR% nocatalog msglog '%RMAN_LOG_FILE%'

@set ERRLEVEL=%ERRORLEVEL%

@if %ERRLEVEL% NEQ 0 @goto err

@set LOGMSG="备份成功！！"

@goto end

:err
@set LOGMSG="备份失败，请重试！！！"

:end

@echo # >> %RMAN_LOG_FILE%
@echo ==== %LOGMSG% on %DATE% ==== >> %RMAN_LOG_FILE%
@endlocal
@REM End of Main Program -----------------------------------------------------

zhouwf0726 发表于:2006.12.14 13:32 ::分类: ( oracle备份恢复 ) ::阅读:(1079次) :: 评论 (1) :: 引用 (0)

===========================================================

与控制文件有关的恢复(二)

===========================================================

由此可以引出，创建控制文件时丢失数据文件的解决方法（条件：丢失的数据文件要有备份和备份以来的所有归档日志）

SQL> CREATE CONTROLFILE REUSE DATABASE "TS" NORESETLOGS ARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 4674
7 LOGFILE
8 GROUP 1 'D:ORACLEPRODUCT10.2.0ORADATATSREDO01.LOG' SIZE 50M,
9 GROUP 2 'D:ORACLEPRODUCT10.2.0ORADATATSREDO02.LOG' SIZE 50M,
10 GROUP 3 'D:ORACLEPRODUCT10.2.0ORADATATSREDO03.LOG' SIZE 50M
11 -- STANDBY LOGFILE
12 DATAFILE
13 'D:ORACLEPRODUCT10.2.0ORADATATSSYSTEM01.DBF',
14 'D:ORACLEPRODUCT10.2.0ORADATATST.DBF',
15 'D:ORACLEPRODUCT10.2.0ORADATATSSYSAUX01.DBF',
16 'D:ORACLEPRODUCT10.2.0ORADATATSUSERS01.DBF',
17 'D:ORACLEPRODUCT10.2.0ORADATATSEXAMPLE01.DBF',
18 'D:ORACLEPRODUCT10.2.0ORADATATSBLOCK.DBF',
19 'D:ORACLEPRODUCT10.2.0ORADATATSTEST.DBF',
20 'D:ORACLEPRODUCT10.2.0ORADATATSBBED.DBF',
21 'D:ORACLEPRODUCT10.2.0ORADATATSA0.DBF',
22 'D:ORACLEPRODUCT10.2.0ORADATATSFLM.DBF',
23 'D:ORACLEPRODUCT10.2.0ORADATATSASSM.DBF',
24 'D:ORACLEPRODUCT10.2.0ORADATATSUNDOTBS.DBF',
25 'D:ORACLEPRODUCT10.2.0ORADATATST1.DBF',
26 'D:ORACLEPRODUCT10.2.0ORADATATSDEMO.DBF',
27 'D:ORACLEPRODUCT10.2.0ORADATATSDUMMY.DBF',
28 'D:ORACLEPRODUCT10.2.0ORADATATSA.DBF'
29 CHARACTER SET ZHS16GBK
30 /

Control file created.//控制文件创建时丢失表空间b下的数据文件b.dbf

SQL> alter database open;

Database altered.

SQL> select * from dba_tablespaces;

TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN ALLOCATIO PLU SEGMEN DEF_TAB_ RETENTION BIG
------------------------------ ---------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- --- ---------- --------- --- ------ -------- ----------- ---
SYSTEM 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO
SYSAUX 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
USERS 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
EXAMPLE 8192 65536 1 2147483645 65536 ONLINE PERMANENT NOLOGGING NO LOCAL SYSTEM YES AUTO DISABLED NOT APPLY NO
BLOCK 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
TEST 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
BBED 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
TEMP2 8192 1048576 1048576 1 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED NOT APPLY NO
FLM 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOT APPLY NO
ASSM 8192 65536 1 2147483645 65536 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED NOT APPLY NO
UNDOTBS 8192 65536 1 2147483645 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED NOGUARANTEE NO

16 rows selected.

SQL> select * from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
D:ORACLEPRODUCT10.2.0ORADATATSA.DBF
D:ORACLEPRODUCT10.2.0ORADATATSDUMMY.DBF
D:ORACLEPRODUCT10.2.0ORADATATSDEMO.DBF
D:ORACLEPRODUCT10.2.0ORADATATST1.DBF
D:ORACLEPRODUCT10.2.0ORADATATSUNDOTBS.DBF
D:ORACLEPRODUCT10.2.0ORADATATSASSM.DBF
D:ORACLEPRODUCT10.2.0ORADATATSFLM.DBF
D:ORACLEPRODUCT10.2.0ORADATATSA0.DBF
D:ORACLEPRODUCT10.2.0ORADATATSBBED.DBF
D:ORACLEPRODUCT10.2.0ORADATATSTEST.DBF
D:ORACLEPRODUCT10.2.0ORADATATSBLOCK.DBF

FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
D:ORACLEPRODUCT10.2.0ORADATATSEXAMPLE01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSUSERS01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSSYSAUX01.DBF
D:ORACLEPRODUCT10.2.0ORADATATST.DBF
D:ORACLEPRODUCT10.2.0ORADATATSSYSTEM01.DBF
D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00010
D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011
D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00019

19 rows selected.

SQL> select * from t13;
select * from t13
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00019' as 'D:ORACLEPRODUCT10.2.0DB_1DATABASEb.dbf' reuse;
alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00019' as 'D:ORACLEPRODUCT10.2.0DB_1DATABASEb.dbf' reuse
*
ERROR at line 1:
ORA-01178: file 19 created before last CREATE CONTROLFILE, cannot recreate
ORA-01111: name for data file 19 is unknown - rename to correct file
ORA-01110: data file 19: 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00019'

SQL> alter database rename file 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00019' to 'D:ORACLEPRODUCT10.2.0DB_1DATABASEb.dbf';

Database altered.

SQL> select * from t13;
select * from t13
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> recover datafile 19;
Media recovery complete.
SQL> alter database datafile 19 online;

Database altered.

SQL> select * from t13;
select * from t13
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from dba_segments
2 where tablespace_name='T13';

no rows selected

SQL> select * from dba_tablespaces;

16 rows selected.

SQL> select * from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
D:ORACLEPRODUCT10.2.0ORADATATSEXAMPLE01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSUSERS01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSSYSAUX01.DBF
D:ORACLEPRODUCT10.2.0ORADATATST.DBF
D:ORACLEPRODUCT10.2.0ORADATATSSYSTEM01.DBF
D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00010
D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011
D:ORACLEPRODUCT10.2.0DB_1DATABASEB.DBF

19 rows selected.

SQL>

SQL> alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' as 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';
alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' as 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf'
*
ERROR at line 1:
ORA-01178: file 11 created before last CREATE CONTROLFILE, cannot recreate
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011'

SQL> alter database rename file 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' to 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';
alter database rename file 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' to 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01141: error renaming data file 11 - new file 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf' not found
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) 系统找不到指定的文件。

SQL> alter database rename file 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' to 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';

Database altered.

SQL> recover datafile 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';
ORA-00283: recovery session canceled due to errors
ORA-04031: unable to allocate 32332 bytes of shared memory ("shared pool","unknown object","sga heap(1,1)","previous log names for rcv so")

SQL> SQL> alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' as 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';
alter database create datafile 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' as 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf'
*
ERROR at line 1:
ORA-01178: file 11 created before last CREATE CONTROLFILE, cannot recreate
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011'

SQL> alter database rename file 'D:ORACLEPRODUCT10.2.0DB_1DATABASEMISSING00011' to 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';

Database altered.

SQL> recover datafile 'D:ORACLEPRODUCT10.2.0ORADATATSa2.dbf';

zhouwf0726 发表于:2006.10.12 10:27 ::分类: ( oracle备份恢复 ) ::阅读:(582次) :: 评论 (0) :: 引用 (0)

===========================================================

与控制文件有关的恢复

===========================================================

数据库处于归档模式：
1。丢失或损坏控制文件，至少有一个是好的。
2。控制文件全部损坏，控制文件备份后，数据库结构没有变化，即没有创建，删除数据库文件。
用创建控制文件恢复
a。数据库正常关闭后，控制文件全部损坏。
b。控制文件全部损坏，数据库非正常关闭，需要恢复。
2。控制文件全部损坏
使用备用控制文件恢复
a。数据库正常关闭
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
删除控制文件，restore备份控制文件
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 1249968 bytes
Variable Size 507514192 bytes
Database Buffers 8388608 bytes
Redo Buffers 7135232 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'D:ORACLEPRODUCT10.2.0ORADATATSSYSTEM01.DBF'

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
1 1 53 52428800 1 YES INACTIVE 119320505 18-AUG-06
3 1 55 52428800 1 NO CURRENT 119372293 21-AUG-06
2 1 54 52428800 1 YES INACTIVE 119348433 18-AUG-06

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER
---------- ------- ------- ---------------------------------------------------------------------------------
3 ONLINE D:ORACLEPRODUCT10.2.0ORADATATSREDO03.LOG
2 STALE ONLINE D:ORACLEPRODUCT10.2.0ORADATATSREDO02.LOG
1 STALE ONLINE D:ORACLEPRODUCT10.2.0ORADATATSREDO01.LOG
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 119374585 generated at 08/21/2006 08:37:22 needed for thread 1
ORA-00289: suggestion : D:ORACLEPRODUCT10.2.0FLASH_RECOVERY_AREATSARCHIVELOG2006_08_21O1_MF_1_55_%U_.ARC
ORA-00280: change 119374585 for thread 1 is in sequence #55

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

D:ORACLEPRODUCT10.2.0ORADATATSREDO03.LOG
Log applied.
Media recovery complete.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL> select count(*) from t;

COUNT(*)
----------
1645

SQL> select count(*) from t0;

COUNT(*)
----------
1645
数据没有丢失。
2。控制文件全部损坏，数据库非正常关闭

SQL> shutdown abort
Database closed.
Database dismounted.
ORACLE instance shut down.
删除控制文件，restore备份控制文件
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

SQL> select * from v$log;

SQL> select * from v$logfile;

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

SQL> alter database open resetlogs;

Database altered.

SQL> conn scott/tiger
Connected.
SQL> select count(*) from t1;

COUNT(*)
----------
1647

SQL> select count(*) from t2;

COUNT(*)
----------
1648

3。控制文件全部损坏，数据库非正常关闭，备份控制文件后，添加过数据文件
a。用创建控制文件的方法。
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 524288000 bytes
Fixed Size 1249968 bytes
Variable Size 507514192 bytes
Database Buffers 8388608 bytes
Redo Buffers 7135232 bytes
Database mounted.
Database opened.
SQL> conn scott/tiger
Connected.
SQL> create table t3
2 as select * from dba_tables;

Table created.

SQL> alter database backup controlfile to trace;

Database altered.

SQL> alter database backup controlfile to 'd:control.ctl';

Database altered.

SQL> create table t4
2 as select * from dba_tables;

Table created.

SQL> select name from v$datafile;

NAME
----------------------------------------------------------------------------------------------------------------
D:ORACLEPRODUCT10.2.0ORADATATSSYSTEM01.DBF
D:ORACLEPRODUCT10.2.0ORADATATST.DBF
D:ORACLEPRODUCT10.2.0ORADATATSSYSAUX01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSUSERS01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSEXAMPLE01.DBF
D:ORACLEPRODUCT10.2.0ORADATATSBLOCK.DBF
D:ORACLEPRODUCT10.2.0ORADATATSTEST.DBF
D:ORACLEPRODUCT10.2.0ORADATATSBBED.DBF
D:ORACLEPRODUCT10.2.0ORADATATSFLM.DBF
D:ORACLEPRODUCT10.2.0ORADATATSASSM.DBF
D:ORACLEPRODUCT10.2.0ORADATATSUNDOTBS.DBF

NAME
----------------------------------------------------------------------------------------------------------------
D:ORACLEPRODUCT10.2.0ORADATATST1.DBF
D:ORACLEPRODUCT10.2.0ORADATATSDEMO.DBF
D:ORACLEPRODUCT10.2.0ORADATATSDUMMY.DBF
D:ORACLEPRODUCT10.2.0ORADATATSA.DBF
D:ORACLEPRODUCT10.2.0ORADATATSTESTING.DBF
D:ORACLEPRODUCT10.2.0ORADATATSTESTING_LMT.DBF

17 rows selected.

SQL> alter database add datafile 'D:ORACLEPRODUCT10.2.0ORADATATSA0.dbf' size 5m;
alter database add datafile 'D:ORACLEPRODUCT10.2.0ORADATATSA0.dbf' size 5m
*
ERROR at line 1:
ORA-01900: LOGFILE keyword expected

SQL> alter tablespace a add datafile 'D:ORACLEPRODUCT10.2.0ORADATATSA0.dbf' size 5m;

Tablespace altered.

SQL> show user
USER is "SCOTT"
SQL> create table t5
2 tablespace a
3 as
4 select * from dba_tables;

Table created.

SQL> alter system archive log curent;
alter system archive log curent
*
ERROR at line 1:
ORA-01974: Illegal archive option

SQL> alter system archive log current;

System altered.

SQL> shutdown abort;
ORA-01031: insufficient privileges
SQL> conn sys/liang as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

SQL> shutdown abort
ORACLE instance shut down.
SQL> STARTU

«	八月 2008					»
一	二	三	四	五	六	日
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

Powered by:
Blog Provider:
Designed by:

«	八月 2008					»
一	二	三	四	五	六	日
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

«	八月 2008					»
一	二	三	四	五	六	日
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31