Oracle

Startup / Shutdown

Login to SQL prompt:

sqlplus / as sysdba

Startup 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.

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;

Determine if database is standby

select CONTROLFILE_TYPE from v$database;

Manually register a logfile

It is sometimes necessary to manually add a logfile if one misses the transport or so.

alter database register logfile '/full_path_to/logfile';

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

Standby database

• Oracle - Managing a Physical Standby Database