Database Backup and Recovery (MOSC)

MOSC Banner

Database not up need recovery

edited Jul 22, 2009 2:22AM in Database Backup and Recovery (MOSC) 16 commentsAnswered
Dear Seniors

Iam using ASM diskgroup and rman for recovery

I tried to tsart it once again it gave me following error

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: '+DG1/test/datafile/system.709.592571019'
 

then querried

-----------------------------------------------------------------------------------------------------------------

SQL> archivelog list
SP2-0734: unknown command beginning "archivelog..." - rest of line ignored.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +DG1/test/
Oldest online log sequence     4994
Next log sequence to archive   4995
Current log sequence           4995
SQL> select * from v$log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center