Count Total Number of Users Connected to ORACLE Ap compile invalid objects in an R12 APPS Environment. # * PLATFORM: Linux/Solaris/HP-UX/AIX * Connected to an idle instance. Restore the database from following script: 1.

5. set until time "to_date('2015/02/27 12:52:00','yyyy/mm/dd HH24:MI:SS')"; This is the beauty of using RMAN. channel chnl1: starting archived log backup set For details, please run show all command so that you will come to know where backup will go. Please install version 1.1.8.2 or higher". #***********************************************************************, # Check the login user to be oracle 3. # 11> connect as sysdba only until resolved. 4> allocate channel chnl2 device type disk; allocate channel ch01 type disk; CONFIGURE ENCRYPTION FOR DATABASE OFF; # default OR Hi, event, I am always torn. The following, How to combine Oracle .ova files Run the following command to combine the .ova files into one .ova file: On Linux: cat Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova* > EM12cR6.ova On Windows: type Oracle-E-Business-Suite-12.2.6_VISION_INSTALL.ova* > EM12cR6.ova. 2) ensure that controlfile autobackup is on; If not please change the same using following command @ RMAN prompt. release channel t1; allocate channel ch00 type disk; RMAN doesnt know this, it expects them!

allocate channel t2 type DISK; } allocated channel: chnl1 the sites that say this happened on the 22nd of July. For any work, queries and help. With this retention policy RMAN will keep archive logs and backup files necessary to recover to any point of time within those 2 days in the recovery window. With this retention policy RMAN will keep archive logs and backup files necessary to recover to any point of time within those 2 days in the recovery window. connect as sysdba only until resolved. export PATH=$ORACLE_HOME/bin;$PATH Oracle RMAN Database Incremental Backup Script Ahmed Abdel Fattah Blog . Finished backup at 08-OCT-11, Starting backup at 08-OCT-11 echo >> $lg (LogOut/ 4. Well, unless you have lots of money to allocate for storage, we know that is not practical to keep all archivelogs and with OS backups usually we delete them manually according to the chosen backup retention pollicy. The script once run initially will fail like this: oracle@localhost.localdomain:/u01 [TESTDB] >tail -f nohup.out, channel RMAN_BACK_CH01: starting compressed full datafile backup set, channel RMAN_BACK_CH01: specifying datafile(s) in backup set, input datafile file number=00001 name=/u01/app/oracle/oradata/TESTDB/system01.dbf, input datafile file number=00002 name=/u01/app/oracle/oradata/TESTDB/sysaux01.dbf, input datafile file number=00005 name=/u01/app/oracle/oradata/TESTDB/example01.dbf, input datafile file number=00003 name=/u01/app/oracle/oradata/TESTDB/undotbs01.dbf, input datafile file number=00004 name=/u01/app/oracle/oradata/TESTDB/users01.dbf, channel RMAN_BACK_CH01: starting piece 1 at 24-FEB-17, channel RMAN_BACK_CH01: finished piece 1 at 24-FEB-17, piece handle=/u01/databasefiles_TESTDB_08rtdekk_8_20170224 tag=TAG20170224T193547 comment=NONE, channel RMAN_BACK_CH01: backup set complete, elapsed time: 00:01:25, Starting Control File and SPFILE Autobackup at 24-FEB-17, piece handle=/u01/autobackup_control_filec-2720074507-20170224-01 comment=NONE, Finished Control File and SPFILE Autobackup at 24-FEB-17, sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT, channel RMAN_BACK_CH01: starting compressed archived log backup set, channel RMAN_BACK_CH01: specifying archived log(s) in backup set, input archived log thread=1 sequence=4 RECID=1 STAMP=936819434, input archived log thread=1 sequence=5 RECID=2 STAMP=936819434, piece handle=/u01/archivelogs_TESTDB_0artdenb_10_20170224 tag=TAG20170224T193714 comment=NONE, channel RMAN_BACK_CH01: backup set complete, elapsed time: 00:00:01, channel RMAN_BACK_CH01: deleting archived log(s), archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_4_936746381.dbf RECID=1 STAMP=936819434, archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_5_936746381.dbf RECID=2 STAMP=936819434, including current control file in backup set, piece handle=/u01/controlfile_TESTDB_0brtdenc_11_20170224 tag=TAG20170224T193716 comment=NONE, piece handle=/u01/autobackup_control_filec-2720074507-20170224-02 comment=NONE, crosschecked backup piece: found to be 'AVAILABLE', backup piece handle=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/02rtb8fk_1_1 RECID=1 STAMP=936747510, backup piece handle=/u01/rman_bkp_04rtb8gl_1_1 RECID=2 STAMP=936747542, backup piece handle=/u01/controlfile_TESTDB_05rtdegg_5_20170224 RECID=3 STAMP=936819217, backup piece handle=/u01/autobackup_control_filec-2720074507-20170224-00 RECID=4 STAMP=936819218, backup piece handle=/u01/databasefiles_TESTDB_08rtdekk_8_20170224 RECID=5 STAMP=936819348, backup piece handle=/u01/autobackup_control_filec-2720074507-20170224-01 RECID=6 STAMP=936819433, backup piece handle=/u01/archivelogs_TESTDB_0artdenb_10_20170224 RECID=7 STAMP=936819435, backup piece handle=/u01/controlfile_TESTDB_0brtdenc_11_20170224 RECID=8 STAMP=936819437, backup piece handle=/u01/autobackup_control_filec-2720074507-20170224-02 RECID=9 STAMP=936819438, RMAN retention policy will be applied to the command, RMAN retention policy is set to recovery window of 2 days, specification does not match any backup in the repository. Oracle RMAN Database Full Cold Backup Script Ahmed Abdel Fattah Blog ! alter database mount; channel chnl2: starting piece 1 at 08-OCT-11 export ORACLE_SID=ORCL #fi, # Check that the user passed one parameter piece handle=/u01/product/flash_recovery_area/TEST/autobackup/2011_10_08/o1_mf_s_764028354_790yzbjq_.bkp comment=NONE Oracle Data Pump (expdp and impdp) in Oracle Datab Oracle export / import utility (exp / imp). backupformat '/rmanbackup/full_db_%t_%p%p'filesperset 10database plus archivelog; 1. channel chnl2: backup set complete, elapsed time: 00:00:01 input datafile file number=00003 name=/u01/product/oradata/TEST/undotbs01.dbf run { Change). 10> } You can also use RMAN single script for restore as follows :

Current wait states for all active database sessio Finding products installed for Oracle R12 E-Busine Find applied patches for R12 EBS Oracle Applications, Profile Set Oracle E-Business SuiteR12.1.1, User Profile Options Setting (Oracle Applications). release channel t1; piece handle=/u01/product/flash_recovery_area/TEST/backupset/2011_10_08/o1_mf_ncnnf_TAG20111008T220552_790yz96d_.bkp tag=TAG20111008T220552 comment=NONE Change). recover database; set until time "to_date('2015/02/27 12:52:00','yyyy/mm/dd HH24:MI:SS')"; }. allocate channel t1 type DISK;

To continue this discussion, please ask a new question. No RECOVERY CATALOG is being used with this script, instead database controlfiles are used to record the RMAN repository information. Make sure you set the rman CONFIGURE CONTROLFILE AUTOBACKUP parameter to ON in in RMAN in order to take extra backups of the controlfile and spfile (RMAN will not backup init.ora files) as extra protection. the above command will perform the RMAN hot backup. (LogOut/ CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default # -, if [ $# -lt 1 ] ; then #not given enough parameters to script exit 1 Thank you for supplying this information. Change), You are commenting using your Facebook account. channel chnl1: specifying datafile(s) in backup set

echo You should login as oracle user This was an extremely wonderful post. # $Header: abc_rman_full_hot_bkp.sh * release channel ch01; Fill in your details below or click an icon to log in: You are commenting using your WordPress.com account.

status of buffers in the SGA Scripts (10g). Pretty! 6. Backup format '/rmanbackup/spfile_%s_%p_%t' spfile; One is that staff are given a laptop with a local login. # * Author: Ahmed Abdel Fattah * A backup retention policy with a recovery window of 2 days is defined in this script. echo ============================================================ >> $lg. channel chnl1: finished piece 1 at 08-OCT-11 This script will delete obsolete backups and not needed archive logs from the disks only after a successful backup. Empty the oradata folder for completed restore. piece handle=/u01/product/flash_recovery_area/TEST/backupset/2011_10_08/o1_mf_annnn_TAG20111008T220550_790yz6vn_.bkp tag=TAG20111008T220550 comment=NONE I've read several articles on the inte TL;DR: 3 desktops are having 3 different, but potentially related problems, and I don't know if they're caused by bad power coming in, updates, or something else. sql "alter database open resetlogs"; release channel ch00;

1) here i have not specified any location for backup so it goes to default location. We have about 30 users in the office using a mix of Lenovo and Dell l Hello All,Basically, around a few months ago we ordered a new server to replace our current one, however, to make this move a little more pain free I am planning on running both servers, side by side, to handle operations until the older one meets its end Hi All,I started in this role around 9 months ago and I've inherited lots and lots of 'interesting' ways of doing things. CONFIGURE SNAPSHOT CONTROLFILE NAME TO /u01/product/db/dbs/snapcf_TEST.f; # default, -bash-3.2$ rman target / @DB_HOT_BACKUP_using_RMAN.rc, Recovery Manager: Release 11.2.0.1.0 Production on Sat Oct 8 22:04:37 2011, connected to target database: TEST (DBID=2058381472), RMAN> run release channel chnl1; The following unix shell script will do a full RMAN hot backup to your database and will copy the backup files compressed to the directory you will specify. !!! The size of the trace file in Oracle determined by the parameter is max_dump_file_size. Change), You are commenting using your Twitter account. channel chnl1: SID=22 device type=DISK, allocated channel: chnl2 #oh=$ORACLE_HOME #************************************************************************ Oracle Technology blog about Oracle Database , RAC , Visualization, Performance etc. #then Connect with RMAN and execute the file which is in next step or save this line in bat file release channel ch00; CONFIGURE ENCRYPTION ALGORITHM AES128; # default CONFIGURE MAXSETSIZE TO UNLIMITED; # default (LogOut/ channel chnl1: specifying datafile(s) in backup set

8. sqlplus / as sysdba 7. Total System Global Area 1653518336 bytes Fixed Size 2228904 bytes Variable Size 956304728 bytes Database Buf, 1) Log in to the first database server as root. channel chnl1: backup set complete, elapsed time: 00:00:01 connected to target database: TEST (DBID=2058381472) possible that this happened o Hello Everyone,I'm doing research on what we will need to do in order to migrate from Folder Redirection to OneDrive Known Folder Move. Older backups and archivelogs not needed to satisfy this retention policy will be automatically deleted by this script. Finished Control File and SPFILE Autobackup at 08-OCT-11, ========================================================================, ORA-29702: error occurred in Cluster Group Serviceoperation.

Resetting the password for oracle 11g or 12c users with samepassword.

These scripts are a modified versions from some old scripts developed by me + some enhancement from other similar scripts . input archived log thread=1 sequence=119 RECID=1 STAMP=764028131 allocate channel t1 type DISK; allocate channelchnl1 device type disk; How to create asmsnmp user in ASMinstance(11g). Learn how your comment data is processed. For reference i am here with attaching the same. Backup database Scripts Create a free website or blog at WordPress.com. Well, unless you have lots of money to allocate for storage, we know that is not practical to keep all archivelogs and with OS backups usually we delete them manually according to the chosen backup retention pollicy. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/autobackup_control_file%F'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK; BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '/u01/databasefiles_%d_%u_%s_%T'; BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/u01/archivelogs_%d_%u_%s_%T' DELETE INPUT; BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT '/u01/controlfile_%d_%u_%s_%T'; Note: If you run this script on a database which was being backed up using OS methods and user managed backups, initially it will fail as it will look to satisfy the ARCHIVELOG ALL clause. Note: If you run this script on a database which was being backed up using OS methods and user managed backups, initially it will fail as it will look to satisfy the ARCHIVELOG ALL clause. 9> release channel chnl2; Fill in your details below or click an icon to log in: You are commenting using your WordPress.com account. But the story is so interesting I am going to go with Cause The Concurrent log file detail. crontab, or manually, you can always sync the existing RMAN catalog (or controlfile) by crosschecking what is there on the disk before you run it with the following command from RMAN: This will crosscheck existing archivelogs and will show you the ones which are EXPIRED and need to be deleted from the RMAN catalog, that is, they are not on the disks anymore, cause you have deleted them not using RMAN. then CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default echo ========== started on `date` ========== >> $lg release channel ch02;

cat <> $lg Start the restore and recover process if you want database up to specific time then only need to give set until time Database Systems is a blog about Databases and Data of any size and shape. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default Preliminary Tasks before running Adadmin: 1. The script once run initially will fail like this: As you can see the script assumes that you have all archivelogs, if that is not the case (most likely), and you have been periodically deleting them ie. Webinar:10 of the Craziest Cyberattacks and How You Can Avoid Them. crontab, or manually, you can always sync the existing RMAN catalog (or controlfile) by crosschecking what is there on the disk before you run it with the following command from RMAN: This will crosscheck existing archivelogs and will show you the ones which are EXPIRED and need to be deleted from the RMAN catalog, that is, they are not on the disks anymore, cause you have deleted them not using RMAN. {Please fully test these scripts before using them in your specific environment} , # *********************************************************************** # * DESCRIPTION: Take rman full hot backup(incremental level 0 ) * channel chnl1: backup set complete, elapsed time: 00:01:08 I ran the same script in my test database and worked fine. Bring the database at mount state For hot backup through RMAN you must be enabled archive log at database level. CONFIGURE CONTROLFILE AUTOBACKUP ON; Bring the database in startup nomount.

channel chnl1: starting full datafile backup set channel chnl1: starting piece 1 at 08-OCT-11 Hi, I am working in IT industry with having more than 10 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc You can save the following script as Fullbackup.rcv in /u01/rmanbackup directory. All rights reserved. allocate channel t1 type DISK; 3. Running the environment file. $ rman target sys/ @DB_HOT_BACKUP_using_RMAN.rc. channel chnl1: specifying archived log(s) in backup set # allocate channel ch02 type disk; document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Oracle RMAN Database Full Hot BackupScript, Exadata Database Machine: 12c Administration Workshop, Oracle RMAN Database Full Cold BackupScript. 8> release channel chnl1; No RECOVERY CATALOG is being used with this script, instead database controlfiles are used to record the RMAN repository information. channel chnl1: starting full datafile backup set }. Please contact us at contactus@smarttechways.com, Follow Smart way of Technology on WordPress.com, Create & grant permission to directory in Oracle, Check the Size of Oracle Database and PDB database, Exclude/Include option in EXPDP and IMPDP Datapump, Find the temp usage by sessions in Oracle, Check the Patch Applied to the Oracle Database, Check the Undo tablespace Usage in Oracle, Stop the EXPDP/IMPDP Datapump Job in Oracle, Check status, enable and disable the Audit in Oracle, Check and Change Default Tablespace for User in Oracle. echo RMAN Log File: $lg >> $lg fi, # Check that ORACLE_HOME was set Now set the DB environment using your regular method then run the following command. CONFIGURE COMPRESSION ALGORITHM BASIC AS OF RELEASE DEFAULT OPTIMIZE FOR LOAD TRUE ; # default channel chnl2: finished piece 1 at 08-OCT-11 This means you dont need to set up cronjobs or manually delete not needed backups. channel chnl2: starting piece 1 at 08-OCT-11 recover database; 2> { It is very --SQLException java.sql.SQLException: ORA-08176: consistent read failure; rollback data not available at orac CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for Oracle EBS12.2.4 Check AD and TXK patches versions applied. The RMAN hot backup script rman_backup.sh, # Declare your ORACLE environment variables, export ORACLE_BASE= (put your ORACLE BASE here), export ORACLE_HOME= (put your ORACLE_HOME here). The road to success is always under construction.. All rights reserved. It does this automatically with the commands: DELETE NOPROMPT OBSOLETE; and DELETE NOPROMPT EXPIRED BACKUP See last lines in the script. set until time "to_date('2009/02/09 07:00:00','yyyy/mm/dd HH24:MI:SS')"; Older backups and archivelogs not needed to satisfy this retention policy will be automatically deleted by this script. release channel t2; The RMAN hot backup script rman_backup.sh. 13> including current control file in backup set !!! echo ORACLE_HOME: $oh >> $lg ORA-08176: consistent read failure; rollback data not available, Check AD and TXK patches versions applied in R12.2.4, ORA-28374: typed master key not found in wallet, how to create dba directory in oracle 11g, how to relink all fnd executables using adadmin (R12.2.4), "FRM-92095; Oracle Jinitiator Version too Low. # dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl disable crs Note:This is step is [Optional] and it can required during maintenance operation like firmware patches which requires to reboot the Compute Node several times.

run{ Specify the time up to which you want to recover the database otherwise it will upto last full backup. Compiles all invalid views for specified schema, scheduler information for running jobs Scripts (10g). That is it will try to backup archivelogs since day 1. I was asked by one of my customers to develop some rman backup/restore scripts. } } Following is the first script in the series, it to fully backup the database while it is open. restore database; using target database control file instead of recovery catalog Check it with archive log list; command in SQL PROMPT. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO %F; # default It's hard to find knowledgeable people on this topic, but you sound like you know what you're talking about!ThanksAlso visit my blog post :: check our slotsforrealmoney.com, Doesn't work.Once you change the db_name in the control file, it won't let u mount the db cuz the names don't match. piece handle=/u01/product/flash_recovery_area/TEST/backupset/2011_10_08/o1_mf_annnn_TAG20111008T220550_790yz6vq_.bkp tag=TAG20111008T220550 comment=NONE (LogOut/ (LogOut/ #************************************************************************ release channel t1; channel chnl1: finished piece 1 at 08-OCT-11 release channel chnl2; A backup retention policy with a recovery window of 2 days is defined in this script. backup as compressed backupset incremental level 0 database tag 'weekly_hot_backup' plus archivelog tag 'weekly_hot_backup'; echo ========== Completed at `date` ========== >> $lg. Hot backup means, taking the backup of the database while it is up running. SQL> startup pfile='/home/oracle/initORA11G.ora'; ORACLE instance started. backuparchivelog all; 12> RESTORE DATABASE; using target database control file instead of recovery catalog, RMAN configuration parameters for database with db_unique_name TEST are: Example:

sql "alter database mount"; channel chnl1: starting piece 1 at 08-OCT-11

input datafile file number=00004 name=/u01/product/oradata/TEST/users01.dbf To delete these misleading entries from your control file you will have to run the command: After you delete the expired archivelog records from the control file you can run the script and take your backups. 2. (LogOut/ Backup the database with RMAN as follows:

Site is undergoing maintenance

The Light Orchestra

Maintenance mode is on

Site will be available soon. Thank you for your patience!

Lost Password