Oracle: verschil tussen versies
Uit Documents
| Regel 87: | Regel 87: | ||
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2'; | CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2'; | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | == Standby database == | ||
| + | Start standby database | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SQL> startup nomount; | ||
| + | SQL> alter database mount standby database; | ||
| + | SQL> alter database recover managed standby database disconnect from session; | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | Stop standby database | ||
| + | <syntaxhighlight lang="sql"> | ||
| + | SQL> alter database recover managed standby database cancel; | ||
| + | SQL> shutdown immediate; | ||
</syntaxhighlight> | </syntaxhighlight> | ||
| Regel 93: | Regel 107: | ||
== Links == | == Links == | ||
| + | === Backup === | ||
* [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/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] | * [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://www.shutdownabort.com/dbaqueries/Backup_DataGuard.php Shutdown-Abort - Backup - DataGuard] | ||
* [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files] | * [http://psoug.org/reference/control_file.html psoug.org - Oracle Control Files] | ||
| + | === Standby database === | ||
| + | * [http://download.oracle.com/docs/cd/B10501_01/server.920/a96653/manage_ps.htm Oracle - Managing a Physical Standby Database] | ||
Versie van 9 aug 2011 om 11:06
Inhoud
Startup / Shutdown
Login to SQL prompt:
sqlplus / as sysdbaStartup normally
SQL> startup;Startup without actually mounting
SQL> startup nomount;Use additional initialization file:
SQL> startup nomount pfile='/path/to/init.ora';Shutdown:
SQL> shutdown;Shutdown and terminate existing connections
SQL> shutdown immediate;Shutdown and abort everything (last resort):
SQL> shutdown abort;RMAN
Segmentation Fault while running sbttest
Netbackup server was unable to resolve clients ip address. Added an entry to the /etc/hosts file and the issue was solved.[1]
Make disk backup
rman target /(@sid) NOCATALOG
RUN {
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';
ALLOCATE CHANNEL d2 DEVICE TYPE DISK FORMAT '<location>/bck_%s_%p_%t';
BACKUP DATABASE PLUS ARCHIVELOG;
RELEASE CHANNEL d2;
RELEASE CHANNEL d1;
}
RUN {
ALLOCATE CHANNEL d1 DEVICE TYPE DISK FORMAT '<location>/cntrl_%s_%p_%t';
BACKUP CURRENT CONTROLFILE (FOR STANDBY);
RELEASE CHANNEL d1;
}Make backup of control file from SQL prompt
SQL> ALTER DATABASE BACKUP CONTROLFILE TO '<location>';Restore disk backup
SQL> startup nomount;
RMAN> RESTORE CONTROLFILE FROM '<location>';
SQL> alter database mount;
RMAN> RESTORE DATABASE;Make backup using Netbackup
rman target /(@sid) NOCATALOG
RUN {
ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";
BACKUP FORMAT 'bk_%s_%p_%t' DATABASE;
RELEASE CHANNEL t1;
}
RUN {
ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";
BACKUP FORMAT 'al_%s_%p_%t' ARCHIVELOG ALL;
RELEASE CHANNEL t1;
}
RUN {
ALLOCATE CHANNEL t1 DEVICE TYPE 'SBT_TAPE' parms="ENV=(NB_ORA_POLICY=<POLICY>,NB_ORA_SERV=<BACKUP_SERVER>, NB_ORA_CLIENT=<CLIENT_NAME>)";
BACKUP FORMAT 'cntrl_%s_%p_%t' CURRENT CONTROLFILE (FOR STANDBY);
RELEASE CHANNEL t1;
}Manually add backup files to catalog
CATALOG BACKUPPIECE '/location/backupfile1', '/location/backupfile2';Standby database
Start standby database
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect from session;Stop standby database
SQL> alter database recover managed standby database cancel;
SQL> shutdown immediate;References
Links
Backup
- Oracle - Recovery Manager Maintenance Tasks
- Oracle - RMAN Restore
- Oracle - Creating a Standby Database with Recovery Manager
- Shutdown-Abort - Backup - DataGuard
- psoug.org - Oracle Control Files
