Database Backup and Recovery (MOSC)

MOSC Banner

database home

edited Feb 21, 2011 4:50AM in Database Backup and Recovery (MOSC) 5 commentsAnswered
Hello,

I have a database that was working fine in December, now that I try to submit, I get error
the database is oracle 8i standard edition 8.1.7.4.1 , sistem operativ Windows Server 2003 R2 - 32 bits
SQL> startup pfile=C:\Copiarchive\initcontingencia.ora;
ORACLE instance started.
Total System Global Area 1168050204 bytes
Fixed Size                    75804 bytes
Variable Size             796254208 bytes
Database Buffers          368640000 bytes
Redo Buffers                3080192 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL>  ALTER DATABASE RECOVER  database UNTIL TIME '2010-11-20:17:00:00' using ba
ckup controlfile;
 ALTER DATABASE RECOVER  database UNTIL TIME '2010-11-20:17:00:00' using backup

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