OracleDBs.com

All databases: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR; RMAN> CONFIGURE CHANNEL DEVICE TYPE SBT PARMS '<channel parameters>'; RMAN Configurations at the Primary Database The following RMAN configurations are recommended at t...

-- |-----------------------------------------------------------------------------| -- | Changing SYS Password | -- | In A RAC/DG Environment | -- |-----------------------------------------------------------------------------| -- | DATABASE : Oracle Database 11gR2 | -- | PURPOSE : This guide will he...

See the below RMAN script: INCREMENTAL LEVEL=0 Backup RUN { ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE'; ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE'; SEND 'NB_ORA_POLICY=NB_POLICY'; BACKUP INCREMENTAL LEVEL=0 FILESPERSET 10 FORMAT 'de...

Issue: You are getting an error in LogTransportService PING[ARC0]: Heartbeat failed to connect to standby . Error is 1031. Explanation: oerr ora 01031 01031, 00000, "insufficient privileges" // *Cause: An attempt was made to change the current username or password // without the appropria...

11.2.0.2.0/RHEL 5.6 In one of our DBs , because of archiver error , we want to increase the space in file system which host the archive logs. This DB uses FRA, so it is showing USE_DB_RECOVERY_FILE_DEST. So, how to find the actual filesystem which stores the archive logs? SQL> show parameter log_arc...

http://www.oracle-forums.com was recently migrated successfully to its new web hosting, http://www.solidhosting.ph. Solidhosting.ph is one of the companies that operate cPanel servers in the Philippines. The hosting includes the following features: Control Panel Acceptable Disk Space Allocation and ...

Check the SCAN IP config:

[oracle@server1 oracle]$ srvctl config scan

1. Export: nohup expdp "" '/ as sysdba' "" directory=DBA_EXP dumpfile=emjo.table1_table2_%u.dmp tables=user.table1,user.table2 logfile=expdp_table1_table2.log &" 2. Delete records. 3. Backout A) Import the 2 tables into a new table name. A-1 nohup impdp " '/ as sysd...

Displays the current state of the database. srvctl status database -d <db_unique_name> -v -d <db_unique_name> Unique name for the database -f Include disabled applications -v Verbose output -h Print usage Displays the current state of the database instance. srvctl status instance -d <db_unique_name>...