Oracle: verschil tussen versies
Uit Documents
| 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] | + | |
| + | == 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] | ||
| + | * [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] | ||
Versie van 9 aug 2011 om 10:14
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;
}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';
