Sybase Database in a SAN Environment Using EVA Snapclone Technology (August 2007)

Total System Global Area 135352820 bytes

Fixed Size 455156 bytes

Variable Size 109051904 bytes

Database Buffers 25165824 bytes

Redo Buffers 679936 bytes

Control file created.

This command creates new control files for the clone. These files are stored on the

directory specified by the clone’s initialization control_files parameter.

In Step 7, the most recent online redo logfiles of the production database DB1 are

archived. However, traffic to the database is still flowing. User’s records keep filling

up the active online redo logfiles. Hence, you must check which online redo logfiles

are not archived. Use the following SQL command on the DB1 instance to perform

this task:

Note:

The redo03a.log and redo03b.log files are not the current redo log files.

SQL> select a.group# "GROUP", a.member, b.status "STATUS", b.archived

from v$logfile a, v$log b where a.group#=b.group# and b.archived='NO';

SQL> /

GROUP

----------

MEMBER

------------------------------------

STATUS ARC

---------------- ---

/prod/log_1/redo03a.log

CURRENT NO

/prod/log_2/redo03b.log

CURRENT NO

The redo03a.log and redo03b.log files are not archived. Copy these files to the

cloned database TEST archive logs directory for later use. If a new archived logfile is