Problem Description
After creating physical standby database, whenever it was tried to add standby logfile while standby database is in recovery process it fails with error ORA-01156.
SQL> alter database add standby logfile thread 2;
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
Cause of the Problem
The standby database is in managed standby mode and you cannot add standby redo log while the database is in managed recovery mode.
Solution of the Problem
In order to solve the problem in the standby database just follow simple three steps.
Step 01: Cancel managed recovery mode.
SQL> alter database recover managed standby database cancel;
Step 02: Add the Standby logfile.
SQL> alter database add standby logfile group {n} {filename} size {size};
Step 03: Reinstate Managed Recovery Mode.
SQL> alter database recover managed standby database disconnect from session;
Friday, September 30, 2011
ORA-01156 while issuing alter database add standby logfile
| Reactions: |
Wednesday, September 28, 2011
In ActiveCollab Print preview layout as default layout in chrome
In ActiveCollab whenever any user use Google chrome and login as well as do any activities on Chrome browser always a banner appears across the pages saying "Print Preview" and close button. In Firefox and other browser, we don't see this issue.
The problem with alternate stylesheet is caused by the fact that the link tag doesn't have - a title! Chrome browser respects that and shows the Print Preview across pages.
In order to fix it quick just
1) open the file /activecollab_installation_dir/application/modules/system/layouts/wireframe.tpl in a text editor
2)Find the line 17, which should look something like this:
<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" />
3) Replace that line of code with this one:
<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" title="Print Preview" />
Save it, upload in server and reload page.
The problem with alternate stylesheet is caused by the fact that the link tag doesn't have - a title! Chrome browser respects that and shows the Print Preview across pages.
In order to fix it quick just
1) open the file /activecollab_installation_dir/application/modules/system/layouts/wireframe.tpl in a text editor
2)Find the line 17, which should look something like this:
<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" />
3) Replace that line of code with this one:
<link rel="alternate stylesheet" href="{$assets_url}/print_preview.php?theme_name={$theme_name}" type="text/css" media="screen" id="print_preview_css" disabled="true" title="Print Preview" />
Save it, upload in server and reload page.
| Reactions: |
Subscribe to:
Posts (Atom)
Tag Cloud
10.2g
10g
11g
11gR2
Abasa
About Oracle
Administration
Adsense
Alerts
Archival
ASM
ASP.Net
Audit
Audit Vault
Backup
Bangladesh
Block Corruption
Blogger
Browser
Bug
Business
Clone
Clusterware
Comments
Concepts
Connection
Controlfiles
Crime
CSS
Data Block
Data Dictionary
Data Guard
Data Mining
Data Pump
Data Type
Database Administration
Database Vault
DBConsole
Developer
Economics
EM
Excel
Exercise
Explain plan
Export
External Table
Facebook
Firefox
Firmware
Flashback
Forum
Functions
Games
Globalization Support
Grid Control
Hardware
History
HTML
IE
Import
Indexes
initializaion parameter
initialization parameter
Installation
Internals
Internet
Interview
isql*plus
Java
JavaScript
Job
Joins
Joke
Limitation
Linux
Listener
Logminer
Magento
Mail
Materialized View
Medical
Memory
Mobile
Money
Multimedia
MySQL
Net Services
Network
OCP
Operators
Oracle
Oracle Concepts
Oracle Recovery
OS
Others
OUI
Package
Packages
Parameters
Partitioning
Patchset
Performance
Perl
Pfile
Photos
PHP
PL/SQL
Profile
Pseudocolumns
Puzzle
Quiz
Quota
RAC
RAC Installation
Recovery
Recovery Problems
Redo Log
Reports
RMAN
Scripts
Security
SEO
Server Administration
SGA
Shell Script
Smarty
Social Marketing
Solaris
Spfile
SQL
SQL Tuning
SQL*Loader
Sql*Plus
Startup Problem
Streams
SwingBench
System Analysis
Tablespaces
Technology
Temp
TNS Error
Tools
Troubleshooting
Tuning
Undo
UNIX
Upgradation
Utilities
Version
Views
Vmware
Windows
Wordpress
XML