wiki.janforman.com oraclehttps://wiki.janforman.com/2026-04-21T11:58:22+00:00FeedCreator 1.8 (info@mypapit.net)oracle:archivemode2016-03-16T21:16:12+00:002016-03-16T21:16:12+00:00https://wiki.janforman.com/oracle:archivemodeAnonymousanonymous@undisclosed.example.comFlash Recovery Area
Noarchive log mode
If the database is in noarchive log mode, online redo logs can (and will) be overwritten without making sure they are saved. This implies that a database cannot be recovered even if backups were made.
Archive log modeFlash Recovery Area
Noarchive log mode
If the database is in noarchive log mode, online redo logs can (and will) be overwritten without making sure they are saved. This implies that a database cannot be recovered even if backups were made.
Archive log modeoracle:backup2017-11-02T13:57:21+00:002017-11-02T13:57:21+00:00https://wiki.janforman.com/oracle:backupAnonymousanonymous@undisclosed.example.comLinux backup scripts
/asmfs/rman_cmds/backup.sh
#!/bin/bash
if [ ! $1 ]
then
echo no parameter
exit 1
fi
export PATH=$PATH:/usr/local/bin
. /usr/local/bin/oraenv <<EOF
$2
EOF
export ORASID=$2
export ORACLE_SID=${2}1
rman nocatalog cmdfile=/asmfs/rman_cmds/$1 using $ORASIDLinux backup scripts
/asmfs/rman_cmds/backup.sh
#!/bin/bash
if [ ! $1 ]
then
echo no parameter
exit 1
fi
export PATH=$PATH:/usr/local/bin
. /usr/local/bin/oraenv <<EOF
$2
EOF
export ORASID=$2
export ORACLE_SID=${2}1
rman nocatalog cmdfile=/asmfs/rman_cmds/$1 using $ORASIDoracle:install2021-02-23T16:07:53+00:002021-02-23T16:07:53+00:00https://wiki.janforman.com/oracle:installAnonymousanonymous@undisclosed.example.comOracle ASM
<https://www.oracle.com/linux/downloads/linux-asmlib-rhel7-downloads.html>
<https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/kmod-oracleasm-2.0.8-28.0.1.el7.x86_64.rpm>
yum install sg3_utils -y
<https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tdprc/preparing-your-cluster.html>
Set OS Limits
/usr/sbin/groupadd -g 1000 oinstall
/usr/sbin/groupadd -g 1001 dba
/usr/sbin/groupadd -g 1002 asmdba
/usr/sbin/useradd -u 1100 –g oinstall -G dba,asmdba -…Oracle ASM
<https://www.oracle.com/linux/downloads/linux-asmlib-rhel7-downloads.html>
<https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/kmod-oracleasm-2.0.8-28.0.1.el7.x86_64.rpm>
yum install sg3_utils -y
<https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tdprc/preparing-your-cluster.html>
Set OS Limits
/usr/sbin/groupadd -g 1000 oinstall
/usr/sbin/groupadd -g 1001 dba
/usr/sbin/groupadd -g 1002 asmdba
/usr/sbin/useradd -u 1100 –g oinstall -G dba,asmdba -…oracle:startup2018-02-28T13:10:18+00:002018-02-28T13:10:18+00:00https://wiki.janforman.com/oracle:startupAnonymousanonymous@undisclosed.example.comCentOS/RedHat 6
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database software.
ORA_HOME=/opt/oracle/product/12.1.0/dbhome_1
ORA_OWNER=oracle
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
# Remove "&" if you don't want startup as a background process
su …CentOS/RedHat 6
#!/bin/sh
# chkconfig: 345 99 10
# description: Oracle auto start-stop script.
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database software.
ORA_HOME=/opt/oracle/product/12.1.0/dbhome_1
ORA_OWNER=oracle
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
# Remove "&" if you don't want startup as a background process
su …