-
if I lost "all" redo log and control file, how I recover them?
without redo log, I can not recreate control file
without control file, I can not open database to switch logfile
then recreate redo log.
any help will be appreciated
XDBA
-
Restore from the most recent backup and recover the db.
-
Restore the latest backup.
Recover it.
U can recover it till the latest Arch is available.
Thanks
Kishore Kumar
-
as I understand, redo file never been backup. correct?
after restore the control file I only can startup mount,
drop inactive redo groups (logically) and recreate them.
since db not open I can not switch log it means I can not drop and recreate the current one. ... ???
please help me
XDBA
-
Open the db and then drop/recreate the redo log files.
-
here is the real example:
>startup mount; (can not open becasue control file restored from backup)
> select group#, status from v$log;
GROUP# STATUS
---------- ----------------
1 INACTIVE
2 CURRENT
3 INACTIVE
>alter system drop logfile group 1;
>alter system add logfile group 1 '/ora.......
>alter system drop logfile group 3;
>alter system add logfile group 3 '/ora.......
> select group#, status from v$log;
GROUP# STATUS
---------- ----------------
1 UNUSED
2 CURRENT
3 UNUSED
now how I drop group2?
without system open I can not do:
alter system switch logfile;
I dooooommmmed? any solution?
XDBA
-
lost all control file, all redo logs
1. shutdown the database
2. Recover latest backup
3. startup nomount
4. create control file
5. recover database until cancel using backup controlfile;
this will recover using the archived logs until you stop it
6. alter database open resetlogs;
database should open successfully
You dont need to drop/recreate redo logs sicne resetlogs will create the log groups
-
PANDO,
I use this trace file to create control file (step 4) and oracle complain can not locate redo log file ... this is why I can not
move to step 5 and 6...
CREATE CONTROLFILE REUSE DATABASE "DBU2" NORESETLOGS ARCHIVELOG
MAXLOGFILES 3
MAXLOGMEMBERS 3
MAXDATAFILES 62
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 (
'/ora/redo1/DBU2/redoDBU201.log',
'/ora/redo2/DBU2/redoDBU201.log',
'/ora/redo3/DBU2/redoDBU201.log'
) SIZE 5M,
GROUP 2 (
'/ora/redo1/DBU2/redoDBU202.log',
'/ora/redo2/DBU2/redoDBU202.log',
'/ora/redo3/DBU2/redoDBU202.log'
) SIZE 5M,
GROUP 3 (
'/ora/redo1/DBU2/redoDBU203.log',
'/ora/redo2/DBU2/redoDBU203.log',
'/ora/redo3/DBU2/redoDBU203.log'
) SIZE 5M
DATAFILE
'/ora/dat1/oradata/DBU2/system01.dbf',
'/ora/dat1/oradata/DBU2/rbs01.dbf',
'/ora/dat2/oradata/DBU2/temp01.dbf',
....
XDBA
-
You have all the paths created already?
As you don't have ONLINE REDO I think you should put RESETLOGS instead of NORESETLOGS
Don't forget putting the Oracle error so we can help better.
-
rcaballe, pando,
I use
>create control file ... resetlog ...
>recover database until cancel using backup controlfile;
>alter database open resetlogs
it works!!!
thanks you both are good.
XDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|