Coments are closed
Here we will see, how to enable and disable flashback in oracle. ENABLE FLASHBACK: Make sure the database is in archive log mode: Refer: How to enable and disable archive log To enable flashback we need to set two parameters: DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE. Changing Archive Log Destination In this article you will learn how to change the destination for archived redo log files. Sometime the location where archive redo log is full and you can not access the database.there are two way to this. SQL> alter system SET DB_RECOVERY_FILE_DEST_SIZE = 10G SCOPE=BOTH SID='orca'; System altered. Oracle: Relocate Fast-Recovery-Area (FRA) The absolute path to each file is recorded in the DB, so that the change of the db_recovery_file_dest is no problem for existing files. But keep in mind, that the overall size of files in the old db_recovery_file_dest adds up to the total size of our FRA.
I'm new to Oracle. I was learning Backup and Recovery. For that, I did
$ sqlplus system/password
SQL> alter system set db_recovery_file_dest_size=8gb scope=both;
But I got error this error:-enter image description here
Can anyone tell me the exact solution? Please do tell me the specific solution with all the steps to do.
SQL> alter system set db_recovery_file_dest_size=8g scope=both;
Grand Theft Auto: San Andreas Free Download Full Version PC Game Cracked in Direct Link and Torrent,GTA San Andreas Highly Compressed Free Download Full Version. Grand Theft Auto: San Andreas is an action-adventure video game. In Grand Theft Auto San Andreas highly Compressed game with Crack & Patch included, A few years back Carl Johnson relieved himself from the life which was full of pressures in Los Santos, San Andreas, A place that was infused with corruption, drugs and gang troubles. A place where the big fishes like millionaires and film stars try their best to stay out of these all troubles. GTA San Andreas is a 2004 production as the second open world action and adventure game.The first product released in 2003 and you can download GTA Vice City Game for PC and I am sure you heard about the last introduced installment. I have already published that almost two weeks ago, but hope well. Let’s see what happens in the next few days. GTA San Andreas is an Action-Adventure video game that was released in 26 October, 2004. Today you can easily download GTA San Andreas game for PC from our website. Gta san andreas is action game today you can download this from our website free full version 100 percent working no surveys get it free of cost. Gta san andreas full game for pc download.
Dmitry DeminDmitry DeminOracle Automatic Storage Management (ASM) FAQ
ASM should be installed separately from the database software in its own ORACLE_HOME directory. This will allow you the flexibility to patch and upgrade ASM and the database software independently.
Several databases can share a single ASM instance. So, although one can create multiple ASM instances on a single system, normal configurations should have one and only one ASM instance per system.
For clustered systems, create one ASM instance per node (called +ASM1, +ASM2, etc).
Generally speaking one should have only one disk group for all database files - and, optionally a second for recovery files (see FRA).
Data with different storage characteristics should be stored in different disk groups. Each disk group can have different redundancy (mirroring) settings (high, normal and external), different fail-groups, etc. However, it is generally not necessary to create many disk groups with the same storage characteristics (i.e. +DATA1, +DATA2, etc. all on the same type of disks).
To get started, create 2 disk groups - one for data and one for recovery files. Here is an example:
Here is an example how you can enable automatic file management with such a setup:
You may also decide to introduce additional disk groups - for example, if you decide to put historic data on low cost disks, or if you want ASM to mirror critical data across 2 storage cabinets.
In 11gR2, an ASM Instance can have up to 63 disk groups, 10,000 disks and 1 million files for each disk group.In 12c, an ASM instance can have up to 511 disk groups, the other limits are not changed.
No, tables and indexes can be stored within a single disk group. Do not create different disk groups for tables and indexes.
Login to your +ASM instance (SYS AS SYSDBA) and execute the following query:
From Oracle 10g Release 2, one can also use the asmcmd command line utility:
Use uniform sized files (say 2 or 4 GB each). Reason being that the a 2TB datafile will unnecessarily extend backup and recovery times.
The asmcmd utility appears to be very slow. This slowness is a result of queries against the v$asm_diskgroup view. To solve this problem edit the $ORACLE_HOME/bin/asmcmdcore script and change all v$asm_diskgroup references to v$asm_diskgroup_stat.
V$asm_diskgroup and v$asm_diskgroup_stat provides exactly the same information, but the %_stat view operates from cache, while v$asm_diskgroup rescans all disk headers. This method is also used by Oracle in their Enterprise Manager product.
ASM disk headers (superblocks) cannot be backed up and restored in Oracle 10g. By implication, if you use EXTERNAL REDUNDANCY and a single disk's header is accidentally overwritten, the entire disk group will have to be restored. To solve this problem, Oracle introduced the md_backup and md_restoreasmcmd commands in Oracle 11g.In Oracle 10g, the only viable method to prevent logical corruption of ASM header block is to add failgroup, storage vendor has no responsibility to verify/checksum ASM disk header blocks (EXTERNAL REDUNDANCY is not going to help). There is a kfed utility to backup ASM disk headers and restore them for LIMITED scenario. It is best to be executed under guidance of a few elite support engineers. Oracle did not advertise the utility due to the potential damage it could cause. For those unrecoverable (tedious manual fixes) cases, restoring disk group is the last resort.
The trick is to create an SPFILE and restart the instance before issuing the CREATE DATABASE statement:
Point all OMF files into ASM:
Issue the create database command: