standby 管理和维护（Standby management and maintenance）.docVIP

standby 管理和维护（Standby management and maintenance） Standby management and maintenance Personal classification: basic knowledge Standby management and maintenance Query Library status: SQLselect, name, switchover_status, open_mode, protection_mode, database_role, from, v$database; Verify that archive log receives and applied. SQLalter, session, set, nls_date_format=yyyy-mm-dd, hh24:mi:ss; SQLselect, sequence#, dest_id, archived, applied, deleted, status, first_time, from, v$archived_log, sequence#, order, by,..; Boot to management mode: SQL shutdown immediate; SQL startup nomount SQL, alter, database, mount, standby, database; SQL, recover, managed, standby, database, disconnect, from, session; Dear sirsre SQL, alter, database, recover, managed, standby, database, disconnect, session, from; After 10g, online logging is used to deliver the message SQL, recover, managed, standby, database, using, current, logfile,, disconnect, from, session; Boot to read-only mode: SQL shutdown immediate; SQL startup nomount SQL, alter, database, mount, standby, database SQL, alter, Databae, open, read, only; In management mode, revert to read-only mode: SQL, recover, managed, standby, database, cancel; SQL, alter, database, open, read, only In read-only mode, temporary data files can be added to the database (in the case of RMAN backups that are not backed up), and standby will be provided with read-only services or switched to a master library, preferably by adding temporary files SQL, alter, tablespace, temp, add, tempfile,C:\oracle\product\10.2.0\oradata\dgtest\temp02.dbf, size, 100m; Read only mode to management mode SQL, recover, managed, standby, database, disconnect, from, session; Backup in Library 1. stop the application, jump to the read only mode, and use the backup database command to back up the database, so that the database is in consistency mode 2. backup backup control file after completion SQL, alter, database, backup, controlfile, to,File, name; Master backup switchi