Solved

instance-recovery

Posted on 2011-03-24
5
619 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:ReliableDBA
Comment Utility
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 76

Expert Comment

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

Author Comment

by:nobleit
Comment Utility
I am connected to sys
0
 
LVL 8

Accepted Solution

by:
ReliableDBA earned 500 total points
Comment Utility
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 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
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.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now