OracleDBs.com

Upon connecting as normal user, a warning message occurred as below: SQL> connect userid1/password Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected. To fix the warning, execute $ORACLE_HOME/sqlplus/admin/pup...

-- Grid Metric Threshold col used_percent for 999.99 col MB_FREE for 999,999,999.99 SELECT m.tablespace_name, m.used_percent, (m.tablespace_size - m.used_space)*t.block_size/1024/1024 mb_free FROM dba_tablespace_usage_metrics m, dba_tablespaces t, v$parameter p WHERE p.name ='statistics_level' AND p...

You can rename a permanent or temporary tablespace using the RENAME TO clause of the ALTER TABLESPACE.
For example, the following statement renames the OLDTBSP tablespace to NEWTBSP:

SQL> ALTER TABLESPACE OLDTBSP RENAME TO NEWTBSP;

- The below procedure is a step-by-step guide for installing Oracle Database 12c Release 1 (12.1.0.1.0) on 64-bit Architecture of: > Red Hat Enterprise Linux Server release 6* > Oracle Linux 6* Download Oracle Database 12c Release 1 Enterprise/Standard Edition for Linux x86-64: http://www.oracle.com...

1. Verify that the primary database can be switched to the standby role. Query the SWITCHOVER_STATUS column of the V$DATABASE view on the primary database. SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE; SWITCHOVER_STATUS -------------------- TO STANDBY ...

The following query can be used in a standalone or RAC environment: --On Standby: --(a) Role Verification set lines 1000 col STARTUP_TIME for a30 select DATABASE_ROLE, db_unique_name, i.INSTANCE_NAME, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, TO_CHAR(i.startup_time, 'DD/MM/YYYY HH24:MI:SS') as s...

The same procedure to follow as http://www.oracle-forums.com/recovery-from-loss-of-datafiles-on-the-primary-database-using-files-on-a-standby-database-t7252.html -or- To recover the standby database after the loss of one or more datafiles, you must restore the lost files to the standby database from...

As of Oracle 11g, you can use files on a standby database to recover a lost datafile. This works well if the standby is up-to-date and the network connection is sufficient enough to support the file copy between the standby and primary. Start RMAN and take the following steps to copy the datafiles f...

You can recover from loss of datafiles on the primary database by using backups or by using the files on a standby database. Scenario: data file 4: '+DATA/primary/datafile/users.286.807476425' has been corrupted. SQL> startup Oracle instance started database mounted RMAN-00571: =====================...

RUN { ALLOCATE CHANNEL ch00 TYPE DISK; BACKUP INCREMENTAL LEVEL=0 TAG='backup_tag_db' FILESPERSET 10 FORMAT '/u01/app/backup/primary_%s_%p_%t' (DATABASE include current controlfile); RELEASE CHANNEL ch00; #sql 'alter system archive log current'; # ## backup all archive logs ALLOCATE CHANNEL ch00 TYP...