. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 4. Shadow Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . manual, we will discuss the following: • Command line options for the gfix database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting for Firebird 3.0.7 usage: gfix [options] plausible options are: -ac(tivate_shadow) activate shadow file for database usage -at(tach) shutdown new database attachments -b(uffers)

5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 5.2.2. DROP SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . you have to connect to it. The statement deletes the primary file, all secondary files and all shadow files. Only administrators have the authority to use DROP DATABASE. Example Deleting the database

5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 5.2.2. DROP SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . you have to connect to it. The statement deletes the primary file, all secondary files and all shadow files.  Contrary to CREATE DATABASE and ALTER DATABASE, DROP SCHEMA is not a valid alias for

.................. 99 SHADOW ................................................................................................................................. 99 CREATE SHADOW ...................... ............................................................ 100 Необязательные параметры CREATE SHADOW .............................................. 101 Кто может создать теневую копию? ........... ...................................................................................... 101 DROP SHADOW ................................................................................................

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2.3. Shadow Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . initial file, and each file has a header page (page type 0x01) at the start of the file. 2.3. Shadow Files Shadow files are additional files that can be used by single and multiple file databases to assist case of a DROP DATABASE as the Chapter 2. Database Structure 3 shadow file(s) — being part of the database — are also dropped! Shadow files are updated as the database main file(s) are updated and in

. . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6.10. Backup & Restore With & Without Shadow Files. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6.11. Remote restored database will be inactive. -K[ILL] This switch restores the database but doesn’t recreate any shadow files that existed previously. -M[ETA_DATA] See above. -MO[DE] This switch allows the Backup & Restore With & Without Shadow Files. Databases can have shadow files attached in normal use. Gbak happily backs up and restores those as well and in normal use, shadow files will be recreated. Should

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 104 5.2. SHADOW. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 5.2.1. CREATE SHADOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 5.2.2. DROP SHADOW . . . . . . . . . Sie sich mit ihr verbinden. Die Anweisung löscht die Primärdatei, alle Sekundärdateien und alle Shadow-Dateien.  Im Gegensatz zu CREATE DATABASE und ALTER DATABASE ist DROP SCHEMA kein gültiger Alias

dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache obj_in_use Object is in use -904 335544455 shadow_accessed Cannot attach active shadow file -904 335544460 shadow_missing A file in manual shadow is unavailable -904 335544661 index_root_page_full

dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache 335544453 obj_in_use Object %s is in use -904 335544455 shadow_accessed Cannot attach active shadow file -904 335544460 shadow_missing A file in manual shadow %ld is unavailable -904 335544661 index_root_page_full

dsql_shadow_number_err Shadow number must be a positive integer -599 335544607 node_err Gen.c: node not supported -599 335544625 node_name_err A node name is not permitted in a secondary, shadow, cache in use Firebird 2.1 Error Codes -904 335544455 shadow_accessed Cannot attach active shadow file -904 335544460 shadow_missing A file in manual shadow @1 is unavailable -904 335544661 index_root_page_full