SQL> alter tablespace system begin backup;
SQL>!cp $HOME/dbs/system01.dbf $HOME/ONBACKUP/
SQL> shutdown abort <-- Á¤Àü»çÅ ¹ß»ý
SQL> startup
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/opt/oracle/oradata/system01.dbf'
SQL> select * frokm v$backup;
--> ¾î¶² fileÀÌ Hot Backup Mode¿¡ ÀÖ¾ú´ÂÁö È®ÀÎ
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 846470 23-JUL-03
2 NOT ACTIVE 846249 23-JUL-03
3 NOT ACTIVE 0
4 NOT ACTIVE 0
5 NOT ACTIVE 0
6 NOT ACTIVE 846262 23-JUL-03
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 846239 23-JUL-03
10 NOT ACTIVE 0
11 NOT ACTIVE 0
SQL> alter database datafile 1 end backup;
Database altered.
SQL> alter database open;
Database altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 846470 23-JUL-03
2 NOT ACTIVE 846249 23-JUL-03
3 NOT ACTIVE 0
4 NOT ACTIVE 0
5 NOT ACTIVE 0
6 NOT ACTIVE 846262 23-JUL-03
7 NOT ACTIVE 0
8 NOT ACTIVE 0
9 NOT ACTIVE 846239 23-JUL-03
10 NOT ACTIVE 0
11 NOT ACTIVE 0
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
12 NOT ACTIVE 0
13 NOT ACTIVE 0
13 rows selected
SQL>
SQL> ´Ù½Ã ¹é¾÷ÇÏ¸é µÈ´Ù
SQL> alter tablespace system begin backup;
Tablespace altered.
SQL> !cp $HOME/oradata/HUMAN/system01.dbf $HOME/ONBACKUP/
SQL> alter tablespace system end backup;
Tablespace altered.
SQL> alter system switch logfile;
System altered.
|