Recover Redo01.dbf
============================
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP MOUNT;
SQL>SELECT GROUP#, ARCHIVED,STATUS FROM V$LOG;
1 NO CURRENT
2 YES INACTIVE
3 YES INACTIVE
SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
DROP logfile Group
====================
SQL>ALTER DATABASE DROP LOGFILE GROUP 1;
(Remove redo01.log manualy)
Create Logfile Group
====================
SQL>ALTER DATABASE ADD LOGFILE GROUP 1 ('/opt/app/oracle/oradata/scdcc/redo01.log') size 50000K;
SQL>ALTER DATABASE OPEN;
Subscribe to:
Post Comments (Atom)
How To Install LAMP on Ubuntu 12.04
L inux A pache M ySQL P HP Step One—Install Apache open terminal and type in these commands: s udo apt-ge...
-
The solution is used to copy archivelogs from RMAN catalog. Step 1: uncatalog the required archivelogs from RMAN prompt RMAN>CHANGE ARCHI...
-
Give name of manager and salary of employee SUNIL. SQL>select emp_company.salary,manager.mname from emp_company,manager ...
No comments:
Post a Comment