This manual describes the ‘Installation of Oracle Spatial 11.2.0.4’. Prereq Installation of Oracle Enterprise Linux or other. Installation of Oracle Database Server 11.2.0.4. Software The necessary software Read more
This manual describes the ‘Installation of Oracle Spatial 11.2.0.4’. Prereq Installation of Oracle Enterprise Linux or other. Installation of Oracle Database Server 11.2.0.4. Software The necessary software Read more
This manual describes an overview of ‘RMAN (Recovery Manager) commands’ to make a backup and restore of a complete or partitial Oracle Database. A backup and restore of Read more
This manual describes an overview of some sql scripts related to the ‘Tablespace TEMP’. Prereq Installation of Oracle Enterprise Linux or other. Installation of Oracle Database Server Read more
This manual describes a method for a ‘RMAN Restore and Recover a Oracle Database using a Catalog Server’. Prereq Installation of Oracle Enterprise Linux or other. Read more
This manuel should be followed for new installations and upgrades affecting the first two numbers of the version (4.2 to 5.0) are done by doing a Read more
This manual is about removing a pluggable database from an existing container database. The multi-tenant option introduced in Oracle Database 12c can be a single Read more
This manuel describes the solution ORA-24247: network access denied by access control list (ACL). for the ACL’ss offers oracle more fine-grained access control for users Read more
This manual describes how to adjust the value of a sequence without dropping it. The solution is to set the INCREMENT BY value to the difference between the Read more
This manual describes the steps that are necessary to create a new database, with a new database name from a RMAN backup that is stored Read more
This manual describes the steps that are necessary to restore a RMAN backup to another server. The RMAN backup that is stored on disk.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
oracle> rman target / RMAN> startup nomount force; RMAN> restore spfile from '/u02/oradata/rman/c-1579753020-20140227-00'; Starting restore at 28-FEB-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=63 device type=DISKchannel ORA_DISK_1: restoring spfile from AUTOBACKUP /u02/oradata/rman/c-1579753020-20140227-00 channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete Finished restore at 28-FEB-14 RMAN> exit; oracle> sqlplus / as sysdba <span style="background-color: #cce4f5;">SQL> create pfile from spfile;</span> |
Now Read more