请教高手！ 这是我们都应该搞清楚的问题

Chinese_Dragon

1. 使用备份的控制文件，能否进行数据库的point in time 的恢复恢复到某个时间点。




2. 请教下面的错误，谁遇到过

oracle@was >;rman nocatalog cmdfile restore.sh

Recovery Manager: Release 9.2.0.6.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

RMAN>; connect target backup/backup@BJCNCSAP
2>; run {
3>; allocate channel t1 type 'SBT_TAPE'
4>; parms 'ENV=(NSR_SERVER=sun280,NSR_DATA_VOLUME_POOL=DB2,NSR_CLIENT=was)';
5>; restore
6>; (database);
7>; restore archivelog all;
8>; release channel t1;
9>; }
10>;
connected to target database: BJCNCSAP (DBID=3044881055)
using target database controlfile instead of recovery catalog

allocated channel: t1
channel t1: sid=12 devtype=SBT_TAPE
channel t1: NMO v4.1.0.0

Starting restore at 17-JUN-05

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/app/oradata/BJCNCSAP/system01.dbf
restoring datafile 00002 to /u02/app/oradata/BJCNCSAP/undotbs01.dbf
restoring datafile 00004 to /u02/app/oradata/BJCNCSAP/indx01.dbf
channel t1: restored backup piece 1
piece handle=BJCNCSAP561219293.49 tag=HOT_DB_BK_LEVEL0 params=NULL
channel t1: restore complete
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /u02/app/oradata/BJCNCSAP/cwmlite01.dbf
restoring datafile 00005 to /u02/app/oradata/BJCNCSAP/tools01.dbf
restoring datafile 00006 to /u02/app/oradata/BJCNCSAP/users01.dbf
restoring datafile 00007 to /u02/app/oradata/BJCNCSAP/appdata01.dbf
channel t1: restored backup piece 1
piece handle=BJCNCSAP561219408.50 tag=HOT_DB_BK_LEVEL0 params=NULL
channel t1: restore complete
Finished restore at 17-JUN-05

Starting restore at 17-JUN-05

channel t1: starting archive log restore to default destination
channel t1: restoring archive log
archive log thread=1 sequence=1
channel t1: restoring archive log
archive log thread=1 sequence=2
channel t1: restoring archive log
archive log thread=1 sequence=3
channel t1: restoring archive log
archive log thread=1 sequence=4
channel t1: restoring archive log
archive log thread=1 sequence=5
channel t1: restored backup piece 1
piece handle=arc_BJCNCSAP561219467.53 tag=TAG20050617T141747 params=NULL
channel t1: restore complete
Finished restore at 17-JUN-05

released channel: t1

Recovery Manager complete.
oracle@was >;sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jun 17 14:43:25 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL>; recover database until time '2005-06-17:14:13:00';
ORA-00279: change 193251 generated at 06/17/2005 14:14:53 needed for thread 1
ORA-00289: suggestion : /u02/app/arch/BJCNCSAP/archive/arch_1_2.dbf
ORA-00280: change 193251 for thread 1 is in sequence #2


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

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '/u02/app/oradata/BJCNCSAP/cwmlite01.dbf'


ORA-01112: media recovery not started


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 NORESETLOGS;
alter database open NORESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/app/oradata/BJCNCSAP/system01.dbf'


SQL>;  recover database until time '2005-06-17:14:13:00';
ORA-00279: change 193251 generated at 06/17/2005 14:14:53 needed for thread 1
ORA-00289: suggestion : /u02/app/arch/BJCNCSAP/archive/arch_1_2.dbf
ORA-00280: change 193251 for thread 1 is in sequence #2


Specify log: {<RET>;=suggested | filename | AUTO | CANCEL}
auto
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 3 was not restored from a sufficiently old backup
ORA-01110: data file 3: '/u02/app/oradata/BJCNCSAP/cwmlite01.dbf'


ORA-01112: media recovery not started