Oracle Database recover,Oracle 10 flashback,Oracle 10g

Shut down Your Database Server or Un mount Database
How to Oracle Database Flash Back Recovery

Follow the Important Instruction:

C:\Documents and Settings\Administrator>sqlplus "/as sysdba"

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> select * from v$recover_file;

FILE# ONLINE ONLINE_ ERROR
CHANGE# TIME
---------- ------- ------- -----------------------------------------------------
ONLINE ONLINE

SQL> select file#, name from v$datafile;

FILE#
----------
NAME
1 F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSTEM01.DBF
2 F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\UNDOTBS01.DBF

3 F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSAUX01.DBF
FILE#
NAME
--------------------------------------------------------------------------------
4 F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\USERS01.DBF
5 F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\EXAMPLE01.DBF

SQL> select status from v$instance;

STATUS
------------
MOUNTED

SQL> alter database open;

ORA-01113: file 3 needs media recovery
ORA-01110: data file 3:

F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSAUX01.DBF'

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 235
Current log sequence 237
SQL> shutdown immediate;
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 2006096 bytes
Variable Size 264242096 bytes
Database Buffers 327155712 bytes
Redo Buffers 6381568 bytes
Database mounted.

SQL> select name from v$datafile;

NAME
------------------------------------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSTEM01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\UNDOTBS01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSAUX01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\USERS01.DBF
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\EXAMPLE01.DBF
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\TEMP01.DBF
SQL> select name from v$controlfile;
NAME
------------------------------------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL01.CTL
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL02.CTL
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL03.CTL
SQL> select member from v$logfile;
MEMBER
------------------------------------------------------------------------------------------------------------
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO03.LOG
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO02.LOG
F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO01.LOG

SQL> spool 'F:\back_padma\back_script.sql'
SQL> set heading off
SQL> select 'host copy '|| name||' F:\back_padma\back_script.sql ' from v$datafile;

host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSTEM01.DBF F:\back_padma\back_script.sql
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\UNDOTBS01.DBF F:\back_padma\back_script.sql
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSAUX01.DBF F:\back_padma\back_script.sql
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\USERS01.DBF F:\back_padma\back_script.sql
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\EXAMPLE01.DBF F:\back_padma\back_script.sql

SQL> select 'host copy '|| name||' F:\back_padma\back_script.sql ' from v$tempfile;

host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\TEMP01.DBF F:\back_padma\back_script.sql

SQL> select 'host copy '|| name||' F:\back_padma\' from v$datafile;
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSTEM01.DBF F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\UNDOTBS01.DBF F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\SYSAUX01.DBF F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\USERS01.DBF F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\EXAMPLE01.DBF F:\back_padma\
SQL> select 'host copy '|| name||' F:\back_padma\’ from v$tempfile;
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\TEMP01.DBF F:\back_padma\
SQL> select 'host copy '|| name||' F:\back_padma\’ from v$controlfile;
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL01.CTL F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL02.CTL F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\CONTROL03.CTL F:\back_padma\
SQL> select 'host copy '|| member||' F:\back_padma\’ from v$logfile;
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO03.LOG F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO02.LOG F:\back_padma\
host copy F:\ORACLE\PRODUCT\10.2.0\ORADATA\PADMA\REDO01.LOG F:\back_padma\
SQL> spool off
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> @F:\back_padma\back_script.sql
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
1 file(s) copied.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 2006096 bytes
Variable Size 264242096 bytes
Database Buffers 327155712 bytes
Redo Buffers 6381568 bytes
Database mounted.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 599785472 bytes
Fixed Size 2006096 bytes
Variable Size 264242096 bytes
Database Buffers 327155712 bytes
Redo Buffers 6381568 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;
Database altered.
SQL> select status from v$instance;
OPEN
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2006096 bytes
Variable Size 260047792 bytes
Database Buffers 331350016 bytes
Redo Buffers 6381568 bytes
Database mounted.
Database opened.

Please Visit top and right side bar Advertisement for more help..