rman

RMAN> show all
2> ;

RMAN configuration parameters for database with db_unique_name KIAPROD3 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'n:\backup\oracle\kiaprod\%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 10;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'n:\backup\oracle\kiaprod\%U';
CONFIGURE MAXSETSIZE TO 35000 M;
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE;
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\APP\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SNCFKIAPROD3.ORA'; # default

 

Kommentarer

Send en kommentar

Populære opslag fra denne blog

Alfa, opgradering 2024

  Alfa patchning til seneste version af RDBMS 19C. Patch 35962832 - Windows Database Jan2024 Bundle Patch 19.22.0.0.240116 Installere sidste version af "OPatch" som findes i patch 6880880 Følg README som ses i  file:///C:/Users/nen800/Downloads/p35962832_190000_MSWIN-x86-64/35962832/README.html Installere seneste version af 19C patch med følgende : Prereq: C:\Users\nen800\Downloads\p35962832_190000_MSWIN-x86-64>cd 35962832 C:\Users\nen800\Downloads\p35962832_190000_MSWIN-x86-64\35962832>opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.41 Copyright (c) 2024, Oracle Corporation.  All rights reserved. PREREQ session Oracle Home       : C:\app\oracle\product\19.0.0\dbhome_1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 12.2.0.1.41 OUI version       : 12.2.0.7.0 Log file location : C...
Læs mere

Alfa: Debugging 3

Opatch has a problem: c:\Oracle\Middleware\Oracle_FRHome1\OPatch>opatch lshomes Invoking OPatch 11.1.0.8.3 Oracle Interim Patch Installer version 11.1.0.8.3 Copyright (c) 2010, Oracle Corporation.  All rights reserved. UTIL session Oracle Home       : C:\Oracle\Middleware\Oracle_FRHome1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : n/a OPatch version    : 11.1.0.8.3 OUI version       : 11.1.0.9.0 OUI location      : C:\Oracle\Middleware\Oracle_FRHome1\oui Log file location : C:\Oracle\Middleware\Oracle_FRHome1\cfgtoollogs\opatch\opatch2019-10-14_11-12-42fm.log Patch history file: C:\Oracle\Middleware\Oracle_FRHome1\cfgtoollogs\opatch\opatch_history.txt OPatch detects the Middleware Home as "C:\Oracle\Middleware" Invoking utility "lshomes" UtilSession failed: Internal Error: WebLogic Home 'c:\Oracle\MIDDLE~1\ORACLE~2\OPatch\@WL_HOME' does ...
Læs mere

Alfa: Forms & Reports Update - Patch 17882900

Billede
The installation should follow the following thread: https://community.oracle.com/thread/3543041 1.  Ensure you are using WLS 10.3.6.  If not, apply the WLS patch first. 2.  Stop all running processes related to WLS and FMw 3.  Run the 11.1.2.2 installer.  If the installer prompts you to either "Install and Configure" or "Install - Do Not Configure", choose "Install - Do Not Configure" Started the "setup.exe" for the Patch, and promptly ran into "hpi.dll" been active and cannot be written to... Had to download "Procexp" from Microsoft and find the process "hpi.dll" process and kill it off, before the installation could continue.....
Læs mere