ERROR: ORA-01152: file 1 was not restored from a sufficiently old backup

[root@DBServer /]# su - oracle
[oracle@DBServer ~]$ . oraenv
ORACLE_SID = [oracle] ? orcl
[oracle@DBServer ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Dec 2 11:55:23 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied (for this problem read here for a solution)

[root@DBServer /]# orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password="oracle" entries=10 force=y

Enter user-name: sys / as sysdba
Enter password:
Connected to an idle instance.

SQL> startup nomount pfile=$ORACLE_HOME/dbs/initorcl.ora
ORACLE instance started.

Total System Global Area    3.2E+09 bytes
Fixed Size                  2257520 bytes
Variable Size               2.1E+09 bytes
Database Buffers            1.1E+09 bytes
Redo Buffers                1.7E+07 bytes
SQL> alter database mount;

Database altered.
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;
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: '/u01/app/oracle/dbs/orcl/datafile/system.dbf'

SQL> recover database using backup controlfile until cancel
ORA-00279: change 304977 generated at 12/02/2015 11:29:44 needed for thread 1
ORA-00289: suggestion : /u01/app/oracle/fra/orcl/archivelog/2015_12_02/o1_mf_1_3_%u_.arc
ORA-00280: change 304977 for thread 1 is in sequence #3

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/u01/app/oracle/fra/orcl/archivelog/2015_12_02/o1_mf_1_3_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/u01/app/oracle/fra/orcl/archivelog/2015_12_02/o1_mf_1_3_%u_.arc'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

[oracle@DBServer ~]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Dec 2 14:07:43 2015

RMAN> connect target sys/oracle

connected to target database: orcl (DBID=421551639, not open)
using target database control file instead of recovery catalog

RMAN> STARTUP FORCE MOUNT;

Oracle instance started
database mounted

Total System Global Area 3206836224 bytes

Fixed Size                     2257520 bytes
Variable Size               2080378256 bytes
Database Buffers            1107296256 bytes
Redo Buffers                  16904192 bytes

RMAN> RESTORE DATABASE;

Starting restore at 02-dec-2015 15:04:24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/02/2015 15:04:25
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN> RECOVER DATABASE;

Starting recover at 02-dec-2015 15:04:36
using channel ORA_DISK_1

starting media recovery

unable to find archived log
archived log thread=1 sequence=3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 12/02/2015 15:04:37
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 3 and starting SCN of 304977

RMAN> alter database open;

RMAN> alter database open resetlogs;

database opened

RMAN>

HomeG Wiki

ERROR: ORA-01152: file 1 was not restored from a sufficiently old backup

No Comments

Geef een reactie Reactie annuleren