Hot answers tagged

2 votes
Accepted

Why a consistent backup still requery recovery in Oracle?

How to restore cold backup of database taken using Rman (Doc ID 1391384.1) Summary of steps: Step 1 :- Startup Nomount the database Step 2 :- Restore controlfile from the backuppiece. Step 3 :- Mount ...
Balazs Papp's user avatar
  • 40.6k
1 vote

How to recover the standby database after opening

It is not possible to do that with recovery only. The standby database that was opened in read/write mode must be flashed backed to a point before it was opened. This concept is called "snapshot ...
Balazs Papp's user avatar
  • 40.6k
1 vote

How to determine if it is necessary to increase the sga and the pga in Oracle database

This query will show you what the database would like for the SGA. A similar query is possible for the PGA. SELECT TO_CHAR( al.execution_start, 'dd Mon yyyy HH24:MI:SS') AS finding_time aa....
Strider's user avatar
  • 11

Only top scored, non community-wiki answers of a minimum length are eligible