Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Dec 8th, 2011

 

Create pfile from spfile
Edit pfile with _allow_resetlog_currpuation=true

1) Connect / as sysdba
2) Startup
3) Recover database until cancel;
4) Alter database open resetlogs;

In RMAN restore:

RMAN> RESTORE CONTROLFILE FROM '[[Location]]';
RMAN> ALTER DATABASE MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE UNTIL TIME "[[Time]]";
RMAN> ALTER DATABASE OPEN RESETLOGS;

Amresh Panda

• Sep 12th, 2017

 

When One of the Online redo log file is missing fast we know is that current or active or inactive because when current and active is missing then DB is crashed but inactive or unused case db not gone to crashed.

When db crashed that time we restore all files controlfile, datafiles from backup then go to mount state and recover until cancel
then we go to open state after that go to resetlog. then db is open and running fine but hear some data loss is happen.