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...
-
How to search on Google Tip 1: Keep it simple No matter what you're looking for, try to start with a simple search like [ whe...
No comments:
Post a Comment