RMAN backup in noarchivelog mode


RMAN> run {
2> backup database format '/u01/stage/db_%U';
3> backup current controlfile format '/u01/stage/cntrl_%U';
4> backup spfile format '/u01/stage/spfile_%U';
4> sql "alter database backup controlfile to ''/u01/stage/control.ctl'' reuse";
4> sql "alter database backup controlfile to trace as ''/u01/stage/control.trc'' reuse";
4> sql "create pfile=''/u01/stage/pfile.ora'' from spfile";
5> }

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: