?
Solved

instance-recovery

Posted on 2011-03-24
5
Medium Priority
?
661 Views
Last Modified: 2012-05-11
in oracle 11g

may I know why this query is not working

sql>desc v$instance_recovery;

error listed:


SQL> desc v$instance_recovery;
ERROR:
ORA-04043: object "SYS"."V_$INSTANCE_RECOVERY" does not exist

0
Comment
Question by:nobleit
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:Chakravarthi Ayyala
ID: 35211985
In Oracle 11g, found the following as the referrence for v_$instance_Recovery.
looks like some scripts were not run post DB creation.
=========================================================
cdfixed.sql:create or replace public synonym v$instance_recovery for v_$instance_recovery;
=========================================================
0
 
LVL 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35212005
Are you connected as SYS or SYSTEM?
0
 

Author Comment

by:nobleit
ID: 35212018
I am connected to sys
0
 
LVL 8

Accepted Solution

by:
Chakravarthi Ayyala earned 2000 total points
ID: 35212090
working for me.
SQL> show user
USER is "SYS"
SQL>  select * from v$version ;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

5 rows selected.

SQL> desc v_$instance_recovery
 Name                                                                                                              Null?    Type
 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
 RECOVERY_ESTIMATED_IOS                                                                                                     NUMBER
 ACTUAL_REDO_BLKS                                                                                                           NUMBER
 TARGET_REDO_BLKS                                                                                                           NUMBER
 LOG_FILE_SIZE_REDO_BLKS                                                                                                    NUMBER
 LOG_CHKPT_TIMEOUT_REDO_BLKS                                                                                                NUMBER
 LOG_CHKPT_INTERVAL_REDO_BLKS                                                                                               NUMBER
 FAST_START_IO_TARGET_REDO_BLKS                                                                                             NUMBER
 TARGET_MTTR                                                                                                                NUMBER
 ESTIMATED_MTTR                                                                                                             NUMBER
 CKPT_BLOCK_WRITES                                                                                                          NUMBER
 OPTIMAL_LOGFILE_SIZE                                                                                                       NUMBER
 ESTD_CLUSTER_AVAILABLE_TIME                                                                                                NUMBER
 WRITES_MTTR                                                                                                                NUMBER
 WRITES_LOGFILE_SIZE                                                                                                        NUMBER
 WRITES_LOG_CHECKPOINT_SETTINGS                                                                                             NUMBER
 WRITES_OTHER_SETTINGS                                                                                                      NUMBER
 WRITES_AUTOTUNE                                                                                                            NUMBER
 WRITES_FULL_THREAD_CKPT                                                                                                    NUMBER

SQL>
0
 
LVL 79

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35212493
Can I ask what the problem was?

The question was about the synonym v$instance_recovery not the sys view v_$instance_recovery.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question