SQL

First of all you need to cancel the standby recover process which will apply all the archivelogs and files on the standby side. This can be done by the following command:

SQL> recover managed stanbdy database cancel;

Afterwards you need to adjust the file management parameter to be able to manual change those files:

SQL> alter system set STANDBY_FILE_MANAGEMENT=MANUAL;

Since you already created the logfiles for the standby and the primary as pointed out. You need to shutdown the Standby database at this point, this is not a big deal incase the Standby will ask for all the missing files once it ist started up again.

SQL> shutdown immediate;

To be able to access the file that the standby thinks is in use at this moment, you need to set the following line within your init-file:

*.log_file_name_convert='dummy','dummy';

Restart your standby database.

startup mount;

And now you can drop your logfile goups like this:

SQL> ALTER DATABASE DROP LOGFILE GROUP X;

Now the file and group that has a problem should be deleted and you can recreate it:

ALTER DATABASE
ADD LOGFILE GROUP X ('$PATH/logfile1a.log', '$PATH/logfile1b.log')
SIZE XXXM REUSE;

At this point your standby database should be able to use the file again.

OperatingSystem:

ProgrammingLanguage:

Technology:

The Mason approach is based on MVC, therefore you need to define the database connection within your Base.mc as follows:

<%init>
my $conn = DATABASE_NAME::DBI->conn();
my $sconn = DATABASE_NAME::DBI->session_conn();


Afterwards e.g. in your index.mi you need to define another init section in which you can execute your actual query to gather informations from your Database:

<%init>
my $dbh = Ws21::DBI->dbh();
my $sth;
my @articles;
if (!defined $.search) {
$sth = $dbh->prepare("SELECT SOME QUERY FROM DATABASE_NAME");
$sth->execute();
}

Then you are able to call this information with perl from within your html code section like this:

% for my $article (@articles) {
...
% }

For this call it is very important that you start the perl section with % at the very beginning of the line. If it will be started with leading spaces or tabs, it will throw an exception.

OperatingSystem:

ProgrammingLanguage:

Technology:

Subscribe to SQL