Monthly Archives: dicembre 2014

Copy asm datafile to another diskgroup
  • 29
    Dic

Copy asm datafile to another diskgroup

SQL> select file_name from dba_data_files where tablespace_name='TEST'; FILE_NAME ------------------------------------------------------ +DATA/TEST/datafile/test_01.363.837018395 SQL> alter database datafile '+DATA/TEST/datafile/test_01.363.837018395' offline; RMAN> copy datafile '+DATA/TEST/datafile/test_01.363.837018395' to '+DATA_2'; RMAN>run { set newname for datafile '+DATA/TEST/datafile/test_01.363.837018395' to '+DATA_2/TEST/datafile/test_01.264.837098131' ; switch datafile all; SQL> recover datafile '+DATA_2/TEST/datafile/test_01.264.837098131'; SQL> alter database datafile '+DATA_2/TEST/datafile/test_01.264.837098131' online; SQL> select file_name from dba_data_files where tablespace_name='TEST'; FILE_NAME ----------------------------- +DATA_2/TEST/datafile/test_01.264.837098131 SQL> alter diskgroup...

Read More
Oracle Invisible column
  • 15
    Dic

Oracle Invisible column

Starting from release 11g, Oracle has introduced good improvements with indexes invisible and virtual columns. Invisible column concepts has been introduced in Oracle 12c. You can now have an invisible column in a table. When a column is defined as invisible, the column won’t appear in generic queries until the column will be explicit in the sql statement....

Read More
Flash Recovery Area
  • 9
    Dic

Flash Recovery Area

Flash recovery area is an Oracle managed directory, file system, or Automatic Storage Management that provide a centralized disk location for backup and recovery files. It was introduced from Oracle 10g What is in it?  A copy of all datafiles;  Incremental backups;  Online redo logs;  Archived redo logs;  Controlfiles;  Copies of the...

Read More
Oracle, enforce password control
  • 1
    Dic

Oracle, enforce password control

Oracle's security (by default) is limited. A user can choose single character password and password that match their names, etc, . Also, password never expire. Oracle allowing to manage password through profiles. Following are some parameters that can be set in the user profile  FAILED_LOGIN_ATTEMPTS - failed login attempts before the account is locked  PASSWORD_LIFE_TIME -...

Read More