How to Copy Only Contacts, Notes and Messages from iTunes after iPhone Factory Restore?

Recently I had a requirement to restore the phone to the factory default and copy only Contacts, Notes and Messages because of the LowMemory issues with my phone. I have faced lot of issues after the iOs 7 upgrade and LowMemory issue was one the one of the major one. It used to crash at least one or twice because of the low memory issue and it used to log in diagnostic report. (Settings->General->About->Diagnostics&Usage->Diagnostics & Usage Data). To fix that issue I restored the phone to the factory default and restored only contact, message and notes.

Fix: iPhone Old Messages are not Indexing in the Spotlight search after the iOS 7 Upgrade

I have done the iOS 7.1.2 upgrade in my iPhone 4 recently. My iPhone was pretty stable with the iOS 6.0.1. Due to some mandatory requirement for the OS upgrade I have performed the iOS 7 upgrade. After upgrading my iPhone 4 to iOS 7, I feel there are lot of positives and negatives. The iOS 7 gives new look and feel to the phone but I lost my stability with the phone. Lot of performance issues started with the phone like it won’t respond to our touches as looks like the phone is quite busy. Sometimes the apps are getting crashes.

Database in READ WRITE Mode; desc dba_ gives error ;ORA-04043

Error Description:
The database was working perfectly and there was no major changes done in the database. Database is in Open mode (read write); But still the describe the data dictionary views like DBA_tables gives following error.
 
SQL> desc dba_tables
ERROR:
ORA-04043: object dba_tables does not exist
 
Solution Description
 

Solve ORA-39170: Schema expression 'OPS' does not correspond to any schemas

Error Description:
Data pump expdp failed with following error message.
$ expdp directory=exp_dir schemas=ops$jobs dumpfile=exp.dmp logfile=exp.log
Export: Release 11.2.0.3.0 - Production on Thu Sep 4 07:30:24 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39170: Schema expression 'OPS' does not correspond to any schemas.
 

How to Find out / Check SGA and PGA size of Oracle Database?

SGA Size
Generally SGA_TARGET shows the value of SGA. It can be increased up to sga_max_size.
But if you have enabled automatic memory management the (non-zero values for Memory_ parameters) the value for the memory_target will be consisderred for the SGA.
In below mentioned example automatic memory management is enabled and its value is 10G.

Find out Database Growth Month by Month Using V$datafile - Creation_time

In v$datafile there is a field called creation_time and this field is having the datafile creation date. Suppose if you are database's space addition generally happening by adding the data file then you can easily find out the database growth using this column.

This method will not be effective in the following cases.

a. If you are resizing the existing file this method will not be effective as it records the datafile creation date.

How to Check the Required Data is Present in Flashback Database or not for Recovery?

Here is the query to find out whether you can recover the lost data using the flashback database option.

SQL>select to_char(OLDEST_FLASHBACK_TIME,'dd-mm-yyyy hh:mi'), to_char(sysdate,'dd-mm-yyyy hh:mi') FROM V$FLASHBACK_DATABASE_LOG;

TO_CHAR(OLDEST_F TO_CHAR(SYSDATE,
---------------- ----------------
28-06-2014 01:34 28-08-2014 02:19

Here in above result we have the data from 28th of June as the transaction is very less with the database. Almost 2 months data can be flashback.

 

dba topics. Copyright 2011-14 All Rights Reserved | Site Map | Contact | Disclaimer | Google