Database Backup and Recovery (MOSC)

MOSC Banner

Recover problem

edited Nov 6, 2013 1:32AM in Database Backup and Recovery (MOSC) 9 commentsAnswered
I transferred the files from one server to another and then created the control file in target database.
Below were the steps which I folowed

SQL>  alter database open resetlogs;
 alter database open resetlogs
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/qaoragridcn_01/app/oracle/product/11203/dbs/oradata/database/alfresqa/redo02.l
og'
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 1


SQL> alter database drop logfile group 2;

Database altered.

alter database open resetlogs;
Total System Global Area 1068937216 bytes
Fixed Size                  2228344 bytes
Variable Size             675286920 bytes
Database Buffers          385875968 bytes

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