COLD BACKUP(五)

不完全恢复![@more@]

Table created.



COL01
-------------------
2007-04-18 01:16:10







1 row created.



1 row created.



Commit complete.



COL01
-------------------
2007-04-18 01:16:10
2007-04-18 01:28:12
2007-04-18 01:28:13




COL01
-------------------
2007-04-18 01:28:47




Table dropped.




System altered.



System altered.



System altered.



Database closed.
Database dismounted.
ORACLE instance shut down.






ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.



     FILE# ONLINE  ONLINE_ ERROR                                       CHANGE# TIME
---------- ------- ------- ---------------------------------------- ---------- -------------------
         1 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         2 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         3 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         4 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         5 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         6 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         7 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         8 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
         9 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
        10 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58
        11 ONLINE  ONLINE                                               293793 2007-04-18 01:23:58

11 rows selected.



     FILE# LAST_CHANGE# LAST_TIME
---------- ------------ -------------------
         1       298780 2007-04-18 01:49:33
         2       298780 2007-04-18 01:49:33
         3       298780 2007-04-18 01:49:33
         4       298780 2007-04-18 01:49:33
         5       298780 2007-04-18 01:49:33
         6       298780 2007-04-18 01:49:33
         7       298780 2007-04-18 01:49:33
         8       298780 2007-04-18 01:49:33
         9       298780 2007-04-18 01:49:33
        10       298780 2007-04-18 01:49:33
        11       298780 2007-04-18 01:49:33

11 rows selected.


NAME                                               FIRST_CHANGE# FIRST_TIME
-------------------------------------------------- ------------- -------------------
/backup/archive/1_3.arc                                   217037 2007-04-16 17:02:22
/backup/archive/1_4.arc                                   217823 2007-04-16 17:07:16
/backup/archive/1_5.arc                                   242255 2007-04-17 23:32:34
/backup/archive/1_6.arc                                   265988 2007-04-18 00:39:59
/backup/archive/1_7.arc                                   288938 2007-04-18 01:00:06
/backup/archive/1_8.arc                                   296098 2007-04-18 01:37:29
/backup/archive/1_9.arc                                   296100 2007-04-18 01:37:30

7 rows selected.

v$recover_file:  記錄的是實際文件的信息
v$datafile:       控制文件中的信息
v$archived_log:  歸檔的信息



ORA-00279: change 293793 generated at 04/18/2007 01:23:58 needed for thread 1



Specify log: {=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.



COL01
-------------------
2007-04-18 01:16:10
2007-04-18 01:28:12
2007-04-18 01:28:13


ALTER DATABASE RECOVER  database until time '2007-04-18 01:28:47'
Wed Apr 18 02:05:48 2007
Media Recovery Start
Wed Apr 18 02:05:48 2007
Restarting dead background process QMN0
Wed Apr 18 02:05:48 2007
Starting datafile 1 recovery in thread 1 sequence 7
Datafile 1: '/opt/oracle/oradata/huiyi/system01.dbf'
Starting datafile 2 recovery in thread 1 sequence 7
Datafile 2: '/opt/oracle/oradata/huiyi/undotbs01.dbf'
Starting datafile 3 recovery in thread 1 sequence 7
Datafile 3: '/opt/oracle/oradata/huiyi/drsys01.dbf'
Starting datafile 4 recovery in thread 1 sequence 7
Datafile 4: '/opt/oracle/oradata/huiyi/example01.dbf'
Starting datafile 5 recovery in thread 1 sequence 7
Datafile 5: '/opt/oracle/oradata/huiyi/indx01.dbf'
Starting datafile 6 recovery in thread 1 sequence 7
Datafile 6: '/opt/oracle/oradata/huiyi/odm01.dbf'
Starting datafile 7 recovery in thread 1 sequence 7
Datafile 7: '/opt/oracle/oradata/huiyi/tools01.dbf'
Starting datafile 8 recovery in thread 1 sequence 7
Datafile 8: '/opt/oracle/oradata/huiyi/users01.dbf'
Starting datafile 9 recovery in thread 1 sequence 7
Datafile 9: '/opt/oracle/oradata/huiyi/xdb01.dbf'
Starting datafile 10 recovery in thread 1 sequence 7
Datafile 10: '/opt/oracle/oradata/huiyi/tbs01-01.dbf'
Starting datafile 11 recovery in thread 1 sequence 7
Datafile 11: '/opt/oracle/oradata/huiyi/tbs01-02.dbf'
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER  database until time '2007-...
QMN0 started with pid=9
Wed Apr 18 02:05:54 2007
ALTER DATABASE RECOVER    CONTINUE DEFAULT
Wed Apr 18 02:05:54 2007

Media Recovery Complete





Table created.



COL01
-------------------
2007-04-18 04:35:21










1 row created.



Commit complete.



COL01
-------------------
2007-04-18 04:35:21
2007-04-18 04:42:11




Tablespace dropped.




System altered.



System altered.



System altered.


Database closed.
Database dismounted.
ORACLE instance shut down.






ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.


alert_log
Wed Apr 18 04:44:19 2007
drop tablespace tbs01 including contents and datafiles


ORA-00279: change 326132 generated at 04/18/2007 04:38:10 needed for thread 1
ORA-00289: suggestion : /backup/archive/1_1.arc
ORA-00280: change 326132 for thread 1 is in sequence #1


Specify log: {=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.




Database altered.



COL01
-------------------
2007-04-18 04:35:21
2007-04-18 04:42:11





Table created.



COL01
-------------------
2007-04-18 08:43:04






Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /backup/archive
Oldest online log sequence     1
Next log sequence to archive   2
Current log sequence           2


COL01
-------------------
2007-04-18 08:43:04




1 row created.



Commit complete.



System altered.




1 row created.



Commit complete.



System altered.




1 row created.



Commit complete.



System altered.


Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /backup/archive
Oldest online log sequence     3
Next log sequence to archive   5
Current log sequence           5


COL01
-------------------
2007-04-18 08:43:04
2007-04-18 08:51:01
2007-04-18 08:51:55
2007-04-18 08:52:07



Database closed.
Database dismounted.
ORACLE instance shut down.




ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 byte


total 1168
-rw-r-----  1 oracle oinstall 1095680 Apr 18 08:51 1_2.arc
-rw-r-----  1 oracle oinstall   69632 Apr 18 08:52 1_3.arc
-rw-r-----  1 oracle oinstall    4608 Apr 18 08:52 1_4.arc




total 1168
-rw-r-----  1 oracle oinstall 1095680 Apr 18 08:51 1_2.arc
-rw-r-----  1 oracle oinstall   69632 Apr 18 08:52 1_3.tmp
-rw-r-----  1 oracle oinstall    4608 Apr 18 08:52 1_4.arc



ORA-00279: change 208304 generated at 04/18/2007 08:45:15 needed for thread 1
ORA-00289: suggestion : /backup/archive/1_2.arc
ORA-00280: change 208304 for thread 1 is in sequence #2


Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 209118 generated at 04/18/2007 08:51:10 needed for thread 1
ORA-00289: suggestion : /backup/archive/1_3.arc
ORA-00280: change 209118 for thread 1 is in sequence #3
ORA-00278: log file '/backup/archive/1_2.arc' no longer needed for this recovery


ORA-00308: cannot open archived log '/backup/archive/1_3.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3



Database altered.



COL01
-------------------
2007-04-18 08:43:04
2007-04-18 08:51:01

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8799875/viewspace-914233/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8799875/viewspace-914233/