Oracle - Bewerkingsoverzicht

Lambiek: /* Standby database */

2011-08-12T07:18:24Z

‎Standby database

2011-08-09T10:10:28Z

2011-08-09T10:06:31Z

2011-08-09T09:19:59Z

2011-08-09T09:18:56Z

2011-08-09T09:14:22Z

2011-08-09T09:11:17Z

2011-08-09T09:04:13Z

2011-08-09T09:00:13Z

2011-04-01T19:20:00Z

@@ Regel 106: / Regel 106: @@
 <syntaxhighlight lang="sql">
 select CONTROLFILE_TYPE from v$database;
 </syntaxhighlight>

@@ Regel 90: / Regel 90: @@
 == Standby database ==
-Start standby database
+=== Start standby database ===
 <syntaxhighlight lang="sql">
 SQL> startup nomount;
@@ Regel 97: / Regel 97: @@
 </syntaxhighlight>
-Stop standby database
+=== Stop standby database ===
 <syntaxhighlight lang="sql">
 SQL> alter database recover managed standby database cancel;
 SQL> shutdown immediate;
 </syntaxhighlight>

@@ Regel 87: / Regel 87: @@
 <syntaxhighlight lang="sql">
 CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';
 </syntaxhighlight>
@@ Regel 93: / Regel 107: @@
 == Links ==
 * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Oracle - Recovery Manager Maintenance Tasks]
 * [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm Oracle - RMAN Restore]
@@ Regel 98: / Regel 113: @@
 * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]
 * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files]

@@ Regel 46: / Regel 46: @@
 </syntaxhighlight>
-=== Make backup from SQL prompt ===
+Make backup of control file from SQL prompt
 <syntaxhighlight lang="sql">
 SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';

@@ Regel 44: / Regel 44: @@
 RELEASE CHANNEL d1;
+}
 </syntaxhighlight>
@@ Regel 91: / Regel 96: @@
 * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmstand.htm Oracle - Creating a Standby Database with Recovery Manager]
 * [http://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard]

@@ Regel 85: / Regel 85: @@
 == References ==
 <references />
 * [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Recovery Manager Maintenance Tasks]

← Oudere versie		Versie van 9 aug 2011 om 09:11
Regel 85:		Regel 85:
	== References ==		== References ==
	<references />		<references />
		+	* [http://download.oracle.com/docs/cd/B12037_01/server.101/b10735/maint.htm#BRBSC174 Recovery Manager Maintenance Tasks]