by mawundaga | Nov 1, 2020 | oracle Backup & Recovery, Oracle File System
Question : A datafile was wrongly added on file system instead of ASM diskgroup. How can you move it to the ASM disk group? As root: [root@L160 ~]# mkdir -p /u02/oradata/PDEV chown -R oracle:oinstall /u02/oradata  As oracle: sqlplus system/sys@PDEV drop tablespace...
by mawundaga | Jan 9, 2018 | Dataguard, oracle Administration, oracle Backup & Recovery
Find the LAD (log_archive_dest_n) and the db_unique_name for the Standby that is being removed: show parameter log_archive_dest_ Take note of those that have values such as: log_archive_dest_1                  string     LOCATION=+RECOC1 VALID_FOR=(AL...
