The SAS 9.3 Metadata
Server has the ability to back up and recover itself. Backups are
initiated by a dedicated scheduler thread that is started when the
metadata server is started. Backups are executed in a dedicated backup
thread that is started as needed, so that backups do not interrupt
the regular operation of the metadata server. When a server recovery
is requested, the recovery process is executed in the backup thread.
The SAS 9.3 Metadata
Server is configured with a default backup configuration and backup
schedule by SAS 9.3 configuration processes. The default backup schedule
performs daily backups at 1 a.m., and writes them to a
Backups
subdirectory
of the
MetadataServer
directory in
your SAS configuration directory. Backups are retained for seven days,
and run unassisted unless you want to modify the default backup configuration
or backup schedule. The Monday morning backup includes a REORG process
that releases unused disk space from repository data sets. The REORG
process temporarily pauses the server to an offline state. Therefore,
it needs to run when server activity is low. The server backup facility
supports ad hoc backups and server recovery with an optional roll-forward
capability.
You can modify the default
backup configuration and backup schedule in SAS Management Console
by opening the Server Backup node in the SAS Management Console Metadata
Manager (this is the recommended method), or by using PROC METAOPERATE.
You can perform ad hoc backups and request a recovery using both tools.
PROC METAOPERATE supports
two options that are not supported in SAS Management Console.
-
an option to rebuild or restart
the scheduler thread in case backups are not occurring as scheduled.
See ACTION=
REFRESH and
<SCHEDULER/>.
-
an option to interrupt the recovery
process in the event that it stops responding. See ACTION=
PAUSE, ACTION=
RESUME, and
<FORCE/>.
The PROC METAOPERATE
<RECOVER/> option supports a ROLL_FORWARD= attribute that enables
you to request roll-forward recovery to a specified datetime value.
The metadata server log records datetime values in server local time.
The ROLL_FORWARD= attribute requires input in GMT time. Backup names
contain information that you can use to convert server local time
values to GMT time values.
Backups are named with
a date-and-time stamp in ISO 8601 format. The ISO 8601 format is a
server local datetime value that includes the GMT offset at the end
of the string. For example, consider the backup name:
2010-09-20T0_59_59-04_00
The
numbers preceding the T are the date: September 20, 2010. The numbers
immediately following the T are the server local time (0_59_59). The
-04_00 at the end of the time is the GMT offset. In this case, the
backup was made just before 1 a.m. server local time. The minus offset
indicates that the time value is four hours less than GMT. A timezone
that is greater than GMT has a plus offset (+7_00). Use the GMT offset
in your backup names to determine how you need to adjust the input
value from the server log.
Tip
To avoid having to make the
conversion, you can use SAS Management Console to perform recoveries.
The SAS Management Console Server
Backup Recovery window
enables you to specify the roll-forward value in server local or GMT
time.
The following table
summarizes backup-related tasks that can be performed with PROC METAOPERATE:
|
|
|
change the default backup
location, retention policy, or turn off scheduled backups
|
|
<BACKUPCONFIGURATION attribute(s)/>
|
modify the backup schedule
|
|
<SCHEDULE EVENT="BACKUP"
WEEKDAY n=" timevalue"/>
|
|
|
|
recover the server from
a backup
|
|
<RECOVER BACKUPNAME=" name"
| BACKUPPATH=" pathname" options/>
|
restart the scheduler
thread
|
|
|
regain control of the
metadata server during the recovery process in the event that the
recover process stops responding
|
|
|
Backups are monitored
in the Server Backup node of the SAS Management Console Metadata Manager
or by using PROC METADATA.
For more information, see METADATA Procedure.