Скачать с ютуб SAP ASE 16 Sybase ASE Advanced Backup Techniques | Sybase Backup Restore в хорошем качестве

SAP ASE 16 Sybase ASE Advanced Backup Techniques | Sybase Backup Restore

Lab 11: Performing Backup and Recovery Lab 11a: Creating and Managing Dump Configurations 1. Lists all dump configurations: sp_config_dump go Configuration name ------------------- dmp_cfg1 dmp_cfg2 dmp_cfg3 2. Lists parameter values for a dump configuration called dmp_cfg1: sp_config_dump 'dmp_cfg1' go Dump configuration: dmp_cfg1 3. Creates a new dump configuration called dmp_cfg2 that specifies that a dump operation creates 5 stripes in the /work1/dmp_dir stripe directory, and that retries once if it fails with a nonfatal error: sp_config_dump 'dmp_cfg2', @stripe_dir='/work1/dmp_dir', @num_stripes='5', @retry='1' 4. Changes the stripe directory of an existing dump configuration: sp_config_dump 'dmp_cfg2', @stripe_dir='/work2/dmp_dir' 5. Deletes a dump configuration: sp_config_dump 'dmp_cfg2', 'delete' Sequence 1. Perform Backup 1. Dumps the database using the dmp_cfg2 dump configuration: dump database testdb using config=dmp_cfg2 2. Dumps the database using the dmp_cfg2 dump configuration. The archive files created as part of the dump operation are password-protected: dump database testdb using config=dmp_cfg2 with passwd='mypass01' 3. Performs a database dump using the dmp_cfg2 dump configuration, explicitly specifying compression level 6, thereby overriding the compression level that was configured in dmp_cfg2: dump database testdb using config=dmp_cfg2 with compression=6 4. Dumps the database pubs2 to a tape device. If the tape has an ANSI tape label, this command appends this dump to the files already on the tape, since the init option is not specified: dump database pubs2 to "/dev/nrmt0" 5. (UNIX only) dumps the pubs2 database, using the REMOTE_BKP_SERVER Backup Server. The command names three dump devices, so the Backup Server dumps approximately one-third of the database to each device. This command appends the dump to existing files on the tapes. The retaindays option specifies that the tapes cannot be overwritten for 14 days: dump database pubs2 to "/dev/rmt4" at REMOTE_BKP_SERVER stripe on "/dev/nrmt5" at REMOTE_BKP_SERVER stripe on "/dev/nrmt0" at REMOTE_BKP_SERVER with retaindays = 14 6. The init option initializes the tape volume, overwriting any existing files: dump database pubs2 to "/dev/nrmt0" with init 7. Rewinds the dump volumes upon completion of the dump: dump database pubs2 to "/dev/nrmt0" with unload 8. (UNIX only) the notify clause sends Backup Server messages requesting volume changes to the client which initiated the dump request, rather than sending them to the default location, the console of the Backup Server machine: dump database pubs2 to "/dev/nrmt0" with notify = client 9. Creates a compressed dump of the pubs2 database into a local file called dmp090100.dmp using a compression level of 4: dump database pubs2 to "compress::4::/opt/bin/Sybase/dumps/dmp090100.dmp" Alternatively, you can create a compressed dump of the pubs2 database into a local file called dmp090100.dmp using a compression level of 100 using compression = compression_level syntax: dump database pubs2 to "/opt/bin/Sybase/dumps/dmp090100.dmp" with compression = 100 10. Dumps the pubs2 database to the remote machine called “remotemachine” and uses a compression level of 4: dump database pubs2 to "/Syb_backup/mydb.db" at remotemachine with compression = "4" 11. Dumps the pubs2 database to the TSM backup object “obj1.1”: dump database pubs2 to "syb_tsm::obj1.1" 12. Dumps the pubs2 database to the TSM backup object “obj1.2” using multiple stripes: dump database pubs2 to "syb_tsm::obj1.2" stripe on "syb_tsm::obj1.2" stripe on "syb_tsm::obj1.2" stripe on "syb_tsm::obj1.2" stripe on "syb_tsm::obj1.2" 13. Removes the last fragment in sales_db1, which is a database hole at the end of the database. select * indicates there is a hole at the end of the database: select * from sysusages where dbid=db_id("sales_db1") go dump database sales_db1 to "/tmp/sales_db1.dmp" with shrink_log go Run select * to confirm that the fragment is successfully removed: select * from sysusages where dbid=db_id("sales_db1") go Threshold - Stored procedure sp_thresholdaction Call to the Procedure sp_thresholdaction Example of the Stored Procedure Waking suspended processes Loading a transaction log to a point in time Bringing the databases online Loading database dumps from older versions Upgrading a dump to the current version sybase,sybase ase,sap sybase ase interview questions,sybase database backup and restore step by step,sap sybase database tutorial,sap sybase interview questions,sap sybase ase tutorial,sybase database,sybase ase dbcc checks,sybase tutorials,sybase ase dbcc checkcatalog,sybase ase dbcc checkstorage,how to create database roles and groups in sap sybase ase Visit www.theskillpedia.com for Online Training on this technology