Today I faced a recovery issue with one of my database.
Media Recovery:
Database Name: xxxxxx
OS : SunOs
Alertlog Error Message:
CJQ0: terminating instance due to error 472
Instance terminated by CJQ0, pid = 9963
Step 1 :When manually tried to start the database below error occured.
Cause:
SQL> startup open
ORACLE instance started.
Total System Global Area 338657376 bytes
Fixed Size 729184 bytes
Variable Size 234881024 bytes
Database Buffers 100663296 bytes
Redo Buffers 2383872 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/u02/oradata/xxxxxx/system01.dbf'
Step 2: Verified all the archivelogs are in place and recovered the database.
SQL> recover database;
Media recovery complete.
SQL> alter database open
2 /
NAME OPEN_MODE LOG_MODE
--------- ---------- ------------
xxxxxx READ WRITE ARCHIVELOG
Jun 6, 2010
Jun 3, 2010
dbms_jobs execution.
Condition to be checked :
1) Check for job_queue_processess is more than 0 ( if it set to zero , no job will be running at database level).
2) Run the job as the job owner.
3) Check for the database instance is in restricted mode.
1) Check for job_queue_processess is more than 0 ( if it set to zero , no job will be running at database level).
2) Run the job as the job owner.
3) Check for the database instance is in restricted mode.
apex installation in oracle 10.2.0.4
Introduction about Apex :
http://www.oracle.com/pls/ebn/swf_viewer.loadp_shows_id=6392594&p_referred=0&p_width=800&p_height=600
will be continued......
http://www.oracle.com/pls/ebn/swf_viewer.loadp_shows_id=6392594&p_referred=0&p_width=800&p_height=600
will be continued......
Subscribe to:
Posts (Atom)
