For example:Įmdwgrd -save -sid SID -path save_directoryĮmdwgrd -restore -tempTablespace TEMP -sid SID -path save_directory This is also needed for single instance if SID and database names are different.
When running emdwgrd on 11.2.0.1 Oracle RAC databases, you may need to pass an additional parameter, -serviceAlias, if you do not have system identifier (SID) aliases defined in tnsnames.ora. Without these patches, the emdwgrd utility would fail with IMPORT ( impdp) errors when restoring Database Control data. If you are upgrading from 11.2.0.1 to 11.2.0.3 and then plan to downgrade to 11.2.0.1, you need to apply the following patches in order to downgrade Database Control as part of the database downgrade: If the size is inadequate, then an ORA-19815 error will be written to the alert log, and the upgrade will stop until additional space is made available.ģ.1.6 Downgrading a Database Having Database Control ConfiguredĬonsider the following when downgrading the database while having Database Control configured (reference Bug 9922349): If you are using a Fast Recovery Area, then check that the size available is sufficient for the redo generated during the upgrade. If you are using file systems for data file storage, then be sure there is adequate space in the file systems for tablespace growth during the upgrade.
However, to avoid potential space problems during either a manual upgrade or an upgrade using the Database Upgrade Assistant (DBUA), you can set one data file for each tablespace to AUTOEXTEND ON MAXSIZE UNLIMITED for the duration of the upgrade. The tablespace size estimates may be too small, especially if Oracle XML DB is installed in your database. For a manual upgrade, be sure to run this utility on your existing database prior to upgrading. The Oracle Database 11 g Pre-Upgrade Information Utility ( utlu112i.sql) estimates the additional space that is required in the SYSTEM tablespace and in any tablespaces associated with the components that are in the database (for example, SYSAUX, DRSYS) (reference Bug 13067061). Section 3.15, "Oracle Real Application Clusters"įast Recovery was previously known as Flash Recovery. Section 3.11, "Oracle Grid Infrastructure for a Cluster" Section 3.8, "Oracle Application Express" Section 3.5, "Oracle Automatic Storage Management (Oracle ASM)" Section 3.2, "Features Not Available or Restricted in 11.2.0.3" Section 3.1, "Compatibility, Upgrading, Downgrading, and Installation"
This section of the Readme contains the following sub-sections: Note: If you are on Oracle Database 11 g Release 2 (11.2.0.3), this is the Readme section that you need to read.
0 kommentar(er)
