不完全リカバリ
##とりあえず、フルバックアップ取る。
SYS @ TESTDB >
SYS @ TESTDB >alter system switch logfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >ALTER DATABASE BEGIN BACKUP;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$ export BKID=3000
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabacupkups
合計 36
drwxr-xr-x 5 oracle oinstall 4096 11月 27 23:18 3000
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$ rm -f /home/testdb/oradata01/TESTDB/arch/*.*
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:17 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:17 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:17 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 19304
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3000/trace.trc';
Database altered.
SYS @ TESTDB >
##これで最初のバックアップが終了しました。
##続いて、データベースに変更を加えます。
##まずは、testdb_user.testtableをdrop。時間を記録する。
SYS @ TESTDB >SELECT TO_CHAR(SYSDATE, 'YYYYMMDD HH24:MI:SS') NOW FROM DUAL;
NOW
-----------------
20081127 23:22:01
SYS @ TESTDB >
SYS @ TESTDB >drop table testdb_user.ta esttable;
Table dropped.
SYS @ TESTDB >
SYS @ TESTDB >
##新しいテーブルを作成します。
SYS @ TESTDB >CREATE TABLE SYSTEM.TESTTABLE (COLA VARCHAR2(5), COLB VARCHAR2(10), COLC TIMESTAMP);
Table created.
SYS @ TESTDB >
SYS @ TESTDB >BEGIN
FOR I IN 1..50 LOOP
INSERT INTO SYSTEM.TESTTABLE(COLA, COLB, COLC)
VALUES(I,'SYSTEM',SYSDATE);
END LOOP;
END;
/
PL/SQL procedure successfully completed.
SYS @ TESTDB >COMMIT;
Commit complete.
SYS @ TESTDB >SELECT COUNT(*) FROM SYSTEM.TESTTABLE;
COUNT(*)
----------
50
SYS @ TESTDB >
##変更が完了。再びフルバックアップを取得します。
SYS @ TESTDB >alter system switch logfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database begin backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3001
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:24 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:24 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 60
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3001/trace.trc';
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
##仮にここで、テーブルがドロップされたことが発覚！
shutdownして、3000に戻る
SYS @ TESTDB >shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
##3000のファイルをリストア
export BKID=3000
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata03/*.dbf /home/testdb/oradata03/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata04/*.dbf /home/testdb/oradata04/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/arch/*.* /home/testdb/oradata01/TESTDB/arc h/
[oracle@node01 ctrl01]$ ll -ltr /home/testdb/oradata01/TESTDB/arch/
合計 19364
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
Database mounted.
SYS @ TESTDB >
##テーブルドロップ直前に戻す
SYS @ TESTDB >recover database until time '2008/11/27 23:22:00';
Media recovery complete.
SYS @ TESTDB >
SYS @ TESTDB >alter database open resetlogs;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 TESTDB 27-NOV-08 10.50.26.000000 PM
2 TESTDB 27-NOV-08 10.50.26.000000 PM
3 TESTDB 27-NOV-08 10.50.26.000000 PM
4 TESTDB 27-NOV-08 10.50.26.000000 PM
5 TESTDB 27-NOV-08 10.50.26.000000 PM
6 TESTDB 27-NOV-08 10.50.26.000000 PM
7 TESTDB 27-NOV-08 10.50.26.000000 PM
8 TESTDB 27-NOV-08 10.50.26.000000 PM
9 TESTDB 27-NOV-08 10.50.26.000000 PM
10 TESTDB 27-NOV-08 10.50.26.000000 PM
11 TESTDB 27-NOV-08 10.50.26.000000 PM
12 TESTDB 27-NOV-08 10.50.26.000000 PM
13 TESTDB 27-NOV-08 10.50.26.000000 PM
14 TESTDB 27-NOV-08 10.50.26.000000 PM
15 TESTDB 27-NOV-08 10.50.26.000000 PM
16 TESTDB 27-NOV-08 10.50.26.000000 PM
17 TESTDB 27-NOV-08 10.50.26.000000 PM
18 TESTDB 27-NOV-08 10.50.26.000000 PM
19 TESTDB 27-NOV-08 10.50.26.000000 PM
20 TESTDB 27-NOV-08 10.50.26.000000 PM
21 TESTDB 27-NOV-08 10.50.26.000000 PM
22 TESTDB 27-NOV-08 10.50.26.000000 PM
23 TESTDB 27-NOV-08 10.50.26.000000 PM
24 TESTDB 27-NOV-08 10.50.26.000000 PM
25 TESTDB 27-NOV-08 10.50.26.000000 PM
26 TESTDB 27-NOV-08 10.50.26.000000 PM
27 TESTDB 27-NOV-08 10.50.26.000000 PM
28 TESTDB 27-NOV-08 10.50.26.000000 PM
29 TESTDB 27-NOV-08 10.50.26.000000 PM
30 TESTDB 27-NOV-08 10.50.26.000000 PM
31 TESTDB 27-NOV-08 10.50.26.000000 PM
32 TESTDB 27-NOV-08 10.50.26.000000 PM
33 TESTDB 27-NOV-08 10.50.26.000000 PM
34 TESTDB 27-NOV-08 10.50.26.000000 PM
35 TESTDB 27-NOV-08 10.50.26.000000 PM
36 TESTDB 27-NOV-08 10.50.26.000000 PM
37 TESTDB 27-NOV-08 10.50.26.000000 PM
38 TESTDB 27-NOV-08 10.50.26.000000 PM
39 TESTDB 27-NOV-08 10.50.26.000000 PM
40 TESTDB 27-NOV-08 10.50.26.000000 PM
41 TESTDB 27-NOV-08 10.50.26.000000 PM
42 TESTDB 27-NOV-08 10.50.26.000000 PM
43 TESTDB 27-NOV-08 10.50.26.000000 PM
44 TESTDB 27-NOV-08 10.50.26.000000 PM
45 TESTDB 27-NOV-08 10.50.26.000000 PM
46 TESTDB 27-NOV-08 10.50.26.000000 PM
47 TESTDB 27-NOV-08 10.50.26.000000 PM
48 TESTDB 27-NOV-08 10.50.26.000000 PM
49 TESTDB 27-NOV-08 10.50.26.000000 PM
50 TESTDB 27-NOV-08 10.50.26.000000 PM
50 rows selected.
SYS @ TESTDB >
##おお、回復しました。
##しかし！
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
SELECT * FROM SYSTEM.TESTTABLE
*
ERROR at line 1:
ORA-00942: table or view does not exist
SYS @ TESTDB >
##後に作成されたテーブルはない！！
##それはしょうがないですね。
##とにかく、せっかく戻したテーブルのデータをエクスポートしておく！！
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exp testdb_user/testdb_user file='/home/testdb/orabackups/3000/testdbuser_testtable.dmp' tables=testdb_user.testtable;
Export: Release 10.2.0.4.0 - Production on Thu Nov 27 23:36:07 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TESTTABLE 50 rows exported
Export terminated successfully without warnings.
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
##後に作ったテーブルも戻さないとだめなので、
##最新の状態に戻そう...
SYS @ TESTDB >shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3001
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata03/*.dbf /home/testdb/oradata03/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata04/*.dbf /home/testdb/oradata04/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/arch/*.* /home/testdb/oradata01/TESTDB/arc h/
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/oradata01/TESTDB/arch/*.*
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000003_0671930144.arc
-rw-r----- 1 oracle oinstall 2848768 11月 27 23:33 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
Database mounted.
SYS @ TESTDB >
SYS @ TESTDB >recover dta atabase;
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/home/testdb/oradata03/TESTDB/system01.dbf'
SYS @ TESTDB >
SYS @ TESTDB >shutdown imem mediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >alter da startup nomount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >CREATE CONTROLFILE REUSE DATABASE "TESTDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 200
MAXINSTANCES 2
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/home/testdb/oradata01/TESTDB/redo/redo01a.log',
'/home/testdb/oradata02/TESTDB/redo/redo01b.log'
) SIZE 20M,
GROUP 2 (
'/home/testdb/oradata01/TESTDB/redo/redo02a.log',
'/home/testdb/oradata02/TESTDB/redo/redo02b.log'
) SIZE 20M,
GROUP 3 (
'/home/testdb/oradata01/TESTDB/redo/redo03a.log',
'/home/testdb/oradata02/TESTDB/redo/redo03b.log'
) SIZE 20M
DATAFILE
'/home/testdb/oradata03/TESTDB/system01.dbf',
'/home/testdb/oradata03/TESTDB/undotbs01.dbf',
'/home/testdb/oradata03/TESTDB/sysaux01.dbf',
'/home/testdb/oradata04/TESTDB/index01_01.dbf',
'/home/testdb/oradata04/TESTDB/index02_01.dbf',
'/home/testdb/oradata04/TESTDB/users01_01.dbf',
'/home/testdb/oradata04/TESTDB/users02_01.dbf'
CHARACTER SET AL32UTF8
;
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
Control file created.
SYS @ TESTDB >SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >s alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
SYS @ TESTDB >
SYS @ TESTDB >recover database until cancel using backup controlfile;
ORA-00279: change 272945 generated at 11/27/2008 23:24:17 needed for thread 1
ORA-00289: suggestion : /home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc
ORA-00280: change 272945 for thread 1 is in sequence #4
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00279: change 273406 generated at 11/27/2008 23:33:06 needed for thread 1
ORA-00289: suggestion : /home/testdb/oradata01/TESTDB/arch/arch_1_0000000005_0671930144.arc
ORA-00280: change 273406 for thread 1 is in sequence #5
ORA-00278: log file '/home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc' no longer
needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/home/testdb/oradata01/TESTDB/arch/arch_1_0000000005_0671930144.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SYS @ TESTDB >
SYS @ TESTDB >alter database open resetlogs;
Database altered.
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
SELECT * FROM TESTDB_USER.TESTTABLE
*
ERROR at line 1:
ORA-00942: table or view does not exist
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 SYSTEM 27-NOV-08 11.22.51.000000 PM
2 SYSTEM 27-NOV-08 11.22.51.000000 PM
3 SYSTEM 27-NOV-08 11.22.51.000000 PM
4 SYSTEM 27-NOV-08 11.22.51.000000 PM
5 SYSTEM 27-NOV-08 11.22.51.000000 PM
6 SYSTEM 27-NOV-08 11.22.51.000000 PM
7 SYSTEM 27-NOV-08 11.22.51.000000 PM
8 SYSTEM 27-NOV-08 11.22.51.000000 PM
9 SYSTEM 27-NOV-08 11.22.51.000000 PM
10 SYSTEM 27-NOV-08 11.22.51.000000 PM
11 SYSTEM 27-NOV-08 11.22.51.000000 PM
12 SYSTEM 27-NOV-08 11.22.51.000000 PM
13 SYSTEM 27-NOV-08 11.22.51.000000 PM
14 SYSTEM 27-NOV-08 11.22.51.000000 PM
15 SYSTEM 27-NOV-08 11.22.51.000000 PM
16 SYSTEM 27-NOV-08 11.22.51.000000 PM
17 SYSTEM 27-NOV-08 11.22.51.000000 PM
18 SYSTEM 27-NOV-08 11.22.51.000000 PM
19 SYSTEM 27-NOV-08 11.22.51.000000 PM
20 SYSTEM 27-NOV-08 11.22.51.000000 PM
21 SYSTEM 27-NOV-08 11.22.51.000000 PM
22 SYSTEM 27-NOV-08 11.22.51.000000 PM
23 SYSTEM 27-NOV-08 11.22.51.000000 PM
24 SYSTEM 27-NOV-08 11.22.51.000000 PM
25 SYSTEM 27-NOV-08 11.22.51.000000 PM
26 SYSTEM 27-NOV-08 11.22.51.000000 PM
27 SYSTEM 27-NOV-08 11.22.51.000000 PM
28 SYSTEM 27-NOV-08 11.22.51.000000 PM
29 SYSTEM 27-NOV-08 11.22.51.000000 PM
30 SYSTEM 27-NOV-08 11.22.51.000000 PM
31 SYSTEM 27-NOV-08 11.22.51.000000 PM
32 SYSTEM 27-NOV-08 11.22.51.000000 PM
33 SYSTEM 27-NOV-08 11.22.51.000000 PM
34 SYSTEM 27-NOV-08 11.22.51.000000 PM
35 SYSTEM 27-NOV-08 11.22.51.000000 PM
36 SYSTEM 27-NOV-08 11.22.51.000000 PM
37 SYSTEM 27-NOV-08 11.22.51.000000 PM
38 SYSTEM 27-NOV-08 11.22.51.000000 PM
39 SYSTEM 27-NOV-08 11.22.51.000000 PM
40 SYSTEM 27-NOV-08 11.22.51.000000 PM
41 SYSTEM 27-NOV-08 11.22.51.000000 PM
42 SYSTEM 27-NOV-08 11.22.51.000000 PM
43 SYSTEM 27-NOV-08 11.22.51.000000 PM
44 SYSTEM 27-NOV-08 11.22.51.000000 PM
45 SYSTEM 27-NOV-08 11.22.51.000000 PM
46 SYSTEM 27-NOV-08 11.22.51.000000 PM
47 SYSTEM 27-NOV-08 11.22.51.000000 PM
48 SYSTEM 27-NOV-08 11.22.51.000000 PM
49 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >ドロップされたテーブルはない、2番目のはある。いいですね。
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ imp HELP=Y
Import: Release 10.2.0.4.0 - Production on Thu Nov 27 23:42:46 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/password:
Example: IMP SCOTT/TIGER
Or, you can control how Import runs by entering the IMP command followed
by various arguments. To specify parameters, you use keywords:
Format: IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
USERID must be the first parameter on the command line.
Keyword Description (Default) Keyword Description (Default)
--------------------------------------------------------------------------
USERID username/password FULL import entire file (N)
BUFFER size of data buffer FROMUSER list of owner usernames
FILE input files (EXPDAT.DMP) TOUSER list of usernames
SHOW just list file contents (N) TABLES list of table names
IGNORE ignore create errors (N) RECORDLENGTH length of IO record
GRANTS import grants (Y) INCTYPE incremental import type
INDEXES import indexes (Y) COMMIT commit array insert (N)
ROWS import data rows (Y) PARFILE parameter filename
LOG log file of screen output CONSTRAINTS import constraints (Y)
DESTROY overwrite tablespace data file (N)
INDEXFILE write table/index info to specified file
SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
FEEDBACK display progress every x rows(0)
TOID_NOVALIDATE skip validation of specified type ids
FILESIZE maximum size of each dump file
STATISTICS import precomputed statistics (always)
RESUMABLE suspend when a space related error is encountered(N)
RESUMABLE_NAME text string used to identify resumable statement
RESUMABLE_TIMEOUT wait time for RESUMABLE
COMPILE compile procedures, packages, and functions (Y)
STREAMS_CONFIGURATION import streams general metadata (Y)
STREAMS_INSTANTIATION import streams instantiation metadata (N)
VOLSIZE number of bytes in file on each volume of a file on tape
The following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
TABLESPACES tablespaces to be transported into database
DATAFILES datafiles to be transported into database
TTS_OWNERS users that own data in the transportable tablespace set
Import terminated successfully without warnings.
[oracle@node01 ctrl01]$ imp userid=testdb_user/testdb_user file=/home/testdb/orabackups/3000/
arch/ oradata04/ testtable.dmp
oradata03/ testdbuser_testtable.dmp trace.trc
[oracle@node01 ctrl01]$ imp userid=testdb_user/testdb_user file=/home/testdb/orabackups/3000/testdbuser_ttesttable.dmp
Import: Release 10.2.0.4.0 - Production on Thu Nov 27 23:43:09 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing TESTDB_USER's objects into TESTDB_USER
. importing TESTDB_USER's objects into TESTDB_USER
. . importing table "TESTTABLE" 50 rows imported
Import terminated successfully without warnings.
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 TESTDB 27-NOV-08 10.50.26.000000 PM
2 TESTDB 27-NOV-08 10.50.26.000000 PM
3 TESTDB 27-NOV-08 10.50.26.000000 PM
4 TESTDB 27-NOV-08 10.50.26.000000 PM
5 TESTDB 27-NOV-08 10.50.26.000000 PM
6 TESTDB 27-NOV-08 10.50.26.000000 PM
7 TESTDB 27-NOV-08 10.50.26.000000 PM
8 TESTDB 27-NOV-08 10.50.26.000000 PM
9 TESTDB 27-NOV-08 10.50.26.000000 PM
10 TESTDB 27-NOV-08 10.50.26.000000 PM
11 TESTDB 27-NOV-08 10.50.26.000000 PM
12 TESTDB 27-NOV-08 10.50.26.000000 PM
13 TESTDB 27-NOV-08 10.50.26.000000 PM
14 TESTDB 27-NOV-08 10.50.26.000000 PM
15 TESTDB 27-NOV-08 10.50.26.000000 PM
16 TESTDB 27-NOV-08 10.50.26.000000 PM
17 TESTDB 27-NOV-08 10.50.26.000000 PM
18 TESTDB 27-NOV-08 10.50.26.000000 PM
19 TESTDB 27-NOV-08 10.50.26.000000 PM
20 TESTDB 27-NOV-08 10.50.26.000000 PM
21 TESTDB 27-NOV-08 10.50.26.000000 PM
22 TESTDB 27-NOV-08 10.50.26.000000 PM
23 TESTDB 27-NOV-08 10.50.26.000000 PM
24 TESTDB 27-NOV-08 10.50.26.000000 PM
25 TESTDB 27-NOV-08 10.50.26.000000 PM
26 TESTDB 27-NOV-08 10.50.26.000000 PM
27 TESTDB 27-NOV-08 10.50.26.000000 PM
28 TESTDB 27-NOV-08 10.50.26.000000 PM
29 TESTDB 27-NOV-08 10.50.26.000000 PM
30 TESTDB 27-NOV-08 10.50.26.000000 PM
31 TESTDB 27-NOV-08 10.50.26.000000 PM
32 TESTDB 27-NOV-08 10.50.26.000000 PM
33 TESTDB 27-NOV-08 10.50.26.000000 PM
34 TESTDB 27-NOV-08 10.50.26.000000 PM
35 TESTDB 27-NOV-08 10.50.26.000000 PM
36 TESTDB 27-NOV-08 10.50.26.000000 PM
37 TESTDB 27-NOV-08 10.50.26.000000 PM
38 TESTDB 27-NOV-08 10.50.26.000000 PM
39 TESTDB 27-NOV-08 10.50.26.000000 PM
40 TESTDB 27-NOV-08 10.50.26.000000 PM
41 TESTDB 27-NOV-08 10.50.26.000000 PM
42 TESTDB 27-NOV-08 10.50.26.000000 PM
43 TESTDB 27-NOV-08 10.50.26.000000 PM
44 TESTDB 27-NOV-08 10.50.26.000000 PM
45 TESTDB 27-NOV-08 10.50.26.000000 PM
46 TESTDB 27-NOV-08 10.50.26.000000 PM
47 TESTDB 27-NOV-08 10.50.26.000000 PM
48 TESTDB 27-NOV-08 10.50.26.000000 PM
49 TESTDB 27-NOV-08 10.50.26.000000 PM
50 TESTDB 27-NOV-08 10.50.26.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 SYSTEM 27-NOV-08 11.22.51.000000 PM
2 SYSTEM 27-NOV-08 11.22.51.000000 PM
3 SYSTEM 27-NOV-08 11.22.51.000000 PM
4 SYSTEM 27-NOV-08 11.22.51.000000 PM
5 SYSTEM 27-NOV-08 11.22.51.000000 PM
6 SYSTEM 27-NOV-08 11.22.51.000000 PM
7 SYSTEM 27-NOV-08 11.22.51.000000 PM
8 SYSTEM 27-NOV-08 11.22.51.000000 PM
9 SYSTEM 27-NOV-08 11.22.51.000000 PM
10 SYSTEM 27-NOV-08 11.22.51.000000 PM
11 SYSTEM 27-NOV-08 11.22.51.000000 PM
12 SYSTEM 27-NOV-08 11.22.51.000000 PM
13 SYSTEM 27-NOV-08 11.22.51.000000 PM
14 SYSTEM 27-NOV-08 11.22.51.000000 PM
15 SYSTEM 27-NOV-08 11.22.51.000000 PM
16 SYSTEM 27-NOV-08 11.22.51.000000 PM
17 SYSTEM 27-NOV-08 11.22.51.000000 PM
18 SYSTEM 27-NOV-08 11.22.51.000000 PM
19 SYSTEM 27-NOV-08 11.22.51.000000 PM
20 SYSTEM 27-NOV-08 11.22.51.000000 PM
21 SYSTEM 27-NOV-08 11.22.51.000000 PM
22 SYSTEM 27-NOV-08 11.22.51.000000 PM
23 SYSTEM 27-NOV-08 11.22.51.000000 PM
24 SYSTEM 27-NOV-08 11.22.51.000000 PM
25 SYSTEM 27-NOV-08 11.22.51.000000 PM
26 SYSTEM 27-NOV-08 11.22.51.000000 PM
27 SYSTEM 27-NOV-08 11.22.51.000000 PM
28 SYSTEM 27-NOV-08 11.22.51.000000 PM
29 SYSTEM 27-NOV-08 11.22.51.000000 PM
30 SYSTEM 27-NOV-08 11.22.51.000000 PM
31 SYSTEM 27-NOV-08 11.22.51.000000 PM
32 SYSTEM 27-NOV-08 11.22.51.000000 PM
33 SYSTEM 27-NOV-08 11.22.51.000000 PM
34 SYSTEM 27-NOV-08 11.22.51.000000 PM
35 SYSTEM 27-NOV-08 11.22.51.000000 PM
36 SYSTEM 27-NOV-08 11.22.51.000000 PM
37 SYSTEM 27-NOV-08 11.22.51.000000 PM
38 SYSTEM 27-NOV-08 11.22.51.000000 PM
39 SYSTEM 27-NOV-08 11.22.51.000000 PM
40 SYSTEM 27-NOV-08 11.22.51.000000 PM
41 SYSTEM 27-NOV-08 11.22.51.000000 PM
42 SYSTEM 27-NOV-08 11.22.51.000000 PM
43 SYSTEM 27-NOV-08 11.22.51.000000 PM
44 SYSTEM 27-NOV-08 11.22.51.000000 PM
45 SYSTEM 27-NOV-08 11.22.51.000000 PM
46 SYSTEM 27-NOV-08 11.22.51.000000 PM
47 SYSTEM 27-NOV-08 11.22.51.000000 PM
48 SYSTEM 27-NOV-08 11.22.51.000000 PM
49 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >全部戻しました。完璧です。
SYS @ TESTDB >念のため、もう一度フルバックアップを取るぞ。
alter system si witch lgofi ogfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database begin backup;
Database altered.
SYS @ TESTDB >e host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3002
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$ rm -f /home/testdb/oradata01/TESTDB/arch/*.*
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:44 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:44 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:44 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 22236
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 79360 11月 27 23:44 arch_1_0000000001_0671931715.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
-rw-r----- 1 oracle oinstall 2848768 11月 27 23:33 arch_1_0000000004_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3002/trace.trc';
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ これで完了です。
[oracle@node01 ctrl01]$ exit
SYS @ TESTDB >
SYS @ TESTDB >alter system switch logfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >ALTER DATABASE BEGIN BACKUP;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$ export BKID=3000
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabacupkups
合計 36
drwxr-xr-x 5 oracle oinstall 4096 11月 27 23:18 3000
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$ rm -f /home/testdb/oradata01/TESTDB/arch/*.*
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:17 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:17 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:17 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:17 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 19304
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3000/trace.trc';
Database altered.
SYS @ TESTDB >
##これで最初のバックアップが終了しました。
##続いて、データベースに変更を加えます。
##まずは、testdb_user.testtableをdrop。時間を記録する。
SYS @ TESTDB >SELECT TO_CHAR(SYSDATE, 'YYYYMMDD HH24:MI:SS') NOW FROM DUAL;
NOW
-----------------
20081127 23:22:01
SYS @ TESTDB >
SYS @ TESTDB >drop table testdb_user.ta esttable;
Table dropped.
SYS @ TESTDB >
SYS @ TESTDB >
##新しいテーブルを作成します。
SYS @ TESTDB >CREATE TABLE SYSTEM.TESTTABLE (COLA VARCHAR2(5), COLB VARCHAR2(10), COLC TIMESTAMP);
Table created.
SYS @ TESTDB >
SYS @ TESTDB >BEGIN
FOR I IN 1..50 LOOP
INSERT INTO SYSTEM.TESTTABLE(COLA, COLB, COLC)
VALUES(I,'SYSTEM',SYSDATE);
END LOOP;
END;
/
PL/SQL procedure successfully completed.
SYS @ TESTDB >COMMIT;
Commit complete.
SYS @ TESTDB >SELECT COUNT(*) FROM SYSTEM.TESTTABLE;
COUNT(*)
----------
50
SYS @ TESTDB >
##変更が完了。再びフルバックアップを取得します。
SYS @ TESTDB >alter system switch logfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database begin backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3001
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:24 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:24 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:24 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:24 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 60
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3001/trace.trc';
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
##仮にここで、テーブルがドロップされたことが発覚！
shutdownして、3000に戻る
SYS @ TESTDB >shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
##3000のファイルをリストア
export BKID=3000
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata03/*.dbf /home/testdb/oradata03/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata04/*.dbf /home/testdb/oradata04/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/arch/*.* /home/testdb/oradata01/TESTDB/arc h/
[oracle@node01 ctrl01]$ ll -ltr /home/testdb/oradata01/TESTDB/arch/
合計 19364
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
Database mounted.
SYS @ TESTDB >
##テーブルドロップ直前に戻す
SYS @ TESTDB >recover database until time '2008/11/27 23:22:00';
Media recovery complete.
SYS @ TESTDB >
SYS @ TESTDB >alter database open resetlogs;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 TESTDB 27-NOV-08 10.50.26.000000 PM
2 TESTDB 27-NOV-08 10.50.26.000000 PM
3 TESTDB 27-NOV-08 10.50.26.000000 PM
4 TESTDB 27-NOV-08 10.50.26.000000 PM
5 TESTDB 27-NOV-08 10.50.26.000000 PM
6 TESTDB 27-NOV-08 10.50.26.000000 PM
7 TESTDB 27-NOV-08 10.50.26.000000 PM
8 TESTDB 27-NOV-08 10.50.26.000000 PM
9 TESTDB 27-NOV-08 10.50.26.000000 PM
10 TESTDB 27-NOV-08 10.50.26.000000 PM
11 TESTDB 27-NOV-08 10.50.26.000000 PM
12 TESTDB 27-NOV-08 10.50.26.000000 PM
13 TESTDB 27-NOV-08 10.50.26.000000 PM
14 TESTDB 27-NOV-08 10.50.26.000000 PM
15 TESTDB 27-NOV-08 10.50.26.000000 PM
16 TESTDB 27-NOV-08 10.50.26.000000 PM
17 TESTDB 27-NOV-08 10.50.26.000000 PM
18 TESTDB 27-NOV-08 10.50.26.000000 PM
19 TESTDB 27-NOV-08 10.50.26.000000 PM
20 TESTDB 27-NOV-08 10.50.26.000000 PM
21 TESTDB 27-NOV-08 10.50.26.000000 PM
22 TESTDB 27-NOV-08 10.50.26.000000 PM
23 TESTDB 27-NOV-08 10.50.26.000000 PM
24 TESTDB 27-NOV-08 10.50.26.000000 PM
25 TESTDB 27-NOV-08 10.50.26.000000 PM
26 TESTDB 27-NOV-08 10.50.26.000000 PM
27 TESTDB 27-NOV-08 10.50.26.000000 PM
28 TESTDB 27-NOV-08 10.50.26.000000 PM
29 TESTDB 27-NOV-08 10.50.26.000000 PM
30 TESTDB 27-NOV-08 10.50.26.000000 PM
31 TESTDB 27-NOV-08 10.50.26.000000 PM
32 TESTDB 27-NOV-08 10.50.26.000000 PM
33 TESTDB 27-NOV-08 10.50.26.000000 PM
34 TESTDB 27-NOV-08 10.50.26.000000 PM
35 TESTDB 27-NOV-08 10.50.26.000000 PM
36 TESTDB 27-NOV-08 10.50.26.000000 PM
37 TESTDB 27-NOV-08 10.50.26.000000 PM
38 TESTDB 27-NOV-08 10.50.26.000000 PM
39 TESTDB 27-NOV-08 10.50.26.000000 PM
40 TESTDB 27-NOV-08 10.50.26.000000 PM
41 TESTDB 27-NOV-08 10.50.26.000000 PM
42 TESTDB 27-NOV-08 10.50.26.000000 PM
43 TESTDB 27-NOV-08 10.50.26.000000 PM
44 TESTDB 27-NOV-08 10.50.26.000000 PM
45 TESTDB 27-NOV-08 10.50.26.000000 PM
46 TESTDB 27-NOV-08 10.50.26.000000 PM
47 TESTDB 27-NOV-08 10.50.26.000000 PM
48 TESTDB 27-NOV-08 10.50.26.000000 PM
49 TESTDB 27-NOV-08 10.50.26.000000 PM
50 TESTDB 27-NOV-08 10.50.26.000000 PM
50 rows selected.
SYS @ TESTDB >
##おお、回復しました。
##しかし！
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
SELECT * FROM SYSTEM.TESTTABLE
*
ERROR at line 1:
ORA-00942: table or view does not exist
SYS @ TESTDB >
##後に作成されたテーブルはない！！
##それはしょうがないですね。
##とにかく、せっかく戻したテーブルのデータをエクスポートしておく！！
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exp testdb_user/testdb_user file='/home/testdb/orabackups/3000/testdbuser_testtable.dmp' tables=testdb_user.testtable;
Export: Release 10.2.0.4.0 - Production on Thu Nov 27 23:36:07 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
About to export specified tables via Conventional Path ...
. . exporting table TESTTABLE 50 rows exported
Export terminated successfully without warnings.
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
##後に作ったテーブルも戻さないとだめなので、
##最新の状態に戻そう...
SYS @ TESTDB >shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3001
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata03/*.dbf /home/testdb/oradata03/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/oradata04/*.dbf /home/testdb/oradata04/TES TDB
[oracle@node01 ctrl01]$ cp -p /home/testdb/orabackups/${BKID}/arch/*.* /home/testdb/oradata01/TESTDB/arc h/
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/oradata01/TESTDB/arch/*.*
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000003_0671930144.arc
-rw-r----- 1 oracle oinstall 2848768 11月 27 23:33 /home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >startup mount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
Database mounted.
SYS @ TESTDB >
SYS @ TESTDB >recover dta atabase;
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/home/testdb/oradata03/TESTDB/system01.dbf'
SYS @ TESTDB >
SYS @ TESTDB >shutdown imem mediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >alter da startup nomount;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 1268536 bytes
Variable Size 1543505096 bytes
Database Buffers 587202560 bytes
Redo Buffers 15507456 bytes
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >CREATE CONTROLFILE REUSE DATABASE "TESTDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 200
MAXINSTANCES 2
MAXLOGHISTORY 292
LOGFILE
GROUP 1 (
'/home/testdb/oradata01/TESTDB/redo/redo01a.log',
'/home/testdb/oradata02/TESTDB/redo/redo01b.log'
) SIZE 20M,
GROUP 2 (
'/home/testdb/oradata01/TESTDB/redo/redo02a.log',
'/home/testdb/oradata02/TESTDB/redo/redo02b.log'
) SIZE 20M,
GROUP 3 (
'/home/testdb/oradata01/TESTDB/redo/redo03a.log',
'/home/testdb/oradata02/TESTDB/redo/redo03b.log'
) SIZE 20M
DATAFILE
'/home/testdb/oradata03/TESTDB/system01.dbf',
'/home/testdb/oradata03/TESTDB/undotbs01.dbf',
'/home/testdb/oradata03/TESTDB/sysaux01.dbf',
'/home/testdb/oradata04/TESTDB/index01_01.dbf',
'/home/testdb/oradata04/TESTDB/index02_01.dbf',
'/home/testdb/oradata04/TESTDB/users01_01.dbf',
'/home/testdb/oradata04/TESTDB/users02_01.dbf'
CHARACTER SET AL32UTF8
;
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
Control file created.
SYS @ TESTDB >SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >s alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
SYS @ TESTDB >
SYS @ TESTDB >recover database until cancel using backup controlfile;
ORA-00279: change 272945 generated at 11/27/2008 23:24:17 needed for thread 1
ORA-00289: suggestion : /home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc
ORA-00280: change 272945 for thread 1 is in sequence #4
Specify log: {
ORA-00279: change 273406 generated at 11/27/2008 23:33:06 needed for thread 1
ORA-00289: suggestion : /home/testdb/oradata01/TESTDB/arch/arch_1_0000000005_0671930144.arc
ORA-00280: change 273406 for thread 1 is in sequence #5
ORA-00278: log file '/home/testdb/oradata01/TESTDB/arch/arch_1_0000000004_0671930144.arc' no longer
needed for this recovery
Specify log: {
ORA-00308: cannot open archived log
'/home/testdb/oradata01/TESTDB/arch/arch_1_0000000005_0671930144.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
SYS @ TESTDB >
SYS @ TESTDB >alter database open resetlogs;
Database altered.
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
SELECT * FROM TESTDB_USER.TESTTABLE
*
ERROR at line 1:
ORA-00942: table or view does not exist
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 SYSTEM 27-NOV-08 11.22.51.000000 PM
2 SYSTEM 27-NOV-08 11.22.51.000000 PM
3 SYSTEM 27-NOV-08 11.22.51.000000 PM
4 SYSTEM 27-NOV-08 11.22.51.000000 PM
5 SYSTEM 27-NOV-08 11.22.51.000000 PM
6 SYSTEM 27-NOV-08 11.22.51.000000 PM
7 SYSTEM 27-NOV-08 11.22.51.000000 PM
8 SYSTEM 27-NOV-08 11.22.51.000000 PM
9 SYSTEM 27-NOV-08 11.22.51.000000 PM
10 SYSTEM 27-NOV-08 11.22.51.000000 PM
11 SYSTEM 27-NOV-08 11.22.51.000000 PM
12 SYSTEM 27-NOV-08 11.22.51.000000 PM
13 SYSTEM 27-NOV-08 11.22.51.000000 PM
14 SYSTEM 27-NOV-08 11.22.51.000000 PM
15 SYSTEM 27-NOV-08 11.22.51.000000 PM
16 SYSTEM 27-NOV-08 11.22.51.000000 PM
17 SYSTEM 27-NOV-08 11.22.51.000000 PM
18 SYSTEM 27-NOV-08 11.22.51.000000 PM
19 SYSTEM 27-NOV-08 11.22.51.000000 PM
20 SYSTEM 27-NOV-08 11.22.51.000000 PM
21 SYSTEM 27-NOV-08 11.22.51.000000 PM
22 SYSTEM 27-NOV-08 11.22.51.000000 PM
23 SYSTEM 27-NOV-08 11.22.51.000000 PM
24 SYSTEM 27-NOV-08 11.22.51.000000 PM
25 SYSTEM 27-NOV-08 11.22.51.000000 PM
26 SYSTEM 27-NOV-08 11.22.51.000000 PM
27 SYSTEM 27-NOV-08 11.22.51.000000 PM
28 SYSTEM 27-NOV-08 11.22.51.000000 PM
29 SYSTEM 27-NOV-08 11.22.51.000000 PM
30 SYSTEM 27-NOV-08 11.22.51.000000 PM
31 SYSTEM 27-NOV-08 11.22.51.000000 PM
32 SYSTEM 27-NOV-08 11.22.51.000000 PM
33 SYSTEM 27-NOV-08 11.22.51.000000 PM
34 SYSTEM 27-NOV-08 11.22.51.000000 PM
35 SYSTEM 27-NOV-08 11.22.51.000000 PM
36 SYSTEM 27-NOV-08 11.22.51.000000 PM
37 SYSTEM 27-NOV-08 11.22.51.000000 PM
38 SYSTEM 27-NOV-08 11.22.51.000000 PM
39 SYSTEM 27-NOV-08 11.22.51.000000 PM
40 SYSTEM 27-NOV-08 11.22.51.000000 PM
41 SYSTEM 27-NOV-08 11.22.51.000000 PM
42 SYSTEM 27-NOV-08 11.22.51.000000 PM
43 SYSTEM 27-NOV-08 11.22.51.000000 PM
44 SYSTEM 27-NOV-08 11.22.51.000000 PM
45 SYSTEM 27-NOV-08 11.22.51.000000 PM
46 SYSTEM 27-NOV-08 11.22.51.000000 PM
47 SYSTEM 27-NOV-08 11.22.51.000000 PM
48 SYSTEM 27-NOV-08 11.22.51.000000 PM
49 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >ドロップされたテーブルはない、2番目のはある。いいですね。
SYS @ TESTDB >host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ imp HELP=Y
Import: Release 10.2.0.4.0 - Production on Thu Nov 27 23:42:46 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by your username/password:
Example: IMP SCOTT/TIGER
Or, you can control how Import runs by entering the IMP command followed
by various arguments. To specify parameters, you use keywords:
Format: IMP KEYWORD=value or KEYWORD=(value1,value2,...,valueN)
Example: IMP SCOTT/TIGER IGNORE=Y TABLES=(EMP,DEPT) FULL=N
or TABLES=(T1:P1,T1:P2), if T1 is partitioned table
USERID must be the first parameter on the command line.
Keyword Description (Default) Keyword Description (Default)
--------------------------------------------------------------------------
USERID username/password FULL import entire file (N)
BUFFER size of data buffer FROMUSER list of owner usernames
FILE input files (EXPDAT.DMP) TOUSER list of usernames
SHOW just list file contents (N) TABLES list of table names
IGNORE ignore create errors (N) RECORDLENGTH length of IO record
GRANTS import grants (Y) INCTYPE incremental import type
INDEXES import indexes (Y) COMMIT commit array insert (N)
ROWS import data rows (Y) PARFILE parameter filename
LOG log file of screen output CONSTRAINTS import constraints (Y)
DESTROY overwrite tablespace data file (N)
INDEXFILE write table/index info to specified file
SKIP_UNUSABLE_INDEXES skip maintenance of unusable indexes (N)
FEEDBACK display progress every x rows(0)
TOID_NOVALIDATE skip validation of specified type ids
FILESIZE maximum size of each dump file
STATISTICS import precomputed statistics (always)
RESUMABLE suspend when a space related error is encountered(N)
RESUMABLE_NAME text string used to identify resumable statement
RESUMABLE_TIMEOUT wait time for RESUMABLE
COMPILE compile procedures, packages, and functions (Y)
STREAMS_CONFIGURATION import streams general metadata (Y)
STREAMS_INSTANTIATION import streams instantiation metadata (N)
VOLSIZE number of bytes in file on each volume of a file on tape
The following keywords only apply to transportable tablespaces
TRANSPORT_TABLESPACE import transportable tablespace metadata (N)
TABLESPACES tablespaces to be transported into database
DATAFILES datafiles to be transported into database
TTS_OWNERS users that own data in the transportable tablespace set
Import terminated successfully without warnings.
[oracle@node01 ctrl01]$ imp userid=testdb_user/testdb_user file=/home/testdb/orabackups/3000/
arch/ oradata04/ testtable.dmp
oradata03/ testdbuser_testtable.dmp trace.trc
[oracle@node01 ctrl01]$ imp userid=testdb_user/testdb_user file=/home/testdb/orabackups/3000/testdbuser_ttesttable.dmp
Import: Release 10.2.0.4.0 - Production on Thu Nov 27 23:43:09 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
Export file created by EXPORT:V10.02.01 via conventional path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing TESTDB_USER's objects into TESTDB_USER
. importing TESTDB_USER's objects into TESTDB_USER
. . importing table "TESTTABLE" 50 rows imported
Import terminated successfully without warnings.
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM TESTDB_USER.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 TESTDB 27-NOV-08 10.50.26.000000 PM
2 TESTDB 27-NOV-08 10.50.26.000000 PM
3 TESTDB 27-NOV-08 10.50.26.000000 PM
4 TESTDB 27-NOV-08 10.50.26.000000 PM
5 TESTDB 27-NOV-08 10.50.26.000000 PM
6 TESTDB 27-NOV-08 10.50.26.000000 PM
7 TESTDB 27-NOV-08 10.50.26.000000 PM
8 TESTDB 27-NOV-08 10.50.26.000000 PM
9 TESTDB 27-NOV-08 10.50.26.000000 PM
10 TESTDB 27-NOV-08 10.50.26.000000 PM
11 TESTDB 27-NOV-08 10.50.26.000000 PM
12 TESTDB 27-NOV-08 10.50.26.000000 PM
13 TESTDB 27-NOV-08 10.50.26.000000 PM
14 TESTDB 27-NOV-08 10.50.26.000000 PM
15 TESTDB 27-NOV-08 10.50.26.000000 PM
16 TESTDB 27-NOV-08 10.50.26.000000 PM
17 TESTDB 27-NOV-08 10.50.26.000000 PM
18 TESTDB 27-NOV-08 10.50.26.000000 PM
19 TESTDB 27-NOV-08 10.50.26.000000 PM
20 TESTDB 27-NOV-08 10.50.26.000000 PM
21 TESTDB 27-NOV-08 10.50.26.000000 PM
22 TESTDB 27-NOV-08 10.50.26.000000 PM
23 TESTDB 27-NOV-08 10.50.26.000000 PM
24 TESTDB 27-NOV-08 10.50.26.000000 PM
25 TESTDB 27-NOV-08 10.50.26.000000 PM
26 TESTDB 27-NOV-08 10.50.26.000000 PM
27 TESTDB 27-NOV-08 10.50.26.000000 PM
28 TESTDB 27-NOV-08 10.50.26.000000 PM
29 TESTDB 27-NOV-08 10.50.26.000000 PM
30 TESTDB 27-NOV-08 10.50.26.000000 PM
31 TESTDB 27-NOV-08 10.50.26.000000 PM
32 TESTDB 27-NOV-08 10.50.26.000000 PM
33 TESTDB 27-NOV-08 10.50.26.000000 PM
34 TESTDB 27-NOV-08 10.50.26.000000 PM
35 TESTDB 27-NOV-08 10.50.26.000000 PM
36 TESTDB 27-NOV-08 10.50.26.000000 PM
37 TESTDB 27-NOV-08 10.50.26.000000 PM
38 TESTDB 27-NOV-08 10.50.26.000000 PM
39 TESTDB 27-NOV-08 10.50.26.000000 PM
40 TESTDB 27-NOV-08 10.50.26.000000 PM
41 TESTDB 27-NOV-08 10.50.26.000000 PM
42 TESTDB 27-NOV-08 10.50.26.000000 PM
43 TESTDB 27-NOV-08 10.50.26.000000 PM
44 TESTDB 27-NOV-08 10.50.26.000000 PM
45 TESTDB 27-NOV-08 10.50.26.000000 PM
46 TESTDB 27-NOV-08 10.50.26.000000 PM
47 TESTDB 27-NOV-08 10.50.26.000000 PM
48 TESTDB 27-NOV-08 10.50.26.000000 PM
49 TESTDB 27-NOV-08 10.50.26.000000 PM
50 TESTDB 27-NOV-08 10.50.26.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >SELECT * FROM SYSTEM.TESTTABLE;
COLA COLB COLC
----- ---------- ----------------------------------------
1 SYSTEM 27-NOV-08 11.22.51.000000 PM
2 SYSTEM 27-NOV-08 11.22.51.000000 PM
3 SYSTEM 27-NOV-08 11.22.51.000000 PM
4 SYSTEM 27-NOV-08 11.22.51.000000 PM
5 SYSTEM 27-NOV-08 11.22.51.000000 PM
6 SYSTEM 27-NOV-08 11.22.51.000000 PM
7 SYSTEM 27-NOV-08 11.22.51.000000 PM
8 SYSTEM 27-NOV-08 11.22.51.000000 PM
9 SYSTEM 27-NOV-08 11.22.51.000000 PM
10 SYSTEM 27-NOV-08 11.22.51.000000 PM
11 SYSTEM 27-NOV-08 11.22.51.000000 PM
12 SYSTEM 27-NOV-08 11.22.51.000000 PM
13 SYSTEM 27-NOV-08 11.22.51.000000 PM
14 SYSTEM 27-NOV-08 11.22.51.000000 PM
15 SYSTEM 27-NOV-08 11.22.51.000000 PM
16 SYSTEM 27-NOV-08 11.22.51.000000 PM
17 SYSTEM 27-NOV-08 11.22.51.000000 PM
18 SYSTEM 27-NOV-08 11.22.51.000000 PM
19 SYSTEM 27-NOV-08 11.22.51.000000 PM
20 SYSTEM 27-NOV-08 11.22.51.000000 PM
21 SYSTEM 27-NOV-08 11.22.51.000000 PM
22 SYSTEM 27-NOV-08 11.22.51.000000 PM
23 SYSTEM 27-NOV-08 11.22.51.000000 PM
24 SYSTEM 27-NOV-08 11.22.51.000000 PM
25 SYSTEM 27-NOV-08 11.22.51.000000 PM
26 SYSTEM 27-NOV-08 11.22.51.000000 PM
27 SYSTEM 27-NOV-08 11.22.51.000000 PM
28 SYSTEM 27-NOV-08 11.22.51.000000 PM
29 SYSTEM 27-NOV-08 11.22.51.000000 PM
30 SYSTEM 27-NOV-08 11.22.51.000000 PM
31 SYSTEM 27-NOV-08 11.22.51.000000 PM
32 SYSTEM 27-NOV-08 11.22.51.000000 PM
33 SYSTEM 27-NOV-08 11.22.51.000000 PM
34 SYSTEM 27-NOV-08 11.22.51.000000 PM
35 SYSTEM 27-NOV-08 11.22.51.000000 PM
36 SYSTEM 27-NOV-08 11.22.51.000000 PM
37 SYSTEM 27-NOV-08 11.22.51.000000 PM
38 SYSTEM 27-NOV-08 11.22.51.000000 PM
39 SYSTEM 27-NOV-08 11.22.51.000000 PM
40 SYSTEM 27-NOV-08 11.22.51.000000 PM
41 SYSTEM 27-NOV-08 11.22.51.000000 PM
42 SYSTEM 27-NOV-08 11.22.51.000000 PM
43 SYSTEM 27-NOV-08 11.22.51.000000 PM
44 SYSTEM 27-NOV-08 11.22.51.000000 PM
45 SYSTEM 27-NOV-08 11.22.51.000000 PM
46 SYSTEM 27-NOV-08 11.22.51.000000 PM
47 SYSTEM 27-NOV-08 11.22.51.000000 PM
48 SYSTEM 27-NOV-08 11.22.51.000000 PM
49 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 SYSTEM 27-NOV-08 11.22.51.000000 PM
50 rows selected.
SYS @ TESTDB >
SYS @ TESTDB >全部戻しました。完璧です。
SYS @ TESTDB >念のため、もう一度フルバックアップを取るぞ。
alter system si witch lgofi ogfile;
System altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database begin backup;
Database altered.
SYS @ TESTDB >e host
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ export BKID=3002
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata03
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/oradata04
[oracle@node01 ctrl01]$ mkdir -p /home/testdb/orabackups/${BKID}/arch
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata03/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a03
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata04/TESTDB/*.dbf /home/testdb/orabackups/${BKID}/oradat a04
[oracle@node01 ctrl01]$ cp -p /home/testdb/oradata01/TESTDB/arch/*.* /home/testdb/orabackups/${BKID}/arc h
[oracle@node01 ctrl01]$ rm -f /home/testdb/oradata01/TESTDB/arch/*.*
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata03
合計 995120
-rw-r----- 1 oracle oinstall 524296192 11月 27 23:44 sysaux01.dbf
-rw-r----- 1 oracle oinstall 314580992 11月 27 23:44 system01.dbf
-rw-r----- 1 oracle oinstall 52436992 11月 27 22:01 temp01.dbf
-rw-r----- 1 oracle oinstall 178266112 11月 27 23:44 undotbs01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/oradata04
合計 82048
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 index01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 index02_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 users01_01.dbf
-rw-r----- 1 oracle oinstall 20979712 11月 27 23:44 users02_01.dbf
[oracle@node01 ctrl01]$ ll /home/testdb/orabackups/${BKID}/arch
合計 22236
-rw-r----- 1 oracle oinstall 44032 11月 27 23:16 arch_1_0000000001_0671930144.arc
-rw-r----- 1 oracle oinstall 79360 11月 27 23:44 arch_1_0000000001_0671931715.arc
-rw-r----- 1 oracle oinstall 19449856 11月 27 22:52 arch_1_0000000002_0671910876.arc
-rw-r----- 1 oracle oinstall 1024 11月 27 23:17 arch_1_0000000002_0671930144.arc
-rw-r----- 1 oracle oinstall 235008 11月 27 23:05 arch_1_0000000003_0671910876.arc
-rw-r----- 1 oracle oinstall 56320 11月 27 23:23 arch_1_0000000003_0671930144.arc
-rw-r----- 1 oracle oinstall 2848768 11月 27 23:33 arch_1_0000000004_0671930144.arc
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ exit
exit
SYS @ TESTDB >
SYS @ TESTDB >alter database end backup;
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >alter database backup controlfile to trace as '/home/testdb/orabackups/3002/trace.trc';
Database altered.
SYS @ TESTDB >
SYS @ TESTDB >
SYS @ TESTDB >exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$
[oracle@node01 ctrl01]$ これで完了です。
[oracle@node01 ctrl01]$ exit
posted by henbeibi at
11:05 PM
0 Comments:
Post a Comment
<< Home